Find uncategorized images with location in Austria

SQL

use commonswiki_p;
set @cat:="All_media_needing_categories_as_of_20%";
#describe geo_tags;

select #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
       inner join categorylinks on gt_page_id = cl_from
       where cl_to like @cat 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>12.1 and gt_lon<=12.9) or # osttirol
       		(gt_lat<47.60 and gt_lat>46.59 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
       )
       #limit 200
       order by 1;
SQL

Checking query status...
