Untitled query #86201

SQL

#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, categorylinks 
       WHERE 
       where  gt_country = "CH" 
       AND gt_page_id = cl_from
       and (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"
SQL

Checking query status...
