Res:1 SELECT DISTINCT p.* FROM wp_posts AS p LEFT JOIN wp_term_relationships ON (p.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)WHERE p.ID IN ( SELECT post_id FROM wp_postmeta WHERE (meta_key = 'featured' AND meta_value = 'Yes') GROUP BY post_id HAVING count(*) = 1) AND p.post_status = 'publish' AND post_type = 'post' AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN(4) ORDER BY RAND() LIMIT 1