Questions with most views

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 200 questions with the most views

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Questions with most views
-- The top 200 questions with the most views

SELECT TOP 20 Posts.Id
AS [Post Link], 
ViewCount,
AnswerCount, 
FavoriteCount, 
Score
FROM Posts 

LEFT JOIN PostTags 
ON PostTags.PostId = Posts.ParentId
    
LEFT JOIN Tags
ON Tags.Id = PostTags.TagId

ORDER BY ViewCount DESC

Enter Parameters

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