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

SQL

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

SELECT substrING(p.page_title,1,25) as ad, substrING(il.il_to,1,25) as dosya
-- , count(il.il_to) as dosya_sayisi
, concat("tr.wikipedia.org/wiki?curid=",p.page_id) as link
, p.page_latest
, concat("tr.wikipedia.org/wiki?section=0&action=edit&curid=",p.page_id) as link0
-- , pimg.page_len
from imagelinks il 
join page p on  p.page_id = il.il_from 
JOIN categorylinks cats ON  cats.cl_from = p.page_id 
left join image img on  img.img_name = il.il_to 
-- left join page pimg on pimg.page_title = il.il_to

WHERE p.page_namespace = 0 and cats.cl_to = @KAT  
-- and (pimg.page_id is NULL OR pimg.page_len < 10)
and img.img_user_text is NULL
and p.page_title not in (select pq.page_title from page pq where pq.page_namespace = 6)
and p.page_title not in (select cpq.page_title from commonswiki_p.page cpq where cpq.page_namespace = 6)
-- group by p.page_id having dosya_sayisi <= @DS
order by p.page_latest, 1 asc
limit 200;
select now();
SQL

Checking query status...
