Find uncategorized images with location in Estonia

SQL

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_%";
#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) and cl_type="file" and 
       (
         #((gt_lat<60.01 and gt_lat>=58.01 and gt_lon>25.01 and gt_lon<27.01))
         ((gt_lat<59.49 and gt_lat>=57.51 and gt_lon>21.00 and gt_lon<28.20))
       )
       order by 1
       limit 199;
       
       #0° 16′ 49.27″ S, 100° 17′ 09.34″ E Kartographer map based on OpenStreetMap.# sölden & silvretta

       #15° 16′ 22.24″ N, 47° 38′ 08.5″ E Kartographer map based on OpenStreetMap. - araabi poolsaar
       #: 15° 47′ S, 47° 55′ W (kaart) = Brasiilia
       #: 59° N, 26° E (kaart) = EESTI
SQL

Checking query status...
