Images without category - SE Bavaria

SQL

use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
set @cat2:="Media_needing_category_review_as_of_%";
#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
       inner join categorylinks on gt_page_id = cl_from
       where (cl_to like @cat1 or cl_to like @cat2) and cl_type="file" and 
       (
       	   (gt_lat<48.3 and gt_lat>47.3 and gt_lon>12.3 and gt_lon<13.2)
       )
       #limit 300
       order by 1;

SQL

Checking query status...