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,
  page_title,
  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'
)
GROUP BY
  page_id,
  page_title
SQL

Checking query status...
