Untitled query #52802

SQL

USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_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
AND p1.page_is_redirect = 0
AND LOWER(actor_name) = "Aryagolparvar"
AND page_title NOT LIKE "%(ابهام‌زدایی)"
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
)
LIMIT 5;
SQL

Checking query status...
