silinmiş/bozuk dosya bağlantılı maddeler

SQL

USE trwiki_p;

SET @KAT=replace("Bozuk dosya bağlantıları içeren sayfalar"," ","_");

SELECT concat("tr.wikipedia.org/wiki/",p.page_title) as link, il.il_to as dosya
#, il2.il_to as dosya_en

from page p JOIN categorylinks AS cats ON p.page_id = cats.cl_from 

join imagelinks il on il.il_from = p.page_id
left join image img on il.il_to = img.img_name

left join iwlinks iwl on iwl.iwl_from = p.page_id 

#left join enwiki_p.page as p2 on p2.page_title = iwl.iwl_title

#left join enwiki_p.imagelinks il2 on il2.il_from = p2.page_id

#left join enwiki_p.image img2 on img2.img_name = il2.il_to


WHERE p.page_namespace = 0 and cats.cl_to = replace(@KAT," ","_")  and img.img_user is NULL
#and img2.img_user is null
-- and (iwl_prefix is null OR iwl_prefix ="en")

group by 2
limit 100;
SQL

Checking query status...
