Find all answers which are posted before a bounty is raised by the asker

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 distinct posts.id, posts.parentid as parent, R.postid, posts.creationDate, R.creationDate
from posts, (select creationDate, postid from votes where votetypeid=8 and bountyAmount > 0) R
where parentid in
(
select postid from votes where votetypeid=8 and bountyAmount > 0
)
and posttypeid=2
and R.creationDate > posts.creationDate
and posts.parentid = R.postid

Enter Parameters

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