Untitled query #65860

SQL

SELECT page_title, comment_text
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 "ایجاد_شده_به‌واسطهٔ_ترجمهٔ_صفحهٔ%"

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...
