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("[[",p2.page_title,"]]") as sayfa, concat("tr.wikipedia.org/wiki?action=edit&section=0&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 
join page p2 on p2.page_id = cl.cl_from
where cl.cl_to = @KAT and p.page_namespace = 6
and cl2.cl_to rlike "adil" -- fair use
and img_major_mime rlike "image"

group by cl.cl_from
order by p2.page_latest
-- limit 100

;
SQL

Checking query status...
