0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @Question tinyint = 1;
DECLARE @Answer tinyint = 2;
DECLARE @FirstPostReview tinyint = 4;
DECLARE @Invalid tinyint = 3;
DECLARE @Completed tinyint = 2;


SELECT 'site://posts/' + CAST(PostId AS nvarchar) + '/timeline|' + p.Title as [TimeLine Link]
FROM ReviewTasks r
JOIN Posts p ON r.PostId = p.Id
  WHERE
  p.PostTypeId = @Question
   AND
  r.ReviewTaskTypeId = @FirstPostReview
  AND
  r.ReviewTaskStateId = @Completed
  AND
  YEAR(r.CreationDate) = 2021

ORDER BY r.DeletionDate DESC;

fork query

edited sep 4

created sep 4 NotTheDr01ds