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

Q&A for Ubuntu users and developers

SELECT TOP 10 Posts.Id as [Post Link], Title, Score
FROM Posts
INNER JOIN PostNotices
ON Posts.Id = PostNotices.PostId
WHERE PostNotices.PostNoticeTypeId = 22

fork query

edited dec 6 anonymous

created may 20 10 sam.saffron