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?";
SET @n = 3;

select page_title as ad
,count(*)
, group_concat(rc_user_text SEPARATOR "; ") as kisiler
,max(rc_timestamp) as zaman_son
,concat("tr.wikipedia.org/wiki/Özel:Diff/",max(rc_this_oldid)) as url_son
,group_concat(rc_comment SEPARATOR "; ") as konular

from recentchanges_userindex
join page on page_id = rc_cur_id
join user_groups on ug_user = rc_user
where rc_timestamp > @gun
and page_namespace = 0
and rc_comment rlike @s1
and rc_user_text not rlike "[Cc]ommons[dD]elinker"

-- and rc_comment rlike @s2
group by page_id having count(*)>= @n
order by count(*) desc
limit 10;
SQL

Checking query status...
