SELECT TOP 1000 vdt.UserId as [User Link], SUM(vdt.vcount),

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

SELECT TOP 1000
  vdt.UserId as [User Link],
  SUM(vdt.vcount),
  vdt.Reputation
FROM
( 
  SELECT 
    p.OwnerUserId as UserId,
    COUNT(*) as vcount,
    u.Reputation
  FROM VOTES v
  LEFT JOIN Posts p on p.Id = v.PostId
  INNER JOIN Users u ON u.Id = p.OwnerUserId
  WHERE ( v.VoteTypeId = 2 ) 
    AND v.CreationDate != CAST(p.CreationDate as DATE)
    AND ( v.CreationDate > DATEADD(dd, -##DateRange:int?14##, GETDATE()) )
    AND u.Reputation < 100000
  GROUP BY 
    p.PostTypeId,
    v.Id / 1000,
    p.OwnerUserId,
    u.Reputation
) vdt
WHERE 
  vdt.vcount > 2
GROUP BY 
  vdt.UserId, vdt.Reputation
ORDER BY SUM(vdt.vcount) DESC

Enter Parameters

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