Least liked questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with the lowest score to views ratio (must have 200 views or +1)

Emacs

Q&A for those using, extending or developing Emacs

-- Least liked questions
-- Questions with the lowest score to views ratio (must have 200 views or +1)

SELECT TOP 100
  Id AS [Post Link],
  Score,
  ViewCount,
  CAST(Score AS FLOAT)/ViewCount AS Ratio
FROM
Posts
WHERE
  PostTypeId = 1
  AND Score < 5
  AND (Score < 0 AND ViewCount >= 300 OR ViewCount >= 500)
  AND ViewCount < 10000 -- No "Famous" Questions
ORDER BY
  Ratio ASC

Enter Parameters

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