SQL
AخA
SELECT DISTINCT page_namespace, page_title
FROM revision r1
JOIN change_tag
ON ct_rev_id = r1.rev_id
JOIN page
ON page_id = r1.rev_page
JOIN revision r2
ON r2.rev_id = (SELECT r2.rev_id
FROM revision r2
WHERE r2.rev_page = r1.rev_page
ORDER BY r2.rev_timestamp ASC
LIMIT 1)
WHERE ct_tag = 'contenttranslation'
AND r1.rev_id != r2.rev_id;
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.