SELECT lawyer.* FROM lawyer
LEFT JOIN zipcode ON (lawyer.zipcode=zipcode.zipcode)
LEFT JOIN city ON (city.id = '11211')
WHERE (3958.75 * atan(sqrt(1 - pow(sin(radians(zipcode.latitude)) * sin(radians(city.latitude)) + cos(radians(zipcode.latitude)) * cos(radians(city.latitude)) * cos(radians(zipcode.longitude) - radians(city.longitude)) ,2 ) ) / (sin(radians(zipcode.latitude)) * sin(radians(city.latitude)) + cos(radians(zipcode.latitude)) * cos(radians(city.latitude)) * cos(radians(zipcode.longitude - city.longitude))) )) < 30