string(616) "SELECT t.ID as id, t.latitude, lon.meta_value AS longitude FROM (SELECT filtered_posts.ID, lat.meta_value AS latitude FROM ( SELECT ID, post_status, post_type FROM wp_posts WHERE 1 ) AS filtered_posts LEFT JOIN wp_postmeta AS lat ON (filtered_posts.ID = lat.post_id) WHERE lat.meta_key = 'latitude' AND lat.meta_value IS NOT NULL AND filtered_posts.post_status = 'publish' AND filtered_posts.post_type = 'properties' ) AS t LEFT JOIN wp_postmeta AS lon ON (t.ID = lon.post_id) WHERE lon.meta_key = 'longitude' AND lon.meta_value IS NOT NULL"