Debug info: SQLState: 42000<br>Error Code: 169<br>Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.<br>

SELECT TOP 10 u.id AS userid,u.firstname,u.lastname,u.picture,u.imagealt,u.email,s.title AS submissiontitle, s.grade AS submissiongrade, ag.gradinggradeFROM mdl_user uLEFT JOIN mdl_workshop_submissions s ON (s.authorid = u.id AND s.workshopid = '1' AND s.example = 0)LEFT JOIN mdl_workshop_aggregations ag ON (ag.userid = u.id AND ag.workshopid = '1')WHERE u.id IN ('335','180','468','251','196','374','113','121','192','153','222','229','201','227','465','193','126','164','224','163','385','2')ORDER BY lastname ASC,u.lastname,u.firstname,u.id[array (0 => '1',1 => '1',2 => 335,3 => 180,4 => 468,5 => 251,6 => 196,7 => 374,8 => 113,9 => 121,10 => 192,11 => 153,12 => 222,13 => 229,14 => 201,15 => 227,16 => 465,17 => 193,18 => 126,19 => 164,20 => 224,21 => 163,22 => 385,23 => 2,)]Stack trace:line 391 of \lib\dml\moodle_database.php: dml_read_exception thrownline 252 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()line 368 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()line 773 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()line 807 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()line 1342 of \mod\workshop\locallib.php: call to sqlsrv_native_moodle_database->get_records_sql()line 355 of \mod\workshop\view.php: call to workshop->prepare_grading_report_data()