sql query distance latitude longitude code example
Example: distance calculator from lat long sql query
COALESCE(
(
6371 * acos( cos( radians({$latitude}) ) * cos( radians( `latitude` ) ) * cos( radians( `longitude` ) - radians({$longitude}) ) + sin( radians({$latitude}) ) * sin( radians( `latitude` ) ) )
)
, 0) AS distance