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
	LIMIT 200
) 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...
