This query is marked as a draft This query has been published by Bulgu.

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=",p.page_id) as url, p.page_title, count(*), rc_comment
from categorylinks join page p on  p.page_id = cl_from 
join imagelinks on il_to = p.page_title
join image im on im.img_name= il_to
join recentchanges_userindex on rc_this_oldid = p.page_latest
-- left join commonswiki_p.image cim on cim.img_sha1 = im.img_sha1
where (cl_to = @K OR cl_to rlike "tarihinden_beri_sorunlu" ) 
and  p.page_namespace = 6 
-- and cp.page_id is null
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.

Checking query status...