Select p.ID,pm.meta_value as latitude, pm2.meta_value as longitude, ( 3959 * acos( cos( radians(37.7648) ) * cos( radians(pm.meta_value) ) * cos( radians(pm2.meta_value) - radians(-122.463) ) + sin( radians(37.7648) ) * sin( radians(pm.meta_value) ) ) ) as distmiles, pm8.meta_value as premium from wp_posts as p, wp_postmeta as pm, wp_postmeta as pm2, wp_postmeta as pm3, wp_postmeta as pm8 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.post_id=pm8.post_id AND pm.meta_key='latitude' AND pm2.meta_key='longtitude' AND pm8.meta_key='mark_as_premium' AND (p.ID in (pm.meta_key='zip_code' AND pm.meta_value='San Francisco California United States') OR (pm.meta_key='near_by_zip_codes' AND pm.meta_value LIKE 'San Francisco California United States') OR ( ( 3959 * acos( cos( radians(37.7648) ) * cos( radians(pm.meta_value) ) * cos( radians(pm2.meta_value) - radians(-122.463) ) + sin( radians(37.7648) ) * sin( radians(pm.meta_value) ) ) ) <= 15)) AND ((pm3.meta_key = 'availability' AND pm3.meta_value NOT LIKE '%Currently Unavailable%') ) AND (pm8.meta_key = 'mark_as_premium' AND (pm8.meta_value = 0 OR pm8.meta_value = 1)) GROUP BY p.ID, pm.meta_value, pm2.meta_value, distmiles ORDER BY CASE WHEN ( 3959 * acos( cos( radians(37.7648) ) * cos( radians(pm.meta_value) ) * cos( radians(pm2.meta_value) - radians(-122.463) ) + sin( radians(37.7648) ) * sin( radians(pm.meta_value) ) ) ) <=8 THEN pm8.meta_value END DESC, distmiles ASC