Questions which no longer have the given tag (but had it at some point)

1

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

Select
Distinct Posts.Id as [Post Link], 
url = 'site://posts/' + CAST(Posts.Id AS varchar)+'/revisions',
Posts.Creationdate, Posts.LastActivityDate
From PostHistory INNER JOIN Posts
  ON PostHistory.PostId=Posts.Id
where PostHistory.PostHistoryTypeId in (3,6,9) 
  and PostHistory.Text Like '%<##tagName##>%'
  and NOT(Posts.Tags Like '%<##tagName##>%')
Order By Posts.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results