SELECT (ROUND(6378.138*2*ASIN(SQRT(POW(SIN((#{latitude}*PI()/180-a.shop_latitude*PI()/180)/2),2)+COS(#{latitude}*PI()/180)*COS(a.shop_latitude*PI()/180)*POW(SIN((#{longitude}*PI()/180-a.shop_longitude*PI()/180)/2),2)))))
as distance from shop a
SELECT (ROUND(6378.138*2*ASIN(SQRT(POW(SIN((#{latitude}*PI()/180-a.shop_latitude*PI()/180)/2),2)+COS(#{latitude}*PI()/180)*COS(a.shop_latitude*PI()/180)*POW(SIN((#{longitude}*PI()/180-a.shop_longitude*PI()/180)/2),2)))))
as distance from shop a