0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

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
  where (
      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 >= '2024-08-01'
  order by Comments.CreationDate DESC

fork query

edited sep 13

created oct 4 18 E_net4