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

0

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

Options:
Switch sites:
loading Hold tight while we fetch your results