Linked ticket with changeset: r5825
Action performed by DavidMJ (Former Team Member) on Apr 22nd 2006, 18:09
- Code: Select all
$sql = 'SELECT g.group_id, g.group_name, g.group_type, COUNT(ug.user_id) AS total_members
FROM ' . GROUPS_TABLE . ' g
LEFT JOIN ' . USER_GROUP_TABLE . ' ug USING (group_id)
GROUP BY g.group_id
ORDER BY g.group_type ASC, g.group_name';