Longest time between edit suggestion and approval

1

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT TOP(##num##)
Id AS [Suggested Edit Link],
PostId AS [Post Link],
OwnerUserId AS [User Link],
CreationDate, ApprovalDate,
DATEDIFF(month, CreationDate, ApprovalDate) AS Months,
DATEDIFF(day, CreationDate, ApprovalDate) AS Days,
DATEDIFF(hour, CreationDate, ApprovalDate) AS Hours,
DATEDIFF(minute, CreationDate, ApprovalDate) AS Minutes
FROM SuggestedEdits
WHERE (ApprovalDate IS NOT NULL)
ORDER BY DATEDIFF(minute, CreationDate, ApprovalDate) DESC

Enter Parameters

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