SELECT 

    actor_name AS editor, 

    comment_text AS edit_summary, 

    rev_timestamp 

FROM revision 

JOIN page ON revision.rev_page = page.page_id 

JOIN actor ON revision.rev_actor = actor.actor_id 

JOIN comment ON revision.rev_comment_id = comment.comment_id 

LEFT JOIN user ON actor.actor_user = user.user_id 

WHERE 

    page.page_namespace = 0  -- Only main article namespace

    AND rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 1 YEAR, '%Y%m%d%H%i%s') 

    AND comment_text LIKE 'I swear to god%' 

    AND (user.user_id IS NULL OR user.user_registration IS NULL) -- IP editors or non-autoconfirmed users

ORDER BY rev_timestamp DESC