Index: moodle/mod/lamslesson/lib.php =================================================================== diff -u -r585c2e273fb963a8c0299f704499a71298c22b58 -r458edcd7121d8676f627e7f74a06952a54423bf6 --- moodle/mod/lamslesson/lib.php (.../lib.php) (revision 585c2e273fb963a8c0299f704499a71298c22b58) +++ moodle/mod/lamslesson/lib.php (.../lib.php) (revision 458edcd7121d8676f627e7f74a06952a54423bf6) @@ -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);