Stack Exchange Data Explorer
Apr 28 '19 at 22:12
SELECT TOP 1000 u.id as [User Link], u.id, u.location, CO...
Select Users with most combined PostHistory, Comments and Votes
Get activity timestamps for a user
SELECT Top 10 commentcount from ( SELECT U.Id, COUNT(C.ID...
Most active users (action every X min)
DECLARE @dt DateTime = getdate() SELECT TOP 100 UserId A...
SELECT * from posthistorytypes
SELECT id AS [User Link], loc, [Total] = (numposts + comm...
SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY u.Reputation DE...
SELECT TOP 10 ROW_NUMBER() OVER(ORDER BY Reputation DESC)...
site design / logo © 2020 Stack Exchange Inc; user contributions licensed under
; see the
licensing help page
for more info