0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created jun 25 mjy