0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT p.Score, h.PostId AS [Post Link], CAST(h.CreationDate AS Date) AS [Locked Date]
FROM PostNotices h
INNER JOIN Posts p ON p.ID = h.PostId
INNER JOIN PostNotices n ON p.ID = n.PostId
WHERE
      h.Id IN (
        SELECT MAX(Id)
        FROM PostHistory
        GROUP BY PostId
      )
  AND h.PostNoticeTypeId = 2
ORDER BY h.CreationDate

fork query

edited jul 23 anonymous

created jan 12 21 peterh (2)