0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT v.postid-74764458 as Id, v.VoteTypeId+4 as Type, v.creationdate
FROM votes v
WHERE votetypeid between 2 and 3
  AND postid between 74764459 and 74764469


SELECT e.postid-74764458 as Id, e.PostHistoryTypeId-3 as Type, e.CreationDate
FROM PostHistory e
WHERE PostHistoryTypeId in (4, 5, 7, 8)
  AND postid between 74764459 and 74764469

fork query

edited jan 4 23

created jan 4 23 James.Risner