Find uncategorized images with phrase in title

Fork of Find uncategorized images with phrase in title by Erell

This query is marked as a draft This query has been published by Estopedist1.

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 page_title from page where page_id = cl_from and page_title like "%tartu%") as title
       #,count(*)
       from categorylinks 
       where (cl_to like @cat1 or cl_to like @cat2 or cl_to like @cat3 or cl_to like @cat4) and cl_type="file" 
       order by 1
       limit 10

SQL

Checking query status...