Fork of
CXT edits overwriting an existing page
by Cryptic
This query is marked as a draft
This query has been published
by Cryptic.
SQL
AخA
SELECT DISTINCT page_namespace, page_title
FROM revision r1
JOIN change_tag ct1
ON ct1.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 ct1.ct_tag = 'contenttranslation'
AND r1.rev_id != r2.rev_id
AND NOT EXISTS (SELECT * FROM change_tag ct2
WHERE ct2.ct_rev_id = r2.rev_id
AND ct2.ct_tag = 'contenttranslation');
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.