pages that have only hidden/draft categories

SQL

USE trwiki_p;
select concat("[[",replace(p.page_title,"_"," "),"]]") as madde
, concat("http://tr.wikipedia.org/wiki?curid=",p.page_id) as url, count(*) as kategori_sayisi
, replace(cl.cl_to,"_"," ") as kategorilerden_bir_tanesi
, p.page_latest
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 "Çift" 
and cl.cl_to not rlike "Vikipedi" 
and cl.cl_to not rlike "maddeler"
and cl.cl_to not rlike "sayfalar"

group by p.page_id
order by p.page_latest asc
;

SELECT concat("[[",page_title,"]]") as madde
, concat("http://tr.wikipedia.org/wiki?curid=",page_id) as url 
,page_len as madde_boyutu
from page where page_namespace = 0 and page_is_redirect = 0 
and page_len > 100 and
page_id not in (select cl_from from categorylinks)
;
SQL

Checking query status...
