bek cok - Quarry

SQL

USE trwiki_p;



SELECT concat("tr.wikipedia.org/wiki/Dosya:",replace(p.page_title," ","_")), c.cl_to, p.page_is_redirect, *
from page p left join categorylinks c  on c.cl_from = p.page_id 
left join langlinks ll on ll.ll_from = p.page_id
left join iwlinks iwl on iwl.iwl_from = p.page_id
where  p.page_namespace = 6 and p.page_id NOT IN (select pp.page_id from page pp left JOIN categorylinks cc ON cc.cl_from = pp.page_id  where cc.cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri"))
and c.cl_to is NULL and p.page_is_redirect = 0
limit 100;
SQL

Checking query status...
