0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all posts that have had a bounty opened

Q&A for professional and enthusiast programmers

--CREATE TABLE #BountyQuestion (Id int)
--INSERT #BountyQuestion
SELECT Posts.Id as [Post Link]
FROM Posts
    INNER JOIN Votes             ON Posts.Id       = Votes.PostId
    INNER JOIN PostTags          ON Posts.Id       = PostTags.PostId
    INNER JOIN Tags              ON PostTags.TagId = Tags.id
WHERE   Posts.PostTypeId         = 1         -- PostTypeId = 1 ->Question
    AND Votes.VoteTypeId         = 8         -- VoteTypeId = 8 -> BountyStart
    AND Tags.TagName   = '##TagName##'
    AND DateDiff(day,Votes.CreationDate,GetDate())<8

--SELECT Id FROM #BountyQuestion
--EXCEPT 
--SELECT Id FROM #BountyQuestion
--WHERE NOT 9 IN (                             -- VoteTypeId = 9 -> BountyClose
--             SELECT Votes.VoteTypeId FROM Votes, Posts Answers 
--                WHERE Votes.PostId = Answers.Id
--                AND Answers.ParentId=#BountyQuestion.Id
--            )

fork query

edited jan 16 15 Ortomala

created jun 23 11 Michael Mrozek