Untitled query #88220

SQL

SELECT 
    r.rev_id AS revision_id,
    r.rev_timestamp AS revision_timestamp,
    t_before.old_text AS before_text,
    t_after.old_text AS after_text
FROM revision r
JOIN content c_after ON r.rev_content_id = c_after.content_id
JOIN enwiki_text t_after ON c_after.content_address = CONCAT('tt:', t_after.old_id)
LEFT JOIN revision r_parent ON r.rev_parent_id = r_parent.rev_id
LEFT JOIN content c_before ON r_parent.rev_content_id = c_before.content_id
LEFT JOIN enwiki_text t_before ON c_before.content_address = CONCAT('tt:', t_before.old_id)
JOIN change_tag ct ON ct.ct_rev_id = r.rev_id
WHERE ct.ct_tag_id = (SELECT tag_id FROM change_tag_def WHERE ctd_name = 'mw-revert')
ORDER BY r.rev_timestamp DESC
LIMIT 500;
SQL

Checking query status...
