Articles with a single editor

SQL

USE enwiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]'), actor_name
#SELECT *
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
AND p1.page_is_redirect = 0
AND LOWER(actor_name) NOT LIKE "%bot"
AND NOT EXISTS (
  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
)
AND r1.rev_timestamp < 20100922181003
SQL

Checking query status...
