Untitled query #85985

SQL

WITH users AS (
  SELECT DISTINCT actor_id, actor_name, LEFT(user_registration, 6) as registration
  FROM actor
  JOIN user ON actor_user = user_id
  WHERE actor_name IN ("Levivich", "האופה", "Bluethricecreamman", "ABHammad", "Selfstudier", "fiveby", "IOHANNVSVERVS", "Sean.hoyland", "Iskandar323", "Dan Murphy", "Nableezy", "BilledMammal", "Zero0000", "PeleYoetz", "TarnishedPath", "Nishidani", "DMH223344", "M.Bitton")

),

revisions AS (
  SELECT rev_id, rev_page, page_title, actor_id, actor_name, rev_timestamp, page_namespace, registration, rev_len, rev_parent_id
  FROM revision_userindex
  JOIN page ON page_id = rev_page
  JOIN users ON actor_id = rev_actor
  WHERE page_namespace IN (0, 1)
  AND rev_timestamp > 20240828000000
),

revisions_delta AS (
  SELECT revision.rev_id, revision.rev_page, page_title, actor_id, actor_name, revision.rev_timestamp, page_namespace, registration, GREATEST(CAST(revisions.rev_len AS SIGNED) - CAST(revision.rev_len AS SIGNED),0)
  FROM revisions
  JOIN revision ON revision.rev_id = revisions.rev_parent_id
)

SELECT *
FROM revisions_delta
SQL

Checking query status...
