Contributor Count German Wikipedia 2016

SQL

USE dewiki_p;
SELECT COUNT(*) AS DEContributors2016 FROM user JOIN revision ON user_id = rev_user 
  HAVING user_editcount = 10 AND HAVING rev_timestamp BETWEEN 20161201000000 AND 20170101000000;

SELECT 
  rev_user, 
  rev_user_text, 
  YEAR(rev_timestamp) as year,
  MONTH(rev_timestamp) as month, 
  rev_timestamp,  /* TODO: This column should be an aggregate function */
  COUNT(*) 
FROM revision 
INNER JOIN page ON revision.rev_page = page.page_id 
WHERE 
  LOWER(CONVERT (rev_user_text USING latin1)) NOT LIKE '%bot%' AND
  rev_user != 0 AND 
  page_namespace = 0 AND 
  page_is_redirect = 0 
HAVING COUNT(*) = 10;
SQL

Checking query status...
