0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- Gets all down votes for user
-- 

SELECT
  p.ParentId as [Post Link],
  p.Id,
  v.UserId
FROM
  Posts p
INNER JOIN PostTypes pt ON pt.Id = p.PostTypeId
INNER JOIN Votes v ON v.PostId = p.Id
INNER JOIN VoteTypes vt ON vt.Id = v.VoteTypeId
WHERE
  p.OwnerUserId = ##UserId## AND
  vt.Id = 3

fork query

created feb 17 11 Daniel DiPaolo