V pluginu po úpravě:SELECT distinct c.id, c.fullname, u.username, u.firstname, u.lastname
FROM prefix_course as c, prefix_role_assignments AS ra, prefix_user AS u, prefix_context AS ct
WHERE c.id = ct.instanceid AND ra.roleid =3 AND ra.userid = u.id AND ct.id = ra.contextid
ORDER BY u.lastname, u.firstname
Zdraví Bohuš Havel
FROM prefix_course as c, prefix_role_assignments AS ra, prefix_user AS u, prefix_context AS ct
WHERE c.id = ct.instanceid AND ra.roleid =3 AND ra.userid = u.id AND ct.id = ra.contextid
ORDER BY u.lastname, u.firstname
Zdraví Bohuš Havel