Select p.ID,pm.meta_value as latitude, pm2.meta_value as longitude from wp_posts as p, wp_postmeta as pm, wp_postmeta as pm2, wp_postmeta as pm3 WHERE post_type='listing' AND post_status='publish' AND p.ID=pm.post_id AND pm.post_id=pm2.post_id AND pm.post_id=pm3.post_id AND pm.meta_key='latitude' AND pm2.meta_key='longtitude' AND (pm3.meta_key='regional_office' AND pm3.meta_value='Yes') GROUP BY p.ID, pm.meta_value