USE plwiki_p;

​

-- describe revision;

​

select comment_text, rev_actor, count(*)

from revision r

left join comment c ON rev_comment_id= comment_id 

where   

-- po starcie akcji

rev_id > 61563306

and

comment_text like '%bezbarier%'

group by comment_text, rev_actor

​