adl - Quarry

SQL

USE trwiki_p;
SET @kat = replace("Tüm adil kullanım dosyaları"," ","_");
select concat("tr.wikipedia.org/wiki?curid=",pd.page_id) as url
from page pd join imagelinks on il_to = pd.page_title 
join page pm on pm.page_id = il_from


where pd.page_namespace = 6 and pd.page_id in (select cl_from from categorylinks where cl_type="file" and cl_to = @kat)
and il_from_namespace = 0 and pm.page_namespace =0
and pd.page_id not in (select pl_from from pagelinks where pl_from_namespace = 6 and pl_namespace = 0 and pl_title not rlike "telif")
limit 10;
SQL

Checking query status...
