Index: trunk/admin/users/user_groups.php
===================================================================
diff -u -r605 -r628
--- trunk/admin/users/user_groups.php	(.../user_groups.php)	(revision 605)
+++ trunk/admin/users/user_groups.php	(.../user_groups.php)	(revision 628)
@@ -208,9 +208,10 @@
 if(strlen($orderBy))
     $orderBy = " ORDER BY ".$orderBy;
 $prefix = GetTablePrefix();
-$sql = "SELECT g.GroupId as GroupId, g.name as GroupName,g.name as name, count(u.PortalUserId) as UserCount
-		FROM ".$prefix."PortalGroup as g, ".$prefix.'UserGroup u
-		WHERE g.GroupId=u.GroupId AND '.$where.'GROUP BY g.name'.$orderBy;;
+$sql = 'SELECT g.GroupId AS GroupId, g.name AS GroupName, g.name AS name, count(u.PortalUserId) AS UserCount
+		FROM '.$prefix.'PortalGroup AS g
+		LEFT JOIN '.$prefix.'UserGroup u ON u.GroupId = g.GroupId
+		WHERE '.$where.'GROUP BY g.name'.$orderBy;
 
 if($objSession->HasSystemPermission("DEBUG.LIST"))
    echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";