Банда
Размер
- XLXL 0
Грешка в базата от данни на WordPress: [Table 'rebe_rebelst8635.xkbr7_wc_product_attributes_lookup' doesn't exist]SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM xkbr7_wc_product_attributes_lookup
INNER JOIN xkbr7_posts ON xkbr7_posts.ID = xkbr7_wc_product_attributes_lookup.product_or_parent_id
WHERE xkbr7_posts.post_type IN ( 'product' )
AND xkbr7_posts.post_status = 'publish'
AND (
xkbr7_wc_product_attributes_lookup.product_or_parent_id NOT IN (
SELECT object_id
FROM xkbr7_term_relationships
WHERE term_taxonomy_id IN (7)
)
)
AND xkbr7_wc_product_attributes_lookup.taxonomy='pa_razmer'
AND xkbr7_wc_product_attributes_lookup.term_id IN (84,80,81,82,83,93,297,751,752,759,686,703,719,516,517,518,233,234,509,510,514,511,521,658,512,523)
AND product_or_parent_id IN ( SELECT product_or_parent_id FROM (
SELECT product_or_parent_id
FROM xkbr7_wc_product_attributes_lookup lt
WHERE is_variation_attribute=0
AND term_id in (303)
GROUP BY product_id
HAVING COUNT(product_id)=1
UNION
SELECT product_or_parent_id
FROM xkbr7_wc_product_attributes_lookup lt
WHERE is_variation_attribute=1
AND term_id in (303)
) temp ) GROUP BY xkbr7_wc_product_attributes_lookup.term_id