Places Near Coordinates

SQL

SET 
@lat = 42.34716111
@sin_lat = SIN(@lat * PI() / 180), 
@cos_lat = COS(@lat * PI() / 180), 
@lon = 	-71.08252222 * PI() / 180;
			SELECT page_id, gt_lat, gt_lon, page_title, pp1.pp_value, pp2.pp_value, pp3.pp_value,
			ACOS(@sin_lat * SIN(gt_lat * PI() / 180) + @cos_lat * COS(gt_lat * PI() / 180) * COS(gt_lon * PI() / 180 - @lon)) * 6371 as dist
			FROM geo_tags
			JOIN page ON gt_page_id = page_id AND page_namespace = 0
			LEFT JOIN page_props pp1 ON page_id = pp1.pp_page AND pp1.pp_propname = 'wikibase-shortdesc'
			LEFT JOIN page_props pp2 ON page_id = pp2.pp_page AND pp2.pp_propname = 'page_image_free'
			LEFT JOIN page_props pp3 ON page_id = pp3.pp_page AND pp3.pp_propname = 'page_image' AND pp2.pp_value IS NULL
			WHERE gt_primary = 1 AND LOWER(pp2.pp_value) NOT LIKE "%logo%" AND LOWER(pp2.pp_value) NOT LIKE "%seal%"
			ORDER BY dist
			LIMIT 100
SQL

Checking query status...
