Get random questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT Top 30000 Questions.Id AS [Post Link], 
       Questions.Id as Id,
       Questions.ViewCount as ViewCount, 
       Questions.Score as Score,
       Questions.Body as Body,
       Questions.Title as Title,
       ROUND(1.0 * Questions.Score/Questions.ViewCount, 8) AS scTovc

FROM Posts AS Answers 
    INNER JOIN Posts AS Questions 
    ON Questions.Id = Answers.ParentId
    WHERE ROUND(1.0 * Questions.Score/Questions.ViewCount, 8) < -0.2

GROUP BY
Questions.Id, 
Questions.ViewCount,
Questions.Score,
Questions.Body,
Questions.Title

ORDER BY NEWID();

Enter Parameters

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