Top Groups

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

Quote:

---

SELECT user_id, group_id, COUNT(*) as amount FROM group_memberships GROUP BY user_id ORDER BY amount DESC LIMIT 3

---

This is my real code.

Quote:

---

Originally Posted by Jiq

@Jeanzinh0 I make

This is my real code.

---

Change 'GROUP BY user_id' to 'GROUP BY group_id'