use guwiki_p;

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count,

    substr(user_registration, 1, 8) as registration_date

from

    revision,

    actor,

    user

where

    actor_user = user_id and

    user_registration between 20180500000000 and 20200500000000 and

    rev_timestamp > 20180500000000 and

    rev_actor = actor_id

group by

    rev_actor

having

    count(rev_id) between 50 and 100000

order by

    user_registration desc;