SELECT 

    actor_name AS editor, 

    comment_text AS edit_summary, 

    rev_timestamp 

FROM revision 

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 

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

    AND comment_text LIKE '%I swear to god%' 

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

ORDER BY rev_timestamp DESC 

LIMIT 100;

​