All editors on Indonesian Wikipedia by registration date 2003–2017, 5+ edits 2022+

SQL

SELECT
  user_name,
  edits_after
FROM user
INNER JOIN (SELECT
             rev_user_text AS edit_username,
             COUNT(rev_id) AS edits_after
            FROM revision_compat
            WHERE rev_timestamp > "20210101000000"
            GROUP BY edit_username
           ) AS last_edits
           ON user.user_name = edit_username
INNER JOIN (SELECT
             rev_user_text AS edit_username2,
             COUNT(rev_id) AS edits_before
            FROM revision_compat
            WHERE rev_timestamp > "20030101000000"
            AND rev_timestamp < "20180101000000"
            GROUP BY edit_username2
           ) AS before_edits
           ON user_name = edit_username2
WHERE edits_before >= "1"
AND edits_after >= "1"
AND user_registration IS NULL
ORDER BY edits_after DESC

SQL

Checking query status...