Top viewcount by tagname

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

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 sites:
loading Hold tight while we fetch your results