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;
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
       where# (cl_to like @cat1 or cl_to like @cat2) and cl_type="file" and 
       (
       	   ((gt_lat<47.744 and gt_lat>=47.60 and gt_lon>12.18 and gt_lon<=12.9) or # wilder kaiser
       		(gt_lat<47.05 and gt_lat>=46.56 and gt_lon>9.85 and gt_lon<11.17) or # osttirol
       		(gt_lat<46.73 and gt_lat>=46.94 and gt_lon>12.1 and gt_lon<=12.9) or # sölden & silvretta
       		(gt_lat<47.60 and gt_lat>=46.94 and gt_lon>9.53 and gt_lon<=12.74) or # westblock
       		(gt_lat<49.03 and gt_lat>46.37 and gt_lon>12.74 and gt_lon<17.161)) # ostblock
            and not (gt_lat<46.53 and gt_lon>14.89) # slowenien
            and not (gt_lat<47.64 and gt_lon>16.64) # ungarn
            and not (gt_lat>47.396 and gt_lon>10.112 and gt_lon<10.420) # Bad Hindelang
            and not (gt_lat>47.437 and gt_lon>10.987 and gt_lon<11.311) # Garmisch
       )
       #limit 200
       order by 1;
SQL

Checking query status...
