Recent First Posts reviews

2

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select top ##number?200##
  'site://review/first-posts/'
  +cast(ReviewTasks.Id as varchar)
  +'|'+
  case 
    when posts.ParentId is not null then parents.Title
    else posts.Title
  end
  as 'Review link',
  ReviewTaskStates.Name as 'Status'
from ReviewTasks
join Posts posts on posts.Id = ReviewTasks.PostId
left join Posts parents on posts.ParentId = parents.Id
join ReviewTaskStates on ReviewTaskStates.Id = ReviewTasks.ReviewTaskStateId
where ReviewTasks.ReviewTaskTypeId = 4 -- First Posts
order by ReviewTasks.CreationDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results