Replica revisions query with CID 1232

SQL

SELECT g.page_id, g.page_title, g.page_namespace,
  c.rev_id, c.rev_timestamp, c.rev_user_text, c.rev_user,
  case when ct.ct_tag_id IS NULL then 'false' else 'true' end as system,
  case when c.rev_parent_id = 0 then 'true' else 'false' end as new_article,
  CAST(c.rev_len AS SIGNED) - CAST(IFNULL(p.rev_len, 0) AS SIGNED) AS byte_change
FROM frwiki_p.revision_userindex c
LEFT JOIN frwiki_p.revision_userindex p ON p.rev_id = c.rev_parent_id
INNER JOIN frwiki_p.page g ON g.page_id = c.rev_page
LEFT JOIN frwiki_p.change_tag_def ctd
  ON ctd.ctd_name IN ('OAuth CID: 1232')
LEFT JOIN frwiki_p.change_tag ct
  ON ct.ct_rev_id = c.rev_id
  AND ct.ct_tag_id = ctd.ctd_id
WHERE g.page_namespace IN (0,1,2,3,4,5,10,11,118,119)
AND c.rev_user_text IN ('Symac')
AND c.rev_timestamp BETWEEN '20190101' AND '20190203'
SQL

Checking query status...
