0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of poker

--Get the list of reputations
WITH ReputationsList AS (
SELECT 
    (SELECT Reputation FROM Users WHERE Id=OwnerUserId)
AS
    Rep
FROM 
    Posts 
WHERE 
    (ViewCount>##viewsThreshold##)
)    
    
SELECT 
ReputationsList.Rep,1
FROM 
ReputationsList
ORDER BY
    ReputationsList.Rep
DESC

fork query

edited dec 8 13

created dec 8 13 anonymous