מציג תוצאה אחת
SELECT SQL_CALC_FOUND_ROWS ixo_uwp_product_ratings.*, ixo_uwp_product_ratings.customers_experts_50_50 as bk_rating, ixo_posts.* FROM ixo_posts INNER JOIN ixo_postmeta ON ( ixo_posts.ID = ixo_postmeta.post_id ) LEFT JOIN ixo_uwp_product_ratings on ixo_uwp_product_ratings.product_id = ixo_posts.ID LEFT JOIN ixo_wc_product_meta_lookup wc_product_meta_lookup ON ixo_posts.ID = wc_product_meta_lookup.product_id WHERE 1=1 AND ( ixo_posts.ID NOT IN ( SELECT object_id FROM ixo_term_relationships WHERE term_taxonomy_id IN (7) )
) AND ( ixo_postmeta.meta_key = '_price'
) AND ((ixo_posts.post_type = 'product' AND (ixo_posts.post_status = 'publish' OR ixo_posts.post_status = 'acf-disabled' OR ixo_posts.post_status = 'cwg_mailsent' OR ixo_posts.post_status = 'cwg_mailnotsent' OR ixo_posts.post_status = 'cwg_subscribed' OR ixo_posts.post_status = 'cwg_unsubscribed' OR ixo_posts.post_status = 'cwg_converted'))) AND ( ixo_posts.ID IN ( SELECT product_or_parent_id FROM ( SELECT product_or_parent_id FROM ixo_wc_product_attributes_lookup lt WHERE is_variation_attribute=0 AND term_id in (812,1433) GROUP BY product_id HAVING COUNT(product_id)=2 UNION SELECT product_or_parent_id FROM ixo_wc_product_attributes_lookup lt WHERE is_variation_attribute=1 AND term_id in (812,1433) GROUP BY product_or_parent_id HAVING COUNT(DISTINCT term_id)=2 ) temp )) GROUP BY ixo_posts.ID ORDER BY wc_product_meta_lookup.min_price ASC, wc_product_meta_lookup.product_id ASC LIMIT 0, 24
אני מבננה|הילה סטרובסקילילדים וגם למבוגרים ששכחו למה כדאי לאכול בריא
לילדים וגם למבוגרים ששכחו למה כדאי לאכול בריא