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 
select concat("tr.wikipedia.org/wiki?curid=",cl_from) as url, il_to
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)



limit  10
;
SQL

Checking query status...
