Longest time between edit suggestion and approval (only posts)

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT TOP(##num##)
s.Id AS [Suggested Edit Link],
s.PostId AS [Post Link],
s.OwnerUserId AS [User Link],
s.CreationDate, s.ApprovalDate,
DATEDIFF(month, s.CreationDate, s.ApprovalDate) AS Months,
DATEDIFF(day, s.CreationDate, s.ApprovalDate) AS Days,
DATEDIFF(hour, s.CreationDate, s.ApprovalDate) AS Hours,
DATEDIFF(minute, s.CreationDate, s.ApprovalDate) AS Minutes
FROM SuggestedEdits s JOIN posts p ON s.PostId=p.Id
WHERE (s.ApprovalDate IS NOT NULL) AND (p.PostTypeId IN (1,2))
ORDER BY DATEDIFF(minute, s.CreationDate, s.ApprovalDate) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results