0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

-- SELECT TOP 1000 *
-- FROM PostHistory
-- WHERE PostHistoryTypeId = 12

;with records
as
(
  SELECT a.PostID, 
         a.CreationDate,
         a.PostHistoryTypeId,
         ROW_NUMBER() OVER (PARTITION BY a.PostID ORDER BY a.CreationDate DESC) seq,
         b.Name
  FROM   PostHistory a
          INNER JOIN PostHistoryTypes b
            ON a.PostHistoryTypeId = b.Id
)
SELECT TOP 5000 a.*,
      b.Title,
      'http://stackoverflow.com/questions/' + CAST(b.ID AS VARCHAR(10)) AS QuestionLink
FROM   records a
      INNER JOIN Posts b
          ON b.Id = a.PostID
WHERE a.seq = 1 AND
      b.PostTypeId = 1

fork query

edited jan 26 14

created jan 26 14 anonymous