Untitled query #60479

SQL

SET @rank=0;
SELECT @rank:=@rank+1 AS "Rank", s.*
FROM (
  SELECT user.user_id, CONCAT("[[User:",user.user_name,"|",user.user_name,"]]") AS "User", COUNT(rev_actor) AS "Total Edits"
FROM revision 
  JOIN user ON revision.rev_actor = user.user_id
  WHERE rev_timestamp BETWEEN concat(year(now())-1,"0101000000") AND concat(year(now())-1,"1231235959")
AND rev_actor NOT LIKE ucase ("%BOT") COLLATE utf8_general_ci AND rev_actor NOT LIKE ("%New_user_message")
GROUP BY rev_actor
ORDER BY COUNT(rev_actor) DESC
LIMIT 10) s;
SQL

Checking query status...
