Untitled query #18737

SQL

USE trwiki_p;
SET @gun = date_add(now(), INTERVAL -3 DAY);
SET @s1 = "[gG]erekçe";
SET @s2 = "[vV]andali?z?m?";

select page_title as ad
, group_concat(rc_user_text) as kisiler
,max(rc_timestamp) as ts
,concat("tr.wikipedia.org/Özel:Diff/",max(rc_this_oldid)) as url

from recentchanges_userindex
join page on page_id = rc_cur_id
where rc_timestamp > @gun
and page_namespace = 0
and rc_comment rlike @s1
-- and rc_comment rlike @s2
group by page_id having count(*)>3
order by count(*) desc
limit 10;
SQL

Checking query status...
