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

SQL

SELECT
  user_name,
  edits_before_2018,
  edits_after_2022
FROM user
INNER JOIN (SELECT
             rev_user_text AS edit_username,
             COUNT(rev_id) AS edits_after_2022
            FROM revision_compat
            WHERE rev_timestamp > "20220101000000"
            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_2018
            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_2018 >= "1"
AND edits_after_2022 >= "1"
AND user_registration IS NULL
ORDER BY edits_after_2022 DESC

SQL

Checking query status...