Questions with the most views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
'http://scifi.stackexchange.com/q/' + CAST(q.Id AS NVARCHAR) + '/4918|' + q.Title AS Question, 
q.ViewCount,
q.Tags
FROM Posts AS q 
WHERE ViewCount > 100000 AND PostTypeId = 1 
ORDER BY ViewCount DESC;

Enter Parameters

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