SELECT u.id,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email, COALESCE(ul.timeaccess, 0) AS lastaccess, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM b1user u
        LEFT JOIN b1user_lastaccess ul ON (ul.userid = u.id AND ul.courseid = :o_courseid2)
        JOIN b1user_enrolments ue ON ue.userid = u.id
        JOIN b1enrol e ON e.id = ue.enrolid
                                              AND e.courseid = :o_courseid1
        LEFT JOIN b1context ctx ON (ctx.instanceid = u.id AND ctx.contextlevel = :o_contextlevel)   GROUP BY u.id, ul.timeaccess, ctx.id ORDER BY lastname ASC