Listing of Stackoverflow Posts that are closed as Off Topic

This query lets you query for Stackoverflow posts that are closed as off topic, and filtered by how much activity they have:

SELECT
  score, 
  concat('http://stackoverflow.com/questions/', p.Id), 
  title
FROM Posts p
JOIN PostHistory ph ON p.Id = ph.PostId
WHERE p.PostTypeId = 1 
  AND p.ClosedDate IS NOT NULL 
  AND ph.PostHistoryTypeId = 10 
  AND (
    comment = 102
  ) 
  AND p.Score > 5
  AND ViewCount > 1000
ORDER BY p.FavoriteCount DESC

Leave a Reply

Your email address will not be published. Required fields are marked *