MySQL Points Within a Distance

pwad.sql

SET @radius = 30;
SET @lat = 49.536252845380;
SET @lng = 23.786006985056;
SET @earth_radius = 6371;


SELECT
  shops.name AS 'Shop Name', shops.id AS 'Shop ID', addresses.lat AS 'Address Lat', addresses.lng AS 'Address Lng', address AS 'Address Line', (
    @earth_radius * acos (
      cos ( radians(@lat) )
      * cos( radians( lat ) )
      * cos( radians( lng ) - radians(@lng) )
      + sin ( radians(@lat) )
      * sin( radians( lat ) )
    )
  ) AS Distance
FROM addresses
INNER JOIN shops ON addresses.shop_id = shops.id
HAVING Distance <= @radius
ORDER BY Distance;