Q&A for people looking to bypass life's everyday problems with simple tricks
select Comments.Id as [Comment Link], Comments.UserId as [User Link], Posts.ClosedDate as Closed, Comments.CreationDate from Comments
inner join Posts on Comments.PostId = Posts.Id
lower(Text) like '%downvot%' or
lower(Text) like '%down vot%' or
lower(Text) like '%down-vot%' or
lower(Text) like '%downrat%'
) and Text not like '%idownvotedbecau.se%' and Comments.CreationDate >= '2023-01-01'
order by Comments.CreationDate DESC