SELECT * FROM `gsp_terms` Where `term_id` IN (SELECT term_taxonomy_id FROM `gsp_term_relationships` WHERE `object_id` IN (SELECT object_id FROM `gsp_term_relationships` WHERE `object_id` IN (select ID from gsp_posts where post_title = '') AND `term_taxonomy_id` IN (SELECT `term_id` FROM `gsp_terms` WHERE `slug` ='' )) AND `term_taxonomy_id` IN (SELECT `term_taxonomy_id` FROM `gsp_term_taxonomy` WHERE `taxonomy` ='pa_country' )) order by name<option value="">Please select</option>