0

Please login or register to vote for this query.

(click on this box to dismiss)

Most popular non-CW questions, presumably what questions are hit the most from Google searches.

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

-- Populist Questions (non-Community Wiki)
-- Most popular non-CW questions, presumably what questions are hit the most from Google searches.

SELECT TOP 100
    p.Id as [Post Link],
    Score as [Votes],
    ViewCount  as [Views]
FROM Posts p
WHERE p.ViewCount > 3000 AND --On Stack Overflow there are 100 non-CW post with more than about XXX.
      p.CommunityOwnedDate is null  -- Field CommunityOwnedDate is absent for non-CW posts.
ORDER BY ViewCount DESC

fork query

created jul 21 10 Peter Mortensen