Untitled query #15913

SQL

use lvwiki_p;
#set @cat1:="All_media_needing_categories_as_of_20%";
#set @cat2:="Media_needing_category_review_as_of_%";
set @ziemeli:= 58.08;
set @dienvidi:= 55.67478947;
set @austrumi:= 28.24140787;#lon
set @rietumi:= 20.97017527;
#describe geo_tags;

select page_title, concat(gt_lat,' ',gt_lon), gt_lat, gt_lon, gt_dim, gt_type, gt_name, gt_country, gt_region
       from geo_tags
       join page on page_id=gt_page_id and page_namespace=0
       where
       gt_primary=1 and (gt_lat<@ziemeli and gt_lat>@dienvidi and gt_lon>@rietumi and gt_lon<@austrumi)
SQL

Checking query status...
