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
and pp_propname = 'hiddencat' 
where p1.page_namespace = 6 
and p1.page_is_redirect = 0 
AND p1.page_title like '%_POPPPY_%'
#AND p1.page_title LIKE "V%"

#AND p1.page_title RLIKE "^C" #TH märka, et väiketähega ei saagi olla
						      #TH märka, et RLIKE'iga kulus 600 sec
group by p1.page_title 
having count(cl_from)-count(pp_propname) = 0
order by p1.page_title asc
LIMIT 999;

SQL

Checking query status...