Find uncategorized images with location in Western Pomerania (1)

SQL

use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
set @cat2:="Media_needing_category_review_as_of_%";
set @cat3:="Photos_from_Panoramio_needing_categories_as_of_%";
set @cat4:="Media with geo-coordinates needing categories";
#describe geo_tags;

select distinct #gt_lat, gt_lon, gt_page_id, 
       (select concat("file:",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 or cl_to like @cat3 or cl_to like @cat4) and cl_type="file" and 
       (
         ((gt_lat<54.7 and gt_lat>=54.02068 and gt_lon>12.8851 and gt_lon<14.26955) or
          (gt_lat<54.02068 and gt_lat>=53.75598 and gt_lon>12.81769 and gt_lon<14.27415) or
          (gt_lat<53.75598 and gt_lat>=53.63281 and gt_lon>13.00446 and gt_lon<13.40617) or
          (gt_lat<53.75598 and gt_lat>=53.6852 and gt_lon>13.48742 and gt_lon<14.29885) or
          (gt_lat<53.6852 and gt_lat>=53.48094 and gt_lon>13.67129 and gt_lon<14.35322) or
          (gt_lat<53.48094 and gt_lat>=53.41901 and gt_lon>13.87531 and gt_lon<14.37962) or
          (gt_lat<53.41901 and gt_lat>=53.32294 and gt_lon>14.17176 and gt_lon<14.41912) or
          (gt_lat<53.32294 and gt_lat>=53.25593 and gt_lon>14.09108 and gt_lon<14.4454) or
          (gt_lat<53.25593 and gt_lat>=53.14191 and gt_lon>14.27629 and gt_lon<14.44265))
       )
       order by 1
       limit 1500;
SQL

Checking query status...
