Q&A for professional and enthusiast programmers
declare @dateFilter date set @dateFilter = DATEADD(DAY, -##IgnoreDays?7##, GETDATE()) SELECT p.Id as [Post Link], SUM(p.Score) as Score, SUM(p.CommentCount) as CommentCount, MAX(p.LastActivityDate) as LastActivityDate, pht.Name --p.AcceptedAnswerId --pt.Name FROM Posts p JOIN PostTypes pt ON pt.Id = p.PostTypeId JOIN PostHistory ph ON ph.PostId = p.Id JOIN PostHistoryTypes pht ON pht.Id = ph.PostHistoryTypeId WHERE p.Score >= 0 AND p.ClosedDate IS NULL AND (p.AnswerCount IS NULL OR p.AnswerCount = 0) AND p.CreationDate <= @dateFilter AND p.CommunityOwnedDate IS NULL AND pt.Name = 'Question' AND pht.Name != 'Post Locked' GROUP BY p.Id, pht.Name ORDER BY Score DESC, LastActivityDate ASC