bozuk dosya (azwiki)

SQL

USE azwiki_p;
select now();
SET @KAT=replace("İşləməyən fayl keçidləri olan səhifələr"," ","_");
SET @DS = 1; -- maddedeki max dosya sayısı

SELECT concat("[[:",p.page_title,"|",p.page_title,"]]") as ad, concat("[[:File:",il.il_to,"|",il.il_to,"]]") as dosya
, count(*) as dosya_sayisi
, concat("[http://az.wikipedia.org/wiki?curid=",p.page_id," link]") as link
, p.page_latest as son_revizyon
, concat("[http://az.wikipedia.org/wiki?section=0&action=edit&curid=",p.page_id," link0]") as link0
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 

WHERE p.page_namespace = 0 and cats.cl_to = @KAT  
and img.img_user_text is NULL
and il.il_to not in (select pq.page_title from page pq where pq.page_namespace = 6)
and il.il_to not in (select cpq.page_title from commonswiki_p.page cpq where cpq.page_namespace = 6)

group by p.page_id  having count(il.il_to) <= @DS
-- group by il.il_to
order by p.page_latest, 1 asc
limit 2000;
select now();
SQL

Checking query status...
