Untitled query #48483

SQL

USE fawiki_p;
SELECT DISTINCT page_title#, page_namespace, rev_timestamp
FROM revision AS r1 JOIN page AS p1 ON r1.rev_page = p1.page_id
WHERE p1.page_namespace = 0 # Articles
AND p1.page_is_redirect = 0
AND r1.rev_actor = 481 # Saeidpourbabak
AND EXISTS (
  SELECT null
  FROM revision AS r2 JOIN page AS p2 ON r2.rev_page = p2.page_id
  WHERE p2.page_namespace = 0 # Articles
  AND p2.page_is_redirect = 0
  AND p1.page_id = p2.page_id # Saeidpourbabak
  AND r1.rev_actor <> r2.rev_actor # Saeidpourbabak
)


#ORDER BY rev_timestamp
limit 10;
SQL

Checking query status...
