SELECT TOP 10 Posts.Id as [Post Link] FROM Posts JOIN Vot...

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 10 Posts.Id as [Post Link]
FROM Posts
    JOIN Votes ON Votes.PostId = Posts.Id
      and Posts.PostTypeId = 1 -- questions
      and Votes.BountyAmount > 0
      and Posts.AnswerCount = 0
      and Posts.AcceptedAnswerId IS NULL
      and Posts.CreationDate < '2016-05-01'
ORDER BY Posts.CreationDate DESC

Enter Parameters

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