Untitled query #12042

SQL

use commonswiki_p;
set @bwlat:='47.856481'
set @bwlon:='16.244831'
#select gt_lat, gt_lon, gt_primary, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) as title,gt_country,gt_region from geo_tags where 
#gt_lat = gt_lon
#gt_name like "%[[%"
#gt_name like "%Bilderwunsch %"
#gt_lat =47.856481 and gt_lon = 16.244831
#;
select sqrt(sqr(gt_lat - @bwlat) + sqr(gt_lon - @bwlon)) as distanz, 
       gt_lat, gt_lon, gt_page_id, gt_name,
       (select page_title from page where page_id = gt_page_id) as title,
       gt_country,gt_region from geo_tags
       order by 1 desc limit 100;
SQL

Checking query status...
