SELECT TOP 200 CASE WHEN PostTypeId = 1 THEN 'https://met...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT TOP 200
  CASE
    WHEN PostTypeId = 1 THEN 'https://meta.stackexchange.com/q/' + LTRIM(RTRIM(STR(Id)))
    WHEN PostTypeId = 2 THEN 'https://meta.stackexchange.com/a/' + LTRIM(RTRIM(STR(Id)))
    ELSE 'https://meta.stackexchange.com/posts/' + LTRIM(RTRIM(STR(Id))) + '/revisions'
  END Link,
  *
FROM
  PostsWithDeleted
WHERE
  DeletionDate IS NOT NULL
ORDER BY
  Score ASC

Enter Parameters

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