Android #suggestededit-add-image edits by wiki

SQL

-- WITH android_se_edits AS (
SELECT 
r.rev_timestamp, 
a.actor_name, 
p.page_title,
comment.comment_text, 
r.rev_id AS rev_id,
ct_tag_id,
ctd_name
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 ('android app edit', 'mw-reverted')
AND comment_text LIKE '%#suggestededit-add-image%'
  AND r.rev_timestamp > 20231001000000

SQL

Checking query status...