set @visual_edit_tag = (

  select

    ctd_id

  from

    change_tag_def

  where

    ctd_name = 'visualeditor'

);

​

select

  substring(rev_timestamp, 1, 6) as month,

  sum(ct_rev_id is not null) as visual_revisions,

  count(rev_id) as revisions,

  concat(

    if(

      count(rev_id) = 0,

      0,

      format(

        sum(ct_rev_id is not null) / count(rev_id) * 100.0,

        2

      )

    ),

    '%'

  ) as visual_percent

from

  actor,

  revision

left join

  change_tag

  on

    ct_rev_id = rev_id and

    ct_tag_id = @visual_edit_tag

where

  rev_timestamp > 20190000000000 and

  rev_actor = actor_user and

  actor_user not in (select ug_user from user_groups where ug_group = 'bot')

group by

  month

order by

  month asc;