SQL
x
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 page_title 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 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.