Users with most hot network questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP(##num?100##)
  COUNT (DISTINCT p.Id), p.OwnerUserId as [User Link], p.OwnerDisplayName
FROM Posts p JOIN PostHistory ph ON p.Id=ph.PostId
WHERE (ph.PostHistoryTypeId=52)
GROUP by p.OwnerUserId, p.OwnerDisplayName
ORDER BY COUNT (DISTINCT p.Id) DESC

Enter Parameters

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