WP:Bez barier - Quarry

SQL

USE plwiki_p;

-- describe revision;

-- przegląd opisów (czy używają wszyscy #?)
-- -> tak, używają :)
/**/
select comment_text, actor_name, count(*)
from revision r
left join comment c ON rev_comment_id= comment_id 
left join actor a ON rev_actor = actor_id 
where	
-- po starcie akcji
rev_id > 61563306
and
comment_text like '%Barier%'
group by comment_text, actor_name
order by rev_actor
/**/

-- właściwie zapytanie
/**
select actor_name, count(*)
from revision r
left join comment c ON rev_comment_id= comment_id 
left join actor a ON rev_actor = actor_id 
where	
-- po starcie akcji
rev_id > 61563306
and
comment_text like '%barier%'
and
comment_text COLLATE UTF8_GENERAL_CI like '%#wiki%'
group by comment_text, actor_name
order by rev_actor
/**/
SQL

Checking query status...
