SELECT SQL_CALC_FOUND_ROWS F.*, ROUND(3956*2*ASIN(SQRT(POWER(SIN((-F.ZipLat)*pi()/180/2),2)+COS(*pi()/180)*COS(F.ZipLat*pi()/180)*POWER(SIN((-F.ZipLong)*pi()/180/2),2) )),1) as Distance FROM Firm F INNER JOIN ZipTemp z ON F.ZipCode = z.ZipCode WHERE F.TagString like '%|bedbugkill:%' ORDER by Distance limit 0, 20 in Ponte Vedra Beach, FL