find the reviews for a post


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for those using, extending or developing Emacs

     , r.postid as [Post Link]
     , r.creationdate
     , r.deletiondate
     , rt.Name as [Type] 
     , as [State]
     , as [Result]
     , rtr.creationdate
     , as [Reject reason]
     , rtr.comment
from reviewtasks r
inner join reviewtasktypes rt on = r.ReviewTaskTypeId
inner join ReviewTaskStates rts on = r.reviewtaskstateid
inner join ReviewTaskResults rtr on rtr.reviewtaskid =
inner join ReviewTaskResultTypes rtrt on = rtr.ReviewTaskResultTypeId
left outer join ReviewRejectionReasons re on = rtr.RejectionReasonid
where r.postid = ##postid##

Enter Parameters

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