Top 50 Biggest Favorite Lists

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 post favoriters, so that you can browse all those favorites.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

SELECT TOP 50
    Id AS [User Link],
    (
        SELECT COUNT(*) FROM Votes
        WHERE
            VoteTypeId = 5 AND
            UserId = Users.Id
    ) AS Favorites    
    FROM Users
    ORDER BY Favorites DESC

Enter Parameters

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