SELECT Id, (SELECT COUNT(*) FROM Badges b WHERE b.UserId ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT Id,
(SELECT COUNT(*) FROM Badges b WHERE b.UserId = Users.Id) as numBadges
FROM Users
WHERE Reputation = 99
ORDER BY numBadges

Enter Parameters

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