wiki edits 2020 (mobile/all)

Fork of wiki edits 2020 (mobile/all) by Ainali

This query is marked as a draft This query has been published by Miriam (WMF).

Based on queries #50040 and #50065. Template used to get percentage in various languages by changing the wiki used.

SQL

use `zh_yuewiki_p`;

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

select
  substring(rev_timestamp, 1, 4) as year,
  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 '2020%'
group by
  year
order by
  year asc;

SQL

Checking query status...