1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP(##num?500##)
  p.Id AS [Post Link], 
  p.CreationDate, 
  h.CreationDate, 
  p.Score,
  p.ViewCount, 
  p.AnswerCount, 
  p.Tags
FROM Posts p 
JOIN PostHistory h ON p.Id = h.PostId
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
WHERE h.PostHistoryTypeId = 52
AND p.PostTypeId=1 
AND t.TagName = ##tag:string##
ORDER BY p.Id DESC

fork query

edited aug 13 19 shepmaster

created jun 24 19 Martin20528