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, page_len
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
  AND page_len < 5000
LIMIT 100)

SELECT creations.page_title, creations.rev_timestamp
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
WHERE SUM(ABS(CAST(childRev.rev_len as SIGNED) - CAST(parentRev.rev_len as SIGNED))) > (creations.page_len / 2)
GROUP BY creations.page_id

SQL

Checking query status...