Untitled query #80054

SQL

SELECT
  SUM(CASE WHEN change_tag_def.ctd_name = 'visualeditor' OR  change_tag_def.ctd_name = 'visualeditor-switched' THEN 1 ELSE 0 END) AS visual_editor_count,
  SUM(CASE WHEN change_tag_def.ctd_name <> 'visualeditor' OR change_tag_def.ctd_name IS NULL THEN 1 ELSE 0 END) AS other_count
FROM revision
LEFT JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
LEFT JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
JOIN page ON revision.rev_page = page.page_id
LEFT JOIN actor ON revision.rev_actor = actor.actor_id
WHERE
  page.page_namespace = 0 
  AND actor.actor_user IS NULL 
  AND EXTRACT(YEAR_MONTH FROM revision.rev_timestamp) = 202401
  AND revision.rev_parent_id != 0; -- Exclude revisions that are the creation of a page
SQL

Checking query status...
