Anonymous feedback on a question and its answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT
   pf.PostId as [Post Link],
   SUM(CASE WHEN pf.VoteTypeId = 2 THEN 1 ELSE NULL END) AS Anon_up,
   SUM(CASE WHEN pf.VoteTypeId = 3 THEN 1 ELSE NULL END) AS Anon_down
FROM
  PostFeedback pf 
JOIN Posts p ON p.Id = pf.PostId
WHERE  p.OwnerUserId = ##userID##
GROUP BY pf.PostId
ORDER BY pf.PostId

Enter Parameters

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