Questions which were in HNQ and were later closed

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],
    concat('site://posts/',
          p.Id,
          '/revisions'
          ) [Revisions Link],
  ph1.CreationDate, ph2.CreationDate,
  DATEDIFF(day, ph1.CreationDate, ph2.CreationDate) AS Days,
  DATEDIFF(hour, ph1.CreationDate, ph2.CreationDate) AS Hours,
  DATEDIFF(minute, ph1.CreationDate, ph2.CreationDate) AS Minutes,
  DATEDIFF(second, ph1.CreationDate, ph2.CreationDate) AS Seconds,
  p.OwnerUserId AS [User Link],
  p. Score, p.Tags
FROM Posts p INNER JOIN PostHistory ph1 ON (p.Id=ph1.PostId and ph1.PostHistoryTypeId=52)
  INNER JOIN PostHistory ph2 ON (p.Id=ph2.PostId and ph2.PostHistoryTypeId=10 and (ph1.CreationDate < ph2.CreationDate))
ORDER BY p.ID DESC
---52 = Question became hot network question
---10 = Post Closed - post voted to be closed

Enter Parameters

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