Questions with a specific tag now and not at first revision

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Posts.Id as [Post Link],
  Posts.Tags,
  PostInits.Text as [Initial Tags],
  Posts.CreationDate
from Posts
inner join (
  select PostId, Text
  from PostHistory
  where PostHistoryTypeId = 3
  and Text not like '%##Tag##%'
) as PostInits on Posts.Id = PostInits.PostId
where Posts.Tags like '%##Tag##%'
and (DATEDIFF(month, Posts.CreationDate, GETDATE()) <= ##MaxQuestionAgeInMonths:int?24##)
and (DATEDIFF(month, Posts.CreationDate, GETDATE()) >= ##MinQuestionAgeInMonths:int?0##)
order by CreationDate desc

Enter Parameters

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