Untitled query #32017

SQL

use fawiki_p;
select
  left(rev_timestamp, 6) as `rev_month`,
  rev_user as `local_user_id`,
  count(*) as `edits`,
  sum(page_namespace = 0) as content_edits,
  sum(
    ctd_name = "mobile edit" and
    (ctd_name = "mobile web edit" or ctd_name != "mobile app edit")
  ) as mobile_web_edits,
  sum(ctd_name = "mobile app edit") as mobile_app_edits,
  sum(ctd_name = "visualeditor" and ctd_name != "visualeditor-wikitext") as visual_edits,
  sum(ctd_name = "visualeditor-wikitext") as ve_source_edits,
  0 as `deleted`
from revision
left join page on rev_page = page_id
left join change_tag on rev_id = ct_rev_id
left join change_tag_def on ct_tag_id = ctd_id
where rev_timestamp between "2018-12-01" and "2018-12-10"
group by left(rev_timestamp, 6), rev_user;
SQL

Checking query status...
