The most-viewed unanswered questions for a tag - Asked in Last N Days

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select top 2000 q.Id as [Post Link],  q.ViewCount
  from Posts q
    INNER JOIN PostTags ON q.Id = PostTags.PostId
    INNER JOIN Tags ON PostTags.TagId = Tags.id
where (select count(*) from Posts a where a.ParentId = q.Id and a.Score > 0) = 0
and CommunityOwnedDate is null and ClosedDate is null and q.ParentId is null 
and AcceptedAnswerId is null
AND Tags.TagName LIKE '%sql-server%'
ORDER BY q.ViewCount DESC

Enter Parameters

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