Number of edits in ltwikisource

SQL

USE ltwikisource_p;
SET @w:=0;
SET @s:=0;
SET @tot:=(SELECT COUNT(*)
		   FROM actor JOIN revision ON rev_actor=actor_id JOIN user ON actor_user=user_id JOIN page ON rev_page=page_id
		   WHERE page_namespace IN (0,250,252) AND
           		 NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT' AND NOT user_name RLIKE 'Commons');

SELECT @tot AS `Total number of edits`;

SELECT @w:=@w+1 AS 'Pos.',`Number of edits`,`User`,@s:=@s+`Number of edits` AS 'Cumulatively',@s*100/@tot AS 'Percent'
FROM (SELECT user_name AS 'User', COUNT(*) AS 'Number of edits'
	FROM actor JOIN revision ON rev_actor=actor_id JOIN user ON actor_user=user_id JOIN page ON rev_page=page_id
    WHERE page_namespace IN (0,250,252) AND
          NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT' AND NOT user_name RLIKE 'Commons'
    GROUP BY user_name
    HAVING `Number of edits`>10
    ORDER BY 2 DESC
    LIMIT 100) AS A;
SQL

Checking query status...
