Utenti italofoni con più contributi in tutti i progetti

Query to easily make a distribution list for the users having most edits in Wikimedia projects in italic languages, or Italian-language users on multilanguage projects. See also: 
https://quarry.wmflabs.org/query/23956
https://quarry.wmflabs.org/query/38807
https://quarry.wmflabs.org/query/38639

SQL

/* This query is a mix of:
https://quarry.wmflabs.org/query/23956
https://quarry.wmflabs.org/query/38807
https://quarry.wmflabs.org/query/38639

Configure how many edits you want: */
SET @min = 1000;
SET @max = 9999999;
USE itwiki_p; 
SET @itwikiuserpage = ( SELECT GROUP_CONCAT(TO_BASE64(user_name)) AS u
          FROM user
          RIGHT JOIN page -- Check that a local userpage exists as well
          ON page_namespace = 2
          AND REPLACE(page_title, '_', ' ') = user_name
          AND user_editcount > 200 );
SELECT user_name
FROM user u
JOIN centralauth_p.globaluser gu
ON u.user_name = gu.gu_name
AND gu.gu_locked = 0
WHERE u.user_editcount >= @min
AND u.user_editcount <= @max
AND u.user_id NOT IN (
  SELECT ipb_user
  FROM ipblocks
  WHERE ipb_user > 0
)
AND u.user_id NOT IN (
  SELECT ug_user
  FROM user_groups
  WHERE ug_group = "bot"
);

SQL

Checking query status...