275,276c275
<        $groupsqlFrom = ",{$CFG->prefix}groups_members gm";
<        $groupsqlWhere = "AND gm.groupid = $groupid AND u.id = gm.userid";
---
>         $groupsql = "AND gm.groupid = $groupid AND u.id = gm.userid";
278,279c277
<        $groupsqlFrom = "";
<        $groupsqlWhere = "";
---
>         $groupsql = "";
284c282,283
<                                    {$CFG->prefix}user u $groupsqlFrom 
---
>                                    {$CFG->prefix}user u,
>                                    {$CFG->prefix}groups_members gm 
287c286
<                                AND u.id = sa.userid $groupsqlWhere
---
>                                AND u.id = sa.userid $groupsql