iOS article edits rev_id and comment_text

SQL

SELECT 
r.rev_id,
ct.ct_rev_id,
cm.comment_text
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 cm 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 cm.comment_text LIKE '#article-'
AND r.rev_timestamp >= DATE_ADD(NOW(), INTERVAL -4 DAY)
LIMIT 20
-- AND r.rev_timestamp >= 2024020600000

SQL

Checking query status...