Flags per user (doesn't work)

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 TOP 250
     PostHistory.UserId [User Link] , 
     count(*) as [FlagCount]
FROM PostHistory
--WHERE PostHIstory.PostHistoryTypeId in (10,11,12,13,14,15,19,20)
--AND PostHistory.UserId = 78804
GROUP BY PostHistory.UserId
ORDER BY count(*)desc

Enter Parameters

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