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