SELECT 'site://review/suggested-edits/' + CAST(rt.Id AS N...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 'site://review/suggested-edits/' + CAST(rt.Id AS NVARCHAR)
  FROM SuggestedEdits AS se
  INNER JOIN ReviewTasks AS rt
    ON rt.SuggestedEditId = se.Id
  INNER JOIN ReviewTaskResults AS rtr
    ON rtr.ReviewTaskId = rt.Id
  WHERE se.OwnerUserId = ##UserId:int##
  GROUP BY rt.Id
  HAVING COUNT(*) = 1
  ORDER BY rt.Id DESC

Enter Parameters

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