use jvwiki_p;

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count

from

    revision,

    actor

where

    rev_timestamp > 20190100000000 and

    rev_actor = actor_id

group by

    rev_actor

having

    count(rev_id) between 500 and 1000

order by

    edit_count desc;