Untitled query #48709

SQL

USE plwiktionary_p;
SET @w:=0;
SET @s:=0;
SELECT @w:=@w+1 AS 'Lp',`Liczba edycji`,`Użytkownik`,@s:=@s+`Liczba edycji` AS 'Narastająco'
FROM (SELECT user_name AS 'Użytkownik', COUNT(*) AS 'liczba edycji'
	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 = 0 /*IN (0,100,102,104,124)*/ AND
          NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT'
    GROUP BY user_name
    HAVING `Liczba edycji`>1000
    ORDER BY 2 DESC
    LIMIT 100) AS A;

SELECT COUNT(*) AS `Ogólna liczba edycji`
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 = 0 /*IN (0,100,102,104,124)*/ AND
      NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT'
;
SQL

Checking query status...
