-$sql = "SELECT g.GroupId as GroupId, g.name as GroupName,g.name as name, count(u.PortalUserId) as UserCount FROM ".GetTablePrefix()."PortalGroup as g ";
-$sql .="LEFT JOIN ".GetTablePrefix()."UserGroup as u ON g.GroupId=u.GroupId WHERE $where GROUP BY g.name".$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;;