Answers by user upvoted after N days

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

Select
   p.Id as [Post Link],
   p.Score,
   cast(p.CreationDate as Date) as [Post Date],
   cast(min(v.CreationDate) as Date) as [Voted On]
FROM
  Posts p JOIN Votes v ON v.PostId = p.Id
WHERE 
   (p.OwnerUserId = ##userID##) 
   AND (p.PostTypeId=2)
   AND (v.VoteTypeId=2)
   AND (v.CreationDate > DATEADD(day, ##days##, p.CreationDate))
GROUP BY p.Id, p.Score, p.CreationDate

Enter Parameters

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