Anonymous feedback to your posts

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.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 U.Id = ##UserId##
GROUP BY P.Id, VT.Id, P.LastActivityDate, P.Score, P.CreationDate, VT.Name
ORDER BY VoteCount DESC, VT.Id DESC

Enter Parameters

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