Pages that have only hidden/draft categories (arwiki)

SQL

USE arwiki_p;
select concat("[[",replace(p.page_title,"_"," "),"]]") as "المقالة"
#, concat("http://ar.wikipedia.org/wiki?curid=",p.page_id) as "الوصلة"
, count(*) as "عدد التصنيفات"
, replace(cl.cl_to,"_"," ") as "مثال للتصنيفات"
-- , exists(cl.cl_to)
from page p join categorylinks cl on cl.cl_from = p.page_id where p.page_namespace = 0 and p.page_id not in
(SELECT cl2.cl_from 
from categorylinks cl2 join 
(select ppp.page_id as id, ppp.page_title as ad from page ppp where ppp.page_namespace =14 
-- and ppp.page_title not rlike "taslak"  -- taslaklar
) as pc 
on  pc.ad = cl2.cl_to
where  pc.id not in 
(select distinct(pp_page) from page_props where pp_propname in ("hiddencat") )
)
and cl.cl_to not rlike "جميع_المقالات_التي_بحاجة_لصيانة"
group by p.page_id
order by p.page_latest asc
;
SQL

Checking query status...
