Most controversial posts on the site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT DISTINCT TOP 100 Posts.Id as [Post Link], Title, Score
FROM Posts
INNER JOIN PostNotices
ON Posts.Id = PostNotices.PostId
WHERE PostNotices.PostNoticeTypeId = 22
AND ExpiryDate is null
ORDER BY Score DESC


SELECT * FROM PostNotices WHERE PostId = 549

Enter Parameters

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