Find reviews on post

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

-- postid: id of the post "id found when you share an anwer or the link in the url"
select r.id
     , r.postid as [Post Link]
     , r.creationdate
     , r.deletiondate
     , rt.Name as [Type] 
     , rts.name as [State]
     , rtrt.name as [Result]
     , rtr.creationdate
     , re.name as [Reject reason]
     , rtr.comment
from reviewtasks r
left outer join reviewtasktypes rt on rt.id = r.ReviewTaskTypeId
left outer join ReviewTaskStates rts on rts.id = r.reviewtaskstateid
left outer join ReviewTaskResults rtr on rtr.reviewtaskid = r.id
left outer join ReviewTaskResultTypes rtrt on rtrt.id = rtr.ReviewTaskResultTypeId
left outer join ReviewRejectionReasons re on re.id = rtr.RejectionReasonid
where r.postid = 39365369

Enter Parameters

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