Edits by a specific user per day (without counting tags,title,body separatedly)

1

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT
  CAST(CreationDate as Date),
  COUNT(DISTINCT RevisionGUID)
  FROM PostHistory WHERE ((PostHistoryTypeId in (4,5,6)) AND (UserId=##userid##))
GROUP BY CAST(CreationDate as Date)
ORDER BY CAST(CreationDate as Date) DESC

Enter Parameters

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