Commons images only in hidden cat

Fork of Artiklid, mis on üksnes peidetud kategoorias by Wkentaur

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

SQL

use commonswiki_p;
select CONCAT ('File:',p1.page_title,'')
from page p1 left outer join categorylinks on
cl_from = p1.page_id left join page p2 on cl_to = p2.page_title and
p2.page_namespace = 14 left join page_props on p2.page_id = pp_page
right join categorylinks as cl1 on p1.page_id = cl1_from
and pp_propname = 'hiddencat' where p1.page_namespace = 6 
and p1.page_is_redirect = 0 #and p1.page_title not like '%/%' 
AND cl1_to NOT LIKE "Media_needing_category_review%"
group by p1.page_title 
having count(cl_from)-count(pp_propname) = 0
LIMIT 9;

SQL

Checking query status...