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