Q&A about the site for serious players and enthusiasts of poker
-- Returns all close voters since StartDate, ordered from most to least votes
-- Only counts closed votes that actually resulted in a closure,
-- and does not count deleted questions
-- I wouldn't recommend running this on StackOverflow due to its size
-- Variables - Set start date to timeframe you want
declare @startDate datetime
set @startDate = '1/1/2012'
SELECT TOP 10
FROM [Users] [u] (NOLOCK)
INNER JOIN [PostHistory] [ph] (NOLOCK) ON [ph].[Text] LIKE '%"Id":' + CAST([u].[Id] AS NVARCHAR) + ',%'
INNER JOIN [Posts] [p] (NOLOCK) ON [p].[Id] = [ph].[PostId]
[u].[Reputation] >= 3000 AND
[ph].[PostHistoryTypeId] = 10 AND -- 10 = "Post Closed"
[p].[ClosedDate] >= @startDate