Top users with no gold badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

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