SELECT
elearning_adaptivetest.testname,
elearning_adaptivetest.totalquestions,
elearning_adaptivetest.totaldrops,
FROM_UNIXTIME(elearning_adaptivetest.timestarted),
FROM_UNIXTIME(elearning_adaptivetest.timefinished),
elearning_adaptivetest.lastlevel,
elearning_adaptivetest.startinglevel,
sunrise_user.id,
sunrise_user.firstname,
sunrise_user.lastname
FROM
elearning_adaptivetest
INNER JOIN sunrise_user ON elearning_adaptivetest.userid = sunrise_user.id
ORDER BY
sunrise_user.lastname ASC,
elearning_adaptivetest.timestarted ASC