#use commonswiki_p;

set @cat1:="All_media_needing_categories_as_of_20%";

# set @cat2:="Media_needing_category_review_as_of_%";               or cl_to like @cat2 

set @cat3:="Photos_from_Panoramio_needing_categories_as_of_%";

set @cat4:="Media_with_geo-coordinates_needing_categories";

set @cat5:="Media_needing_categories_as_of_%";

set @cat6:="Uncategorized%";

#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 @cat3 or cl_to like @cat4 or cl_to like @cat5 or cl_to like @cat6)  

       and cl_type="file" and 

       (

         # ((gt_lat<47.3 and gt_lat>=46.4 and gt_lon>6.8 and gt_lon<9.5))

         ((gt_lat<47.87 and gt_lat>=45.65 and gt_lon>5.83 and gt_lon<10.98))

       )

       order by 1

       limit 10000;

​