Untitled query #68690

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 > "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
            FROM revision_compat
            WHERE rev_timestamp > "20100101000000"
            AND rev_timestamp < "20210101000000"
            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...
