Tag wiki review suggestions data

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
  DATEDIFF(
    DAY,
    SuggestedEdits.CreationDate,
    COALESCE(SuggestedEdits.ApprovalDate, SuggestedEdits.RejectionDate))
    AS DayLength,
  SuggestedEdits.OwnerUserId AS [User Link],
  'site://review/suggested-edits/' + CAST(ReviewTasks.Id AS VARCHAR(MAX))
    + '|Link' AS [Review Link],
  *
FROM SuggestedEdits, Posts, ReviewTasks
WHERE
  ReviewTasks.SuggestedEditId = SuggestedEdits.Id
  AND
  SuggestedEdits.PostId = Posts.Id
  AND
  Posts.PostTypeId BETWEEN 4 AND 5
  AND
  (
    SuggestedEdits.ApprovalDate IS NOT NULL
    OR
    SuggestedEdits.RejectionDate IS NOT NULL
  )
ORDER BY SuggestedEdits.Id DESC;

Enter Parameters

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