vikiveriye eklemelik

SQL

USE trwiki_p;
SET @KAT=replace("Türkçe Vikipedi üzerinde resmi olan ama Vikiveride resmi olmayan maddeler"," ","_"); -- Local image but no image on Wikidata 
SET @KAT2=replace("Bozuk dosya bağlantıları içeren sayfalar"," ","_"); 

select concat("tr.wikipedia.org/wiki?curid=",cl_from) as url, il_to
, count(*)
from categorylinks left join imagelinks on il_from = cl_from
left join image on img_name = il_to
where cl_type = "page" and cl_to = @KAT 
and img_user is null
and cl_from not in (select distinct(ill.il_from) from imagelinks ill join image imm on ill.il_to = imm.img_name)
and cl_from not in (select cll.cl_from from categorylinks cll where cl_to = @KAT2)
and il_to not rlike "Flag"

group by cl_from
order by count(*), il_to, cl_from
-- limit  10
;
SQL

Checking query status...
