set @contenttranslation_tag = (

  select

    ctd_id

  from

    change_tag_def

  where

    ctd_name = 'content translation'

);

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count

from

    revision,

    change_tag,

    actor

where

    rev_timestamp > 20201000000000 and

    ct_rev_id = rev_id and

    ct_tag_id = @mobile_edit_tag and

    rev_actor = actor_id 

group by

    rev_actor

having

    count(rev_id) between 100 and 10000

order by

    edit_count desc;