Most popular non-CW questions, presumably which questions are hit the most from Google searches.
Q&A for programmers
-- 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 > 6000 AND --On Stack Overflow there are 100 non-CW post with more than about 28000.
--On Server Fault the view threshold is about 6100.
p.CommunityOwnedDate is null -- Field CommunityOwnedDate is absent for non-CW posts.
ORDER BY ViewCount DESC
Error: looks like you typed in the wrong words - try again