SQL
AخA
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 OR user.user_autoconfirmed = 0)
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.