Top 500 SciFi Questions (Score/ViewCount)

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

--questionScore: Only view questions above a minimum vote score of: "Enter 0 (zero) to view all posts"
--questionViews: Or, only view questions with a minimum view count of: "Enter 0 (zero) to view all posts"

SELECT TOP 500 Title, Body, ViewCount, Score, Score/(ViewCount*1.00) Ratio
FROM Posts p JOIN PostTypes pt on p.PostTypeID = pt.ID
WHERE pt.Name = 'Question' and (Score > ##questionScore:int## or ViewCount > ##questionViews:int##)
ORDER BY Ratio DESC

Enter Parameters

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