Q&A for professional and enthusiast programmers
SELECT u.id, u.reputation FROM users u LEFT OUTER JOIN badges b ON b.userid = u.id AND b.name IN ('Copy Editor', 'Electorate', 'Famous Question', 'Fanatic', 'Great Answer', 'Great Question', 'Legendary', 'Marshal', 'Populist', 'Publicist', 'Reversal', 'Stellar Question', 'Steward', 'Unsung Hero') GROUP BY u.id, u.reputation, b.name HAVING b.name IS NULL ORDER BY u.reputation DESC