Utenti italofoni con più contributi in tutti i progetti

This query is marked as a draft This query has been published by Nemo bis.

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
SET @itwikiuserpage = ( USE itwiki_p; 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 );

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...