SELECT dd_posts.* FROM dd_posts LEFT JOIN dd_term_relationships ON (dd_posts.ID = dd_term_relationships.object_id) LEFT JOIN dd_term_relationships AS tt1 ON (dd_posts.ID = tt1.object_id) WHERE 1=1 AND ( dd_term_relationships.term_taxonomy_id IN (3798) AND tt1.term_taxonomy_id IN (3798) ) AND dd_posts.post_type = 'product' AND ((dd_posts.post_status = 'publish')) GROUP BY dd_posts.ID ORDER BY dd_posts.post_date DESC