Question which had the tag but no longer have it (including the editor)


Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

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

with firstrev_cte AS
SELECT MIN(ph.Id) AS MinId, p.Id 
FROM Posts p JOIN PostHistory ph ON ph.PostId=p.Id
WHERE ph.Text LIKE '%<##tagName##>%' AND NOT (p.Tags LIKE '%<##tagName##>%')

SELECT PostId AS [Post Link],
  url = 'site://posts/' + CAST(PostId AS varchar)+'/revisions',
  UserId AS [User Link], UserDisplayName, CreationDate
FROM PostHistory INNER JOIN firstrev_cte ON PostHistory.Id=MinId
ORDER BY CreationDate DESC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results