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 rev_actor = 482
  AND page_namespace = 0
LIMIT 100)
  
SELECT page_title, rev_timestamp, contributions
FROM (SELECT creations.page_title, creations.page_len, creations.rev_timestamp, SUM(ABS(CAST(childRev.rev_len as SIGNED) - CAST(parentRev.rev_len as SIGNED))) as contributions
FROM creations
LEFT JOIN revision_userindex AS childRev ON page_id = childRev.rev_page
LEFT JOIN revision_userindex AS parentRev ON childRev.rev_parent_id = parentRev.rev_id
GROUP BY creations.page_id)

SQL

Checking query status...