vikiveride olmasina ragmen adil kullanim

SQL

USE trwiki_p;
SET @KAT = replace("Türkçe Vikipedi üzerindeki resmi Vikiveriden farklı olan maddeler"," ","_");  -- "Local image different than Wikidata"

SELECT concat("tr.wikipedia.org/wiki?curid=",cl.cl_from) as url , il.il_to as dosya, cl2.cl_to as kat, count(*)
,img_user_text, img_minor_mime
from categorylinks cl join imagelinks il on il.il_from = cl.cl_from
join image on img_name = il.il_to
join page p on p.page_title = il.il_to join categorylinks cl2 on cl2.cl_from = p.page_id 
where cl.cl_to = @KAT and p.page_namespace = 6
and cl2.cl_to rlike "adil"
and img_major_mime rlike "image"

group by cl.cl_from
order by img_user_text,p.page_latest
-- limit 100

;
SQL

Checking query status...
