Uncategorized Slovakia-bounded commons images

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 > 47.729 and gt_lat < 49.614 and gt_lon > 16.832 and gt_lon < 22.566) # SK
      and not (gt_lat > 49.036 and gt_lon < 18.050) # SZ, Morava
      and not (gt_lat < 48.332 and gt_lon > 20.381) # JV, Madarsko 1
      and not (gt_lat < 48.037 and gt_lon > 18.861) # JV, Madarsko 2
    )
  order by 1
  #limit 200
  ;
SQL

Checking query status...
