Untitled query #66457

SQL

WITH creations as (SELECT page_title, page_id, rev_timestamp, page_len, rev_len
FROM revision_userindex
JOIN page ON page_id = rev_page
WHERE page_title = 'Roman_Geszlecht'
  AND rev_parent_id = 0
  AND page_is_redirect = 0
  AND page_namespace = 0)
  
SELECT page_title, rev_timestamp, page_len, deltas, cl_to
FROM (SELECT creations.page_title, creations.page_id, creations.page_len, creations.rev_timestamp, ABS(CAST(childRev.rev_len as SIGNED) - CAST(parentRev.rev_len as SIGNED)) as deltas
FROM creations
LEFT JOIN revision_userindex AS childRev ON page_id = childRev.rev_page AND rev_actor = 482
      LEFT JOIN revision_userindex AS parentRev ON childRev.rev_parent_id = parentRev.rev_id) as A
LEFT JOIN categorylinks ON cl_from = page_id AND (
  cl_to = 'Disambiguation_pages' OR
  cl_to = 'Human_name_disambiguation_pages' OR
  cl_to LIKE 'List%')
WHERE cl_to IS NULL
SQL

Checking query status...
