hewiki edits November 2020 (mobile/all)

Fork of hewiki edits November 2020 (mobile/all) by Lucas Werkmeister (WMDE)

This query is marked as a draft This query has been published by Amire80.

SQL

use igwiki_p;

set @mobile_edit_tag = (
  select
    ctd_id
  from
    change_tag_def
  where
    ctd_name = 'mobile edit'
);

select
  substring(rev_timestamp, 1, 8) as day,
  sum(ct_rev_id is not null) as mobile_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 mobile_percent
from
  revision
left join
  change_tag
  on
    ct_rev_id = rev_id and
    ct_tag_id = @mobile_edit_tag
where
  rev_timestamp like '202011%'
group by
  day
order by
  day asc;

SQL

Checking query status...