Fork of
hewiki edits November 2020 (mobile/all)
by Amire80
This query is marked as a draft
This query has been published
by Amire80.
SQL
x
use enwiki_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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.