Open Community Wiki Questions with the most Answers and Favorites

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

SELECT top 100 P.Title, 'http://stackoverflow.com/questions/' + CAST(P.Id AS nvarchar), 
P.score as Score,
  P.FavoriteCount as Favorites,
  P.ViewCount as [Views]
FROM Posts P
WHERE 
P.CommunityOwnedDate IS NOT NULL
ORDER BY Score desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results