Untitled query #12042

SQL

use dewiki_p;
set @bwlat:='48.02477';
set @bwlon:='16.49245';
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((gt_lat - @bwlat)*(gt_lat - @bwlat) + (gt_lon - @bwlon)*(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 asc limit 100;*/
SQL

Checking query status...
