Index: trunk/admin/users/adduser_groups.php
===================================================================
diff -u -r2853 -r3668
--- trunk/admin/users/adduser_groups.php	(.../adduser_groups.php)	(revision 2853)
+++ trunk/admin/users/adduser_groups.php	(.../adduser_groups.php)	(revision 3668)
@@ -189,10 +189,12 @@
 $orderBy = trim($objConfig->Get($SortFieldVar)." ".$order);
 
 $phrase_never = language('la_NeverExpires');
-if(strlen($orderBy))
-    $orderBy = " ORDER BY ".$orderBy;
+if ($orderBy) {
+	$orderBy = ' ORDER BY '.$orderBy;
+}
+
 $sql = "SELECT g.GroupId as GroupId, g.name as GroupName, count(u.PortalUserId) as UserCount, IF(MembershipExpires IS NOT NULL, DATE_FORMAT( FROM_UNIXTIME(MembershipExpires) ,'%m/%d/%y %h:%i:%s %p'), '".$phrase_never."') AS MembershipExpires FROM ".GetTablePrefix()."PortalGroup as g ";
-$sql .="INNER JOIN ".$objSession->GetEditTable("UserGroup")." as u ON g.GroupId=u.GroupId WHERE u.PortalUserId=".$c->Get("PortalUserId")." $where GROUP BY g.name".$orderBy;
+$sql .="INNER JOIN ".$objSession->GetEditTable("UserGroup")." as u ON g.GroupId=u.GroupId WHERE (u.PortalUserId=".$c->Get("PortalUserId").") AND (g.Personal = 0) $where GROUP BY g.name".$orderBy;
 
 if($objSession->HasSystemPermission("DEBUG.LIST"))
    echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";