0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited feb 4 13

created feb 4 13 Daniel Beck