What are the most viewed questions for a given tag (+date)?


Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

Q&A about the site for operations research and analytics professionals, educators, and students

declare @TagString nvarchar(25) = ##tagName:string##

select ViewCount, Title, CreationDate
from Posts 
where Id in
    select PostId 
    from PostTags 
    where TagId =
      select Id 
      from Tags 
      where TagName = @TagString
Group by ViewCount, Title, CreationDate
ORDER by ViewCount DESC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results