1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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

fork query

edited jan 14 24

created jan 14 24 Martin20528