1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT TOP(##num?500##)
  PostId AS [Post Link],
  COUNT(Id) AS [Count],
  timeline = 'site://posts/' + CAST(PostId AS varchar)+'/timeline',
  revisions = 'site://posts/' + CAST(PostId AS varchar)+'/revisions',
  MAX(CreationDate) 
FROM PostHistory 
WHERE PostHistoryTypeId=50
GROUP BY PostId
ORDER BY COUNT(Id) DESC

view current version

edited mar 1

created aug 18 21 Martin20528