Q&A for SharePoint enthusiasts
-- WITH SuggEds AS ( SELECT se.OwnerUserId as [User Link], p.Id as [Post Link], p.PostTypeId, se.*, p.* FROM SuggestedEdits se LEFT JOIN Posts p ON p.Id = se.PostId WHERE se.ApprovalDate IS NULL AND se.RejectionDate IS NULL AND p.PostTypeId <> 5 -- )