iOS article edits rev_id and comment_text

Fork of Android #suggestededit-add-image edits and reverted by wiki by SNowick (WMF)

This query is marked as a draft This query has been published by SNowick (WMF).

iOS edits rev_id and comment_text

SQL

SELECT 
r.rev_id,
ct.ct_rev_id
FROM revision r
-- JOIN actor a ON rev_actor = actor_id
-- JOIN page p ON r.rev_page = p.page_id
JOIN change_tag ct ON ct_rev_id = rev_id
JOIN comment ON comment_id = r.rev_comment_id
LEFT JOIN change_tag_def tdef ON ct.ct_tag_id = tdef.ctd_id
-- WHERE ct_tag_id IN (SELECT ctd_id
-- FROM change_tag_def
WHERE ctd_name IN ('ios app edit', 'mw-reverted')
AND r.rev_timestamp >= DATE_ADD(NOW(), INTERVAL -14 DAY)
-- AND r.rev_timestamp >= 2024020600000

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...