hewiki visual/all edits since 2013 experiment without bots

SQL

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;

SQL

Checking query status...