Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
declare @TagString1 nvarchar(25) = ##tagName1:string## declare @TagString2 nvarchar(25) = ##tagName2:string## declare @TagString3 nvarchar(25) = ##tagName3:string## declare @TagString4 nvarchar(25) = ##tagName4:string## declare @TagString5 nvarchar(25) = ##tagName5:string## declare @TagString6 nvarchar(25) = ##tagName6:string## declare @TagString7 nvarchar(25) = ##tagName7:string## declare @TagString8 nvarchar(25) = ##tagName8:string## declare @TagString9 nvarchar(25) = ##tagName9:string## select TOP ##ResultSize## ViewCount, Score,Tags, Id AS [Post Link] from Posts where Id in ( select PostId from PostTags where TagId IN ( ( select Id from Tags where TagName IN (@TagString1,@TagString2,@TagString3,@TagString4,@TagString5,@TagString6) )) ) AND CreationDate > GETDATE() - ##Days## AND CreationDate < GETDATE() - ##Olddays## ORDER by ViewCount DESC