select
6371.393*ACOS(
COS(RADIANS(latitude))*COS(RADIANS(47.02))*COS(RADIANS(longitude)-RADIANS(114.100))+SIN(RADIANS(latitude))*SIN(RADIANS(47.02))
) as distance
from location
6371.393*ACOS(
COS(RADIANS(latitude))*COS(RADIANS(47.02))*COS(RADIANS(longitude)-RADIANS(114.100))+SIN(RADIANS(latitude))*SIN(RADIANS(47.02))
) as distance
from location