use tewiki_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"

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 article.page_title

order by

  day asc;