TAZIO MIRANDOLA Web Applications Developer

utenti con distanza inferiore a $distance

SELECT a.zip_code, a.latitude, a.longitude, COUNT(g.id) AS game_count,
( 3959 * acos( cos( radians($this->latitude) )
* cos( radians( a.latitude ) ) *
cos( radians( a.longitude ) - radians($longitude) ) +
sin( radians($latitude) ) *
sin( radians( a.latitude ) ) ) ) AS distance
FROM accounts a
LEFT JOIN games_to_accounts ga
ON a.id = ga.account_id
LEFT JOIN games g ON ga.game_id = g.id
WHERE ga.status_id = $status
GROUP BY a.zip_code HAVING distance < $distance
ORDER BY distance