Index: trunk/admin/category/addcategory_permissions.php =================================================================== diff -u -r2853 -r3668 --- trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 2853) +++ trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 3668) @@ -146,7 +146,7 @@ $objGroupList->Clear(); $sql = "SELECT ResourceId, g.name as Name, ELT(g.Personal+1,'Group ','User ') as UserGroup FROM ".GetTablePrefix()."Permissions as p "; -$sql .="LEFT JOIN ".GetTablePrefix()."PortalGroup as g ON p.GroupId=g.GroupId WHERE p.CatId=".(int)$c->Get("CategoryId")." GROUP BY Name"; +$sql .="LEFT JOIN ".GetTablePrefix()."PortalGroup as g ON p.GroupId=g.GroupId WHERE (p.CatId=".(int)$c->Get("CategoryId").") AND (g.Personal = 0) GROUP BY Name"; //$sql = "SELECT GroupId, count(*) as PermCount FROM ".GetTablePrefix()."Permissions WHERE CatId=".$c->Get("CategoryId")." GROUP BY GroupId"; $objGroupList->Query_Item($sql);