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