USE trwiki_p;

-- set @tmp = "Temizleme";

set @kat = replace("Vikipedi temizleme"," ","_");

set @pgad = "refika";

select page_title, ts, rev_timestamp

-- , page_title, CONCAT("tr.wikipedia.org/wiki/Özel:Diff/",rev_id) as urlrev, rev_timestamp

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)

​

​

​

;

​

​

​

​

;