test commons - Quarry

SQL

#my uncat images
USE commonswiki_p;
select page_title#CONCAT("*[[:File:",page_title,"]]") as File#, cl_to
from image, page, categorylinks
   WHERE page_id=cl_from
       AND cl_to like "Media_needing_categories%"
and page_namespace = 6 AND page_is_redirect = 0 
and img_user_text = "XXN"
GROUP BY page_title
ORDER BY page_title
/*uncat duplicates
USE commonswiki_p;
select CONCAT("*[[:File:",page_title,"]]") as File, cl_to
from page, categorylinks
   WHERE page_id=cl_from
       AND cl_to like "Media_needing_categories%"
and page_namespace = 6 AND page_is_redirect = 0 
and page_title in (select pl_title from pagelinks 
                     where pl_from = 54056652 and pl_namespace = 6)
GROUP BY page_title
ORDER BY page_title
*/
/*SELECT count(distinct img_name) FROM image #JOIN globalimagelinks on gil_to = img_name
WHERE #img_name = "Русская_историческая_библиография_Год_1858_1867.PDF(2).pdf"#'Sunday_Mirror.jpg'
img_minor_mime = "pdf"*/
#group by img_name
# join page on page_namespace = 6 and page_title = img_name
#LEFT OUTER JOIN globalimagelinks on gil_to = page_title
#
#04f6ocji4q9bli9p018x2vqqsukk1cl
SQL

Checking query status...
