0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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 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

fork query

edited jul 17 17

created jun 7 17 doppelgreener