SQL
x
USE trwiki_p;
-- set @tmp = "Temizleme";
set @kat = replace("Vikipedi temizleme"," ","_");
set @pgad = "refika";
select page_title, ts, rev_timestamp, (ts-rev_timestamp) as fark
, CONCAT("tr.wikipedia.org/wiki/Özel:Diff/",rev_id) as urlrev, (concat(mid(ts,5,2),".",left(ts,4))) as tar
from
(select page_id, page_title, replace(replace(replace(replace(cl_timestamp,"-",""),":",""),"T","")," ","") as ts
from page
join categorylinks on cl_from = page_id
where page_namespace = 0
and cl_to = @kat
) as clcl
left join revision_userindex on rev_page =clcl.page_id
where left(rev_timestamp,10) = left(clcl.ts,10)
group by page_id having abs(fark)<1000
order by left(ts,6), fark
;
;
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.