Recent upvotes on the site

1

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results