use tawiki_p;

​

set @mobile_edit_tag = (

  select

    ctd_id

  from

    change_tag_def

  where

    ctd_name = 'mobile edit'

);

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count

from

    revision,

    change_tag,

    actor

where

    rev_timestamp > 20210100000000 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 50 and 500

order by

    edit_count desc;