SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships tr1 ON (wp_posts.ID = tr1.object_id) INNER JOIN wp_term_taxonomy tt1 ON (tr1.term_taxonomy_id = tt1.term_taxonomy_id) INNER JOIN wp_term_relationships tr2 ON (tr2.object_id = wp_posts.ID) INNER JOIN wp_term_taxonomy tt2 ON (tr2.term_taxonomy_id=tt2.term_taxonomy_id) WHERE 1=1 AND tt1.taxonomy = 'category' AND tt1.term_id IN ('4') AND post_type = 'post' AND (post_status = 'publish') AND tt2.taxonomy='category' AND tt2.term_id=9 GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10