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;