Questions&Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

SELECT p.ID, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, u.Reputation as UserReputation
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND (p.Score >= 20)
AND (p.ViewCount IS NOT NULL) 
AND (p.AnswerCount IS NOT NULL) 
ORDER BY u.Reputation DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results