Articles with a single editor (inspired by Saeidpourbabak)

SQL

SET @MAGIC := 1000;
USE enwiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']] (',p1.page_len,' characters)') AS title
FROM revision AS r1
JOIN page AS p1 ON r1.rev_page = p1.page_id
JOIN actor ON r1.rev_actor = actor_id
WHERE p1.page_namespace = 0 # Mainspace.
AND p1.page_is_redirect = 0
AND p1.page_len > @MAGIC # Filter out small pages, as they are often disambiguation pages.
AND actor_name NOT LIKE "%bot" # Exclude bots and anonymous editors.
AND actor_name NOT LIKE "%Bot" # Unfortunately using LOWER() in the line above does not seem to work
AND actor_name NOT LIKE "%BOT"
AND actor_name NOT LIKE '%script%'
AND NOT IS_IPV4(actor_name)
AND NOT IS_IPV6(actor_name)
AND NOT EXISTS ( # No two editors for the same page.
  SELECT null
  FROM revision AS r2
  JOIN page AS p2 ON r2.rev_page = p2.page_id
  WHERE p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  AND p1.page_id = p2.page_id 
  AND r1.rev_actor <> r2.rev_actor
)
LIMIT 300; # If the query times out, reduce this.
SQL

Checking query status...
