Suggested edits with review time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT TOP 1000 pt.Name, p.Id AS [Post Link],
  'site://suggested-edits' + CAST(se.Id AS NVARCHAR) AS 'Suggested edit',
  ROUND(DATEDIFF(SECOND, se.CreationDate, COALESCE(ApprovalDate, RejectionDate)) / 86400., 2)
    AS 'Review time (days)'
  FROM SuggestedEdits AS se
  INNER JOIN Posts AS p
    ON se.PostId = p.Id
  INNER JOIN PostTypes AS pt
    ON p.PostTypeId = pt.Id
  WHERE COALESCE(ApprovalDate, RejectionDate) IS NOT NULL
  ORDER BY COALESCE(ApprovalDate, RejectionDate) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results