Untitled query #44972

SQL

use fawiki_p;
select
  page_id,
  page_title,
  SUM(
    CASE
      WHEN ct_tag_id = 10 THEN 1
      ELSE 0
    END
  ) AS undos,
  SUM(
    CASE
      WHEN actor_user IS NULL THEN 1
      ELSE 0
    END
  ) AS ips
FROM (
  select
    rc_id,
    rc_timestamp,
    actor_user,
    actor_name,
    comment_text,
    rc_this_oldid,
    page_id,
    ct_tag_id
  from recentchanges
  join revision
    on rc_this_oldid = rev_id
  join page
    on rev_page = page_id
  join comment
    on rc_comment_id = comment_id
  join actor_revision
    on rc_actor = actor_id
  left join change_tag
    on ct_rc_id = rc_id
    and ct_tag_id = 10 -- mw-undo
  where rc_timestamp > '20200501000000'
) RC
GROUP BY
  page_id,
  page_title
SQL

Checking query status...
