USE dewiki_p;

#SELECT * FROM revision_compat limit 1;

SELECT

 user_name,

 user_editcount AS totale_edits,

 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 > "20200000000000"

            GROUP BY edit_username

           ) AS last_edits

           ON user_name = edit_username

WHERE edits_after > "20"

AND edits_after < "1000"

LIMIT 10;