Close history in order of number of voters

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

select
  (len(Text) - len(replace(Text, '"Id"', '***'))) as NumOfVoters,
  PostId as [Post Link],
  CreationDate,
  UserId as [User Link]
from PostHistory
where
  PostHistoryTypeId = (select Id from PostHistoryTypes where Name = 'Post Closed')
order by NumOfVoters, CreationDate desc

Enter Parameters

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