Best Dental Clinics and Dental Doctors and Specialists in India
SELECT SQL_CALC_FOUND_ROWS wp0c_posts.ID FROM wp0c_posts LEFT JOIN wp0c_term_relationships ON (wp0c_posts.ID = wp0c_term_relationships.object_id) LEFT JOIN wp0c_postmeta ON (wp0c_posts.ID = wp0c_postmeta.post_id AND wp0c_postmeta.meta_key = '_listing-featured-cat' ) WHERE 1=1 AND ( wp0c_term_relationships.term_taxonomy_id IN (34) ) AND wp0c_posts.post_type = 'listing' AND (wp0c_posts.post_status = 'publish' OR wp0c_posts.post_status = 'preview' OR wp0c_posts.post_status = 'acf-disabled' OR wp0c_posts.post_status = 'tr_pending' OR wp0c_posts.post_status = 'tr_failed' OR wp0c_posts.post_status = 'tr_completed' OR wp0c_posts.post_status = 'tr_activated' OR wp0c_posts.post_status = 'pending-claimed') GROUP BY wp0c_posts.ID ORDER BY wp0c_postmeta.meta_value DESC, wp0c_posts.post_date DESC LIMIT 0, 10
