1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

Select
PostHistory.PostId as [Post Link], PostHistory.UserId as [User Link], PostHistory.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 CreationDate

fork query

created oct 14 18 Martin20528