pages that have only hidden/draft categories

SQL

USE trwiki_p;
select now();

select p.page_id as id, concat("[[",p.page_title,"]]") as ad
, concat("http://tr.wikipedia.org/wiki?curid=",p.page_id) as url , p.page_latest, count(*)
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"
) 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") )
)
group by p.page_id
order by p.page_latest asc
;
select now();
SQL

Checking query status...
