Hello,
I am willing to make top groups, but there is my problem:
http://i.imgur.com/3OuXLpY.png
While I have one more groups that have 15 members, why on this, 5 members is the top ?
Thanks.
Printable View
Hello,
I am willing to make top groups, but there is my problem:
http://i.imgur.com/3OuXLpY.png
While I have one more groups that have 15 members, why on this, 5 members is the top ?
Thanks.
Try this SQL query
Code:SELECT guild_id, COUNT(*) as amount FROM guilds_members GROUP BY guild_id ORDER BY amount DESC LIMIT 10
@Jeanzinh0 I make
This is my real code.Quote:
SELECT user_id, group_id, COUNT(*) as amount FROM group_memberships GROUP BY user_id ORDER BY amount DESC LIMIT 3