0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited dec 6 12

created dec 6 12 AbdulFattah