USE trwiki_p;

-- set @tmp = "Temizleme";

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

set @pgad = "Refika Birg.l";

​

select *

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

from page 

left join categorylinks on cl_from = page_id 

-- join revision_userindex on rev_page = page_id

​

where page_namespace = 0

and page_title REGEXP @pgad

-- and right(cl_to,2) = right(@kat,2)

-- and cl_to = @kat

-- and rev_timestamp = cl_timestamp

​

​

-- order by cl_timestamp

​

;

​

​

​

​

;