0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select top 100 concat('http://stackoverflow.com/review-task/', t.Id, '|', rrr.Name COLLATE DATABASE_DEFAULT)
from ReviewTaskResults r
join ReviewTasks t on t.CompletedByReviewTaskId=r.Id
join ReviewRejectionReasons rrr on rrr.Id=r.RejectionReasonId
order by t.CreationDate desc

fork query

edited aug 20 14

created aug 20 14 anonymous