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 actor_name = "Lugnuts"
  AND page_namespace = 0)

SET STATEMENT max_statement_time = 1200 FOR (SELECT page_title, rev_timestamp
FROM creations
LEFT JOIN (SELECT page_id
	FROM creations
    JOIN revision_userindex 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...