SQL
x
USE trwiki_p;
/*SET @K1 = "Türkçe Vikipedi üzerinde resmi olmayan ama Vikiveride resmi olan maddeler";
SET @K2 = "Türkçe Vikipedi ile Vikiveride aynı resim olan maddeler";
*/
SET @K = replace('Vikipedi_silinecek_sayfalar',' ','_');
select concat("tr.wikipedia.org/wiki?diff=cur&oldid=prev&curid=",page_id) as url, page_title, count(*), rc_comment
from categorylinks join page on page_id = cl_from
join imagelinks on il_to = page_title
join image im on im.img_name= il_to
join recentchanges_userindex on rc_page = page_id
where (cl_to = @K OR cl_to rlike "tarihinden_beri_sorunlu" )
and page_namespace = 6
and rc_this_oldid =page_latest
group by cl_from
;
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.