Untitled query #21250

SQL

use metawiki_p;
set @row = 0;
select 
	@row:=@row+1 as `#`,
    CONCAT("[[User:", user_name, "|", user_name, "]]") as username,
    notlog_user_id,
    actions,
    created,
    modified,
    removed
from (
  select 
      user_name,
  	  notlog_user_id,
      count(*) as actions,
      count(case when notlog_action = "created" then 1 else null end) as created,
      count(case when notlog_action = "modified" then 1 else null end) as modified,
      count(case when notlog_action = "removed" then 1 else null end) as removed
  from cn_notice_log 
  join `user` on user_id = notlog_user_id and notlog_timestamp > 20170101000000
  group by user_name
  order by actions desc
) resultset
SQL

Checking query status...
