Contributor Count German Wikipedia 2016_v1

SQL

USE dewiki_p; -- German Wikipedia 
SELECT user_id, user_editcount -- user_id "is the primary key, used to uniquely identify a user"; editcount counts edits since account creation  
FROM user -- table user https://www.mediawiki.org/wiki/Manual:User_table
INNER JOIN revision -- join table "user" with table "revision", but only rows in which that (ON) is the case. Also, JOIN = INNER JOIN
ON user_id = revision.rev_user; 
COUNT(*) -- "The COUNT(*) function returns the number of records in a table:"
HAVING  -- similar to WHERE, but for aggregate functions
  LOWER(CONVERT (rev_user_text USING latin1)) 
  NOT LIKE 
  '%bot%' AND -- What is "LOWER?!" 
  rev_user != 0 AND -- dont count all edits
  page_namespace = 0 AND 
  page_is_redirect = 0 AND 
  rev_timestamp BETWEEN 20161201000000 AND 20170101000000;
  user_editcount=10 -- where Editcount is exactly 10
  LIMIT 10
  
-- if not otherwise noted, Quotes are from http://www.w3schools.com/sql/
SQL

Checking query status...
