Articles created primarily by Lugnuts

This query produces a list of small articles that are created and primarily contain content by Lugnuts. This is currently defined as articles with a page length under 4000 with Lugnuts contributing more than half the content, but can be adjusted. In addition, redirects, lists and disambiguation pages are excluded.

SQL

WITH creations as (SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND page_is_redirect = 0
  AND actor_id = 482
  AND page_namespace = 0
LIMIT 100)
  
SELECT creations.page_title, creations.page_id, creations.rev_timestamp, SUM(ABS(CAST(childRev.rev_len as SIGNED) - CAST(parentRev.rev_len as SIGNED))) as delta
FROM creations
LEFT JOIN revision_userindex AS childRev ON page_id = childRev.rev_page
LEFT JOIN revision_userindex AS parentRev ON rev_parent_id = rev_id)
AS deltas ON creations.page_id = deltas.page_id
GROUP BY creations.page_id

SQL

Checking query status...