Who's the most enlightened?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

DECLARE @min_enlightenment int = ##MinimumEnlightenment:int?2##

SELECT TOP 200
  RANK() OVER (ORDER BY COUNT(*) DESC),
  b.UserId AS [User Link],
  COUNT(*) AS [Enlightenment],
  'site://help/badges/19/enlightened?userid='+CAST(b.UserId AS varchar)+'|link' AS [Instances]
FROM Badges AS b
WHERE b.Name = 'Enlightened'
GROUP BY b.UserId
HAVING COUNT(*) >= @min_enlightenment
ORDER BY [Enlightenment] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results