SQL Query to calculate distance on a post/meta object in WordPress

gistfile1.sql

SELECT *, ( 3959 * ACOS( COS( RADIANS(18.204540500000) ) 
                   * COS( RADIANS( latitude ) ) 
                   * COS( RADIANS( longitude ) 
                       - RADIANS(-66.450958500000) ) 
                   + SIN( RADIANS(18.204540500000 ) )
                   * SIN( RADIANS( latitude ) ) 
                 )
   ) AS distance  
FROM 
(SELECT ID, 
  post_title, 
  post_author,
  MAX(CASE WHEN meta_key='venue_lat' THEN meta_value END) latitude,
  MAX(CASE WHEN meta_key='venue_lng' THEN meta_value END) longitude
FROM `wp_posts` 
LEFT JOIN `wp_postmeta` 
  ON ID=post_id 
WHERE post_type='spot' 
  AND (meta_key='venue_lat' OR meta_key='venue_lng') 
GROUP BY ID, post_title, post_author
ORDER BY ID ASC) AS A