SQL
x
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§ion=0&curid=",cl.cl_from," sec0]") 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
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.