- HomeSearch results for 'United States'
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 = 'availability' AND pm3.meta_value LIKE '%Mobile Operator%') ) GROUP BY p.ID, pm.meta_value
