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

SQL

USE trwiki_p;

SET @KAT=replace("Bozuk dosya bağlantıları içeren sayfalar"," ","_");
SET @DS = 10; -- maddedeki max dosya sayısı

SELECT p.page_title, il.il_to as dosya, count(il.il_to) as dosya_sayisi, concat("tr.wikipedia.org/wiki?curid=",p.page_id) as link, p.page_latest
#, il2.il_to as dosya_en

from imagelinks il 
join page p on  p.page_id = il.il_from 
JOIN categorylinks AS cats ON p.page_id = cats.cl_from 
left join image img on  img.img_name = il.il_to 

#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_text is NULL

#and img2.img_user is null
-- and (iwl_prefix is null OR iwl_prefix ="en")

group by p.page_id
having dosya_sayisi <= @DS
order by 3 asc, p.page_latest, 1 asc
limit 2000;
SQL

Checking query status...
