Subquery with WordPress posts and post_meta

I know this is not right, although this is working.

I need to find all posts (as revenue) that is near from a given radius and location, but I need to subquery the latitude and longitude info which is in post_meta.

It’s gonna hurt your eyes, so here it is:

/*
lat -23.6480147
lng -46.704116399999975
radius 20km
6371 para km e 3959 para miles
*/
SELECT  vision_outlet.wp_posts.ID as 'ID', 
    vision_outlet.wp_posts.post_title as 'Nome', 
    (
        SELECT  vision_outlet.wp_postmeta.meta_value 
        FROM    vision_outlet.wp_postmeta
        WHERE   vision_outlet.wp_postmeta.meta_key = 'formatted_address' 
        AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
    ) as 'formatted_address' ,
    (
        SELECT  vision_outlet.wp_postmeta.meta_value 
        FROM    vision_outlet.wp_postmeta
        WHERE   vision_outlet.wp_postmeta.meta_key = 'lat' 
        AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
    ) as 'lat',
    (
        SELECT  vision_outlet.wp_postmeta.meta_value 
        FROM    vision_outlet.wp_postmeta
        WHERE   vision_outlet.wp_postmeta.meta_key = 'lng' 
        AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
    ) as 'lng',
    (
    6371 * acos( cos( radians(-23.6480147) ) * cos( radians
        ( 
            (
                SELECT  vision_outlet.wp_postmeta.meta_value 
                FROM    vision_outlet.wp_postmeta
                WHERE   vision_outlet.wp_postmeta.meta_key = 'lat' 
                AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
            )
        ) ) * cos( radians
        (  
            (
                SELECT  vision_outlet.wp_postmeta.meta_value 
                FROM    vision_outlet.wp_postmeta
                WHERE   vision_outlet.wp_postmeta.meta_key = 'lng' 
                AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
            )
        ) - radians(-46.704116399999975) ) + sin( radians(-23.6480147) ) * sin( radians
        ( 
            (
                SELECT  vision_outlet.wp_postmeta.meta_value 
                FROM    vision_outlet.wp_postmeta
                WHERE   vision_outlet.wp_postmeta.meta_key = 'lat' 
                AND vision_outlet.wp_postmeta.post_id = vision_outlet.wp_posts.ID
            )
        ) ) )
        ) as 'distance'

FROM vision_outlet.wp_posts, vision_outlet.wp_postmeta

WHERE vision_outlet.wp_posts.ID = vision_outlet.wp_postmeta.post_id
AND vision_outlet.wp_posts.post_status = 'publish'
AND vision_outlet.wp_postmeta.meta_key = 'formatted_address'
HAVING distance < 20
ORDER BY distance

The question is: Should I need to consider creating a new table or is there any way refactor this?