Longest time between edit suggestion and approval


Please login or register to vote for this query.

(click on this box to dismiss)

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

SELECT TOP(##num?500##)
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

Switch to main site
loading Hold tight while we fetch your results