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 *# distinct #gt_lat, gt_lon, gt_page_id, 
       #(select concat (page_title,"|") from page where page_id = gt_page_id) as title
       #,count(*)
       from geo_tags
       join page on page_id=gt_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)
       #limit 200
SQL

Checking query status...
