2

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jul 25 20

created jun 27 20 Eklavya