0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

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 '%downvoting%' or
      lower(Text) like '%down voting%' or
      lower(Text) like '%down-voting%' or
      lower(Text) like '%downvote%' or
      lower(Text) like '%down vote%' or
      lower(Text) like '%down-vote%' or
      lower(Text) like '%downrate%'
    ) and Comments.CreationDate > '2019-12-10'
  order by Comments.CreationDate DESC

view current version

edited dec 29 19

created oct 4 18 E_net4