Q&A for professional and enthusiast programmers
declare @question int = 1; declare @initTag int = 3; declare @tagToSearch nvarchar(35) = ##tag1:string?gas##; declare @tagToSearch2 nvarchar(35) = ##tag2:string?google-apps-script##; select cast(PH.CreationDate as date), Posts.Tags, Posts.Id as [Post Link] from Posts inner join PostHistory as PH on PH.PostId = Posts.Id where Posts.PostTypeId = @question and PH.PostHistoryTypeId = @initTag and ( charindex('<' + @tagToSearch + '>', PH.Text) > 0 and Posts.Tags not like ('%<' + @tagToSearch + '>%') and Posts.Tags like ('%<' + @tagToSearch2 + '>%' ) ) group by Posts.Tags,Posts.Id, cast(PH.CreationDate as date) order by cast(PH.CreationDate as date) desc