WordPress adatbázis hiba: [Unknown column 'wp_postmeta.meta_key' in 'where clause'] SELECT COUNT( DISTINCT wp_posts.ID ) AS term_count, terms.term_id AS term_count_id FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE wp_posts.post_type IN ( 'product' )
AND wp_posts.post_status = 'publish'
AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
AND
wp_term_relationships.term_taxonomy_id IN (216,217,222)
) AND (
( wp_postmeta.meta_key = '_sale_price' AND CAST(wp_postmeta.meta_value AS SIGNED) > '0' )
)
AND terms.term_id IN (205,206,246) GROUP BY terms.term_id
WordPress adatbázis hiba: [Unknown column 'wp_postmeta.meta_key' in 'where clause'] SELECT COUNT( DISTINCT wp_posts.ID ) AS term_count, terms.term_id AS term_count_id FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE wp_posts.post_type IN ( 'product' )
AND wp_posts.post_status = 'publish'
AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
AND
wp_term_relationships.term_taxonomy_id IN (216,217,222)
) AND (
( wp_postmeta.meta_key = '_sale_price' AND CAST(wp_postmeta.meta_value AS SIGNED) > '0' )
)
AND terms.term_id IN (205,206,246) GROUP BY terms.term_id
