Untitled query #65860

SQL

SELECT DISTINCT page_title, comment_text, r1.rev_actor
FROM revision_userindex AS r1
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
LEFT JOIN page AS p1 ON p1.page_id = rev_page
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND (
  comment_text LIKE "ایجاد_شده_به‌واسطهٔ_ترجمهٔ_صفحهٔ%"
  OR comment_text LIKE "ایجاد_شده_توسط_ترجمهٔ_صفحهٔ%"
)

AND 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_timestamp > r2.rev_timestamp
  AND r1.rev_actor <> r2.rev_actor
)
LIMIT 10;
SQL

Checking query status...
