Harry Potter posts with the most views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT 
'http://scifi.stackexchange.com/q/' + CAST(q.Id AS NVARCHAR) + '/4918|' + q.Title AS Question, 
q.ViewCount,
q.Tags
FROM Posts AS q 
JOIN PostTags AS c ON q.Id = c.PostId 
JOIN Tags as t ON c.TagId = t.Id
WHERE ViewCount > 50000 AND PostTypeId = 1 
AND t.TagName = 'harry-potter'
ORDER BY ViewCount DESC;

Enter Parameters

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