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 '%|metalroofingprices:%'
ORDER by Distance
limit 0, 20
in Oklahoma City, O