are they the most interesting ones?
Q&A about the site for members of the workforce navigating the professional setting
-- top 40 closed questions -- are they the most interesting ones? SELECT top 40 p.favoritecount, p.id, p.id as [Post Link] FROM Posthistory h INNER JOIN PosthistoryTypes t ON h.posthistorytypeid = t.id INNER JOIN Posts p ON h.postid = p.id WHERE t.name = 'Post Closed' GROUP BY p.favoritecount, p.id ORDER BY p.favoritecount DESC