Stemmeberettigede – nowiki

SQL

USE nowiki_p;
SELECT user_id, user_name, num_edits
FROM user
JOIN (SELECT rev_user, count(*) AS num_edits
      FROM revision
      WHERE rev_timestamp >= '20190315000000' AND rev_timestamp <= '20190515000000'
      GROUP BY rev_user
      HAVING count(*) >= 30) AS r
ON user_id=rev_user
WHERE user_editcount >= 200
AND user_registration <= '20190315000000'
AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
AND user_name NOT REGEXP "Bot($|\b)"
AND user_name != "CommonsDelinker"
ORDER BY num_edits ASC;
SQL

Checking query status...
