SELECT msg.*, distance FROM messages AS msg
LEFT JOIN users AS u ON u.username = msg.user
LEFT JOIN (SELECT zip_code, (((acos(sin(($zip_details->lat * pi()/180)) * sin((lat * pi()/180))+cos(($zip_details->lat * pi()/180)) * cos((lat * pi()/180)) * cos((($zip_details->lon - lon) * pi()/180)))) * 180/pi()) * 60 * 1.1515) AS distance FROM zip_code) AS zip ON u.zip = zip_code WHERE msg.direct = 0 AND msg.user IN (SELECT u.username FROM users u WHERE u.id NOT IN (SELECT bl.user FROM blocked_users bl WHERE bl.blocked_user = {$_SESSION['user']->id})) AND (msg.user IN (SELECT u.username FROM users u WHERE u.visible = 1) OR msg.user IN (SELECT u.username FROM users u WHERE u.id IN (SELECT al.user FROM followed al WHERE al.followed = {$_SESSION['user']->id}) AND u.visible = 0)) GROUP BY msg.id ORDER BY distance DESC