1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT TOP(##num?100##)
post = 'site://q/'+CAST(se.PostId AS varchar),
url = 'site://suggested-edits/'+CAST(se.Id AS varchar),
p.DeletionDate,
se.CreationDate,
CASE
  WHEN se.ApprovalDate IS NOT NULL THEN 'Approved'
  WHEN se.RejectionDate IS NOT NULL THEN 'Rejected'
END,
se.OwnerUserId AS [User Link],
se.Comment, se.ApprovalDate, se.RejectionDate
FROM SuggestedEdits se INNER JOIN PostsWithDeleted p ON p.Id=se.PostId
WHERE (p.DeletionDate IS NOT NULL)
ORDER BY se.Id DESC

fork query

edited nov 25

created nov 25 Martin20528