All Q's & A's Scored Higher 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 higher than the provided threshold for the selected SE site, including 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.

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

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 DESC

-- Score: Score >=

Enter Parameters

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