0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

SELECT TOP 10 v.Id, v.CreationDate, u.Id
  FROM votes v
 INNER JOIN posts p
  ON v.PostId = P.Id 
 INNER JOIN users u
  ON P.OwnerUserId = u.Id
 WHERE (v.CreationDate BETWEEN DATEADD(week,-2,'##Date1?2021-10-01##') AND '##Date1?2021-10-01##')
  AND p.PostTypeId =2
  AND v.VoteTypeId = 2

view current version

edited jan 27

created jan 27 bwhoslkw