Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT TOP(##num?500##) v.VoteTypeId, CASE v.VoteTypeId WHEN 1 THEN 'Accepted' WHEN 2 THEN 'UpMod' WHEN 3 THEN 'DownMod' WHEN 4 THEN 'Offensive' WHEN 5 THEN 'Favorite' WHEN 6 THEN 'Close' WHEN 7 THEN 'Reopen' WHEN 8 THEN 'BountyStart' WHEN 9 THEN 'BountyClose' WHEN 10 THEN 'Deletion' WHEN 11 THEN 'Undeletion' WHEN 12 THEN 'Spam' WHEN 15 THEN 'ModeratorReview' WHEN 16 THEN 'ApproveEditSuggestion' END, v.CreationDate, p.Id AS [Post Link], CASE p.PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' END ---only questions and answers can have votes FROM Votes v INNER JOIN Posts p ON v.PostId=p.Id WHERE (v.VoteTypeId IN (##types?2,3##)) ORDER BY v.CreationDate DESC