find the reviews for a post

3

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/265648/is-there-a-way-to-find-a-specific-post-in-the-review-queue

Emacs

Q&A for those using, extending or developing Emacs

select r.id, r.creationdate, r.deletiondate,
 rt.Name, rts.name,
 rtrt.name,
 rtr.creationdate
 , re.name
 , rtr.comment
from reviewtasks r
inner join reviewtasktypes rt on rt.id = r.ReviewTaskTypeId
inner join ReviewTaskStates rts on rts.id = r.reviewtaskstateid
inner join ReviewTaskResults rtr on rtr.reviewtaskid = r.id
inner join ReviewTaskResultTypes rtrt on rtrt.id = rtr.ReviewTaskResultTypeId
inner join ReviewRejectionReasons re on re.id = rtr.RejectionReasonid
where r.postid = 24041939

Enter Parameters

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