0

Please login or register to vote for this query.

(click on this box to dismiss)

Get the worst posts made by some of the top-end users

Q&A about the site for music historians, critics, and fans

-- Bad Moments for Top Users
-- Get the worst posts made by some of the top-end users

SELECT 
OwnerDisplayName as [User],
Score, PostTypeID as [Post Type], 
Title, 
'http://stackoverflow.com/q/' + Cast(Id as varchar) as URL
FROM posts WHERE OwnerUserId in (SELECT Id FROM Users WHERE Reputation > 5000) 
AND Score < 0
AND PostTypeID <> 6 -- hide mod election posts (ppz hate them)
ORDER BY Score

fork query

edited nov 26 12 anonymous

created dec 23 11 Alex Coplan