My downvote comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

All comments by me or to me with "-1" in the text.

Stack Overflow

Q&A for professional and enthusiast programmers

-- My downvote comments
-- All comments by me or to me with "-1" in the text.

SELECT
  Comments.Text,
  [User Link] = Comments.UserId,
  [Post Link] = Comments.PostId

FROM Comments
INNER JOIN Posts ON Posts.Id = Comments.PostId
WHERE
  Comments.Text LIKE '%-1%'
  AND (
    Posts.OwnerUserId = ##UserId##
    OR Comments.UserId = ##UserId##
  )
ORDER BY Posts.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results