Answers by user upvoted after N days

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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 main site
loading Hold tight while we fetch your results