Untitled query #30314

SQL

USE commonswiki_p;
#SELECT * FROM globalimagelinks WHERE gil_page_namespace_id=0 LIMIT 25;
SET @hereami = POINT(44.222981, 4.800418);
SELECT p.page_title,(ST_Distance(@hereami, POINT(gt.gt_lat,gt.gt_lon))*111195) AS distance FROM page AS p JOIN geo_tags AS gt ON p.page_id=gt.gt_page_id WHERE p.page_namespace=6 AND p.page_title NOT IN (SELECT gil.gil_to FROM globalimagelinks AS gil WHERE gil.gil_page_namespace_id=0 AND gil.gil_wiki='frwiki') AND gt.gt_globe='earth' AND gt.gt_lat!=0 AND gt.gt_lon!=0 AND (ST_Distance(@hereami, POINT(gt.gt_lat,gt.gt_lon))*111195)<1500 ORDER BY distance LIMIT 10;
SQL

Checking query status...
