Find uncategorized images with location in Austria

SQL

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

select gt_lat, gt_lon, gt_page_id, 
       (select page_title from page where page_id = gt_page_id) as title
       ,count(*)
       from geo_tags
       where
       		(gt_lat<47.744 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;

select cl_from,count(*) from categorylinks
       where cl_to=@cat and cl_type="file" limit 200;

select gt_lat, gt_lon, gt_page_id, 
       (select 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=@cat and cl_type="file" and 
       (
       		(gt_lat<47.744 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;
SQL

Checking query status...
