Untitled query #16231

SQL

USE commonswiki_p;
select now();

select p.page_id as concat("File:",p.page_title) as ad-- , exists(cl.cl_to)
from page p join categorylinks cl on cl.cl_from = p.page_id where p.page_namespace = 6 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"
group by p.page_id
order by p.page_latest asc
;
select now();
SQL

Checking query status...
