Index: moodle/mod/lamslesson/lib.php =================================================================== diff -u -r553eab7725b1f63b96ed6123359c14ad2b2c65e6 -rc6f6605de18894e645f9a9cabb994996fdf90924 --- moodle/mod/lamslesson/lib.php (.../lib.php) (revision 553eab7725b1f63b96ed6123359c14ad2b2c65e6) +++ moodle/mod/lamslesson/lib.php (.../lib.php) (revision c6f6605de18894e645f9a9cabb994996fdf90924) @@ -711,7 +711,7 @@ $listofcontexts = '('.$sitecontext->id.')'; // must be site } $sql = "SELECT u.id - FROM {$CFG->prefix}user u INNER JOIN {$CFG->prefix}role_assignments r ON u.id=r.userid + FROM {user} u INNER JOIN {role_assignments} r ON u.id=r.userid WHERE r.contextid IN $listofcontexts OR r.contextid=$context->id AND u.deleted=0 AND u.username!='guest'"; $users = $DB->get_records_sql($sql);