DECLARE @CloseVote INT = 5; SELECT TOP 1000 * FROM Post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @CloseVote INT = 5;

SELECT TOP 1000
  *

FROM Posts
  INNER JOIN PostFeedback
    ON Posts.Id = PostFeedback.PostId
  INNER JOIN Votes
    ON PostFeedback.VoteTypeId = Votes.VoteTypeId
  INNER JOIN VoteTypes
    ON Votes.VoteTypeId = VoteTypes.Id
WHERE VoteTypes.Id = @CloseVote

Enter Parameters

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