Android #suggestededit-add-image edits by wiki

SQL

SELECT 
revision.rev_timestamp, 
actor.actor_name, 
comment.comment_text, 
revision.rev_id,
change_tag.ct_tag_id,
ctd_name
FROM revision
JOIN actor ON rev_actor = actor_id
JOIN change_tag ON ct_rev_id = rev_id
JOIN comment ON comment_id = revision.rev_comment_id
LEFT JOIN change_tag_def tdef ON ct.ct_tag_id = tdef.ctd_id
WHERE ct_tag_id = (SELECT ctd_id
FROM change_tag_def
WHERE ctd_name LIKE '%android app edit%')
AND comment_text LIKE '%#suggestededit-add-image%'
AND revision.rev_timestamp > 20231001000000

SQL

Checking query status...