1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 9 19

created jan 9 19 Martin20528