Lugnuts articles - no other significant contributions

SQL

WITH creations as (SELECT page_title, page_id, rev_timestamp
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND page_is_redirect = 0
  AND actor_name = "Lugnuts"
  AND page_namespace = 0
  AND rev_len > 150)

SELECT page_title, rev_timestamp
FROM creations
LEFT JOIN (SELECT page_id
	FROM creations
    JOIN revision_userindex AS revedit 
        ON page_id = rev_page
    JOIN actor_revision AS actedit
        ON actedit.actor_id = revedit.rev_actor
    LEFT JOIN revision AS revparent
        ON revparent.rev_id = revedit.rev_parent_id
    WHERE actor_name != "Lugnuts"
        AND ABS(CAST(revedit.rev_len as SIGNED) - CAST(revparent.rev_len as SIGNED)) > 1000
    GROUP BY page_id)
    AS revisions ON revisions.page_id = creations.page_id
WHERE revisions.page_id IS NULL
SQL

Checking query status...
