tarih - Quarry

SQL

USE trwiki_p;
-- set @tmp = "Temizleme";
set @kat = replace("Vikipedi temizleme"," ","_");
set @pgad = "refika";

select page_title, replace(replace(replace(cl_timestamp,"-",""),":",""),"T","") as ts
-- , page_title, CONCAT("tr.wikipedia.org/wiki/Özel:Diff/",rev_id) as urlrev, rev_timestamp
from page 
join categorylinks on cl_from = page_id 
-- join revision_userindex on rev_page = page_id

where page_namespace = 0

and cl_to = @kat
-- and left(rev_timestamp,10) = left(replace(replace(replace(cl_timestamp,"-",""),":",""),"T",""),10)


-- order by cl_timestamp

;




;
SQL

Checking query status...
