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