Replica revisions query with CID 1232

Fork of Replica revisions query with CID 1232 by Wes (Wiki Ed)

This query is marked as a draft This query has been published by Sage (Wiki Ed).

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 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 revision_userindex c
LEFT JOIN revision_userindex p ON p.rev_id = c.rev_parent_id
INNER JOIN page g ON g.page_id = c.rev_page
LEFT JOIN change_tag ct
  ON ct.ct_rev_id = c.rev_id
  AND ct.ct_tag IN ('OAuth CID: 1232')
WHERE g.page_namespace IN (0,1,2,3,4,5,10,11,118,119)
AND c.rev_user_text IN ('Rasulda')
AND c.rev_timestamp BETWEEN '20130101' AND '20190203'

SQL

Checking query status...