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)

Esperanto Language

Q&A for teachers and students of the Esperanto language

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 CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results