Untitled query #48709

SQL

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

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 AND
      NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT' AND NOT user_name IN ( 'CommonsDelinker', 'Interwicket' )
;
SQL

Checking query status...
