Finds edit suggestions made and approved after a question was closed to help find the potentially useless.
Q&A for SharePoint enthusiasts
-- (Potentially) useless edit suggestions on closed questions -- Finds edit suggestions made and approved after a question was closed to help find the potentially useless. SELECT se.PostId AS [Post Link], se.Comment, se.ApprovalDate AS [Edit Approval Date], p.ClosedDate AS [Question Closed Date] FROM SuggestedEdits se JOIN Posts p ON se.PostId = p.Id WHERE se.CreationDate > p.ClosedDate AND se.ApprovalDate IS NOT NULL ORDER BY se.ApprovalDate DESC