Top viewcount by tagname

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

select top 100 left(P.Id,50) as [Post Link], P.ViewCount
from
  Tags T, PostTags PT, Posts P
where 
T.Id = PT.TagId 
and P.Id = PT.PostId
and LOWER(T.TagName) = 'javascript'
order by P.ViewCount desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results