Highest Voted Posts (non-Community Wiki)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Non-CW posts with the highest number of votes. If views is zero then it is an answer.

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

-- Highest Voted Posts (non-Community Wiki)
-- Non-CW posts with the highest number of votes. If views is zero then it is an answer.

SELECT TOP 100
    p.Id as [Post Link],
    Score as [Votes],
    ViewCount  as [Views],
    Tags
FROM Posts p
--inner join PostTags t on p.Id = t.PostId
--WHERE --t.TagId = 669 AND
      --p.Score > 20 --AND --On Stack Overflow there are 100 non-CW post with more than about XXX.
      --p.CommunityOwnedDate is null AND  -- Field CommunityOwnedDate is absent for non-CW posts.
      --p.Tags is not null
ORDER BY Score DESC

Enter Parameters

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