Anonymous feedback for a certain question and its answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(P.Id) VoteCount, VT.Name VoteType, P.Id as [Post Link], P.Id, U.DisplayName, P.Score,
P.CreationDate, P.LastActivityDate
FROM PostFeedback PF
JOIN Posts P ON P.Id = PF.PostId
JOIN Users U ON U.Id = P.OwnerUserId
JOIN VoteTypes VT ON PF.VoteTypeId = VT.Id
WHERE PF.IsAnonymous = 1 AND
(
P.Id = ##PostId## OR P.ParentId = ##PostId##
)
GROUP BY P.Id, VT.Id, P.LastActivityDate, P.Score, P.CreationDate, VT.Name, U.DisplayName
ORDER BY VoteCount DESC, VT.Id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results