Lugnuts articles - no other significant contributions

This is a list of articles that Lugnuts has created and that no other editor has made significant contributions to.

SQL

WITH creations as (SELECT page_title, page_id, rev_timestamp
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND actor_name = "Lugnuts"
  AND page_namespace = 0)
  
SELECT page_title, rev_timestamp
FROM creations
LEFT JOIN (SELECT page_id
	FROM creations
    JOIN revision ON page_id = rev_page
	JOIN actor_revision ON actor_id = rev_actor
    WHERE actor_name != "Lugnuts"
    AND rev_len > 1000
    GROUP BY page_id)
    AS revisions ON revisions.page_id = creations.page_id
WHERE revisions.page_id IS NULL

SQL

Checking query status...