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 30
  'site://review/first-posts/'+cast(ReviewTasks.Id as varchar),
  posts.ParentId,
  posts.Id,
  parents.Id,
  case 
    when posts.ParentId is not null then parents.Title
    else posts.Title
  end,
  'site://review/first-posts/'+cast(ReviewTasks.Id as varchar)+
  case 
    when posts.ParentId is not null then parents.Title
    else posts.Title
  end
from ReviewTasks
join Posts posts on posts.Id = ReviewTasks.PostId
left join Posts parents on posts.ParentId = parents.Id
where ReviewTasks.ReviewTaskTypeId = 4 -- First Posts
order by ReviewTasks.CreationDate desc

Enter Parameters

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