Recent bounties with a given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP ##number?100##
  --number: Number of questions to query:
  p.Id AS [Post Link],
  p.Score AS 'Score',
  p.AnswerCount AS 'Answers',
  bs.BountyAmount AS 'Amount',
  p.Tags,  
  convert(varchar(10), bs.CreationDate, 120) AS 'Bounty Start'
FROM Posts p
INNER JOIN Votes bs
    ON p.Id = bs.PostId
    AND bs.VoteTypeId = 8  -- BountyStart
    AND p.Tags LIKE '%<##Tagname##>%'
ORDER BY bs.CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results