All Q's & A's Scored Lower Than [x]

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all questions and answers with a score lower than the provided threshold for the selected SE site. Includes deleted posts. Note that if you don't have the "access moderator tools" privilege on the target site, you won't be able to see the post by following the link.

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

SELECT
  CONCAT('site://q/', p.Id, '|', CASE 
    WHEN p.DeletionDate IS NULL 
    THEN CASE
      WHEN p.PostTypeId = 1
      THEN p.Title
      ELSE parent.Title
      END
    ELSE '[deleted]' 
    END) AS [Link],
  pt.Name AS [Post Type],
  p.Score,
  p.CreationDate
FROM PostsWithDeleted p
JOIN PostTypes pt ON p.PostTypeId = pt.Id
LEFT JOIN Posts parent ON parent.Id = p.ParentId
WHERE p.Score <= ##Score:int?-100##
AND (p.PostTypeId = 1 OR p.PostTypeId = 2)
ORDER BY p.Score ASC

-- Score: Score <=

Enter Parameters

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