BestAttempt

SELECT
    u.firstname as "Имя", u.lastname "Фамилия", u.username as "Логин", u.city as "Город",
    uia.data AS  "Номер аптеки", uia2.data as "Бренд",
    DATE_FORMAT(FROM_UNIXTIME(qas.timecreated), '%Y-%m-%d') as "Дата прохождения",
    DATE_FORMAT(FROM_UNIXTIME(qas.timecreated), '%Y-%m-%d %H:%i') as "Дата и время прохождения",
    qz.sumgrades "Максимальные баллы", qza2.sumgrades as "Набранные баллы",
    gi.gradepass as "Проходной бал", qz.name as "Название теста", (qza.attempt) as "Номер попытки"
  FROM prefix_user  as u
  JOIN prefix_user_info_data as uia ON u.id = uia.userid and uia.fieldid =1
  JOIN prefix_user_info_data as uia2 ON u.id = uia2.userid and uia2.fieldid =3
  JOIN prefix_question_attempt_steps as qas ON u.id = qas.userid
  JOIN prefix_question_attempts as qa ON qas.questionattemptid = qa.id
  JOIN prefix_quiz_attempts as qza ON qza.uniqueid = qa.questionusageid

and qza.sumgrades IN
    (SELECT
    max(qzaS.sumgrades)
      FROM prefix_user  as uS
      JOIN prefix_user_info_data as uiaS ON uS.id = uiaS.userid and uiaS.fieldid =1
      JOIN prefix_user_info_data as uia2S ON uS.id = uia2S.userid and uia2S.fieldid =3
      JOIN prefix_question_attempt_steps as qasS ON uS.id = qasS.userid
      JOIN prefix_question_attempts as qaS ON qasS.questionattemptid = qaS.id
      JOIN prefix_quiz_attempts as qzaS ON qzaS.uniqueid = qaS.questionusageid
      JOIN prefix_quiz as qzS ON qzS.id = qzaS.quiz
      JOIN prefix_grade_items as giS ON giS.itemname =  qzS.name  and giS.id  NOT IN (29)
           WHERE qasS.state LIKE 'grade%' and uS.suspended =0 and uS.id =u.id
      group by uS.lastname, qzS.name
     )

  JOIN prefix_quiz_attempts as qza2 ON qza2.uniqueid = qa.questionusageid

and qas.timecreated IN
    (SELECT
        max(LAST_INSERT_ID(qasS.timecreated))
      FROM prefix_user  as uS
      JOIN prefix_user_info_data as uiaS ON uS.id = uiaS.userid and uiaS.fieldid =1
      JOIN prefix_user_info_data as uia2S ON uS.id = uia2S.userid and uia2S.fieldid =3
      JOIN prefix_question_attempt_steps as qasS ON uS.id = qasS.userid
      JOIN prefix_question_attempts as qaS ON qasS.questionattemptid = qaS.id
      JOIN prefix_quiz_attempts as qzaS ON qzaS.uniqueid = qaS.questionusageid
      JOIN prefix_quiz as qzS ON qzS.id = qzaS.quiz
           WHERE qasS.state LIKE 'grade%' and uS.suspended =0 and uS.id =u.id
      group by uS.lastname, qzS.name, qasS.timecreated
    )

  JOIN prefix_quiz_grades as qzg ON qzg.userid = u.id
  JOIN prefix_quiz as qz ON qz.id = qza.quiz
  JOIN prefix_grade_items as gi ON gi.itemname =  qz.name and gi.id NOT IN (29)
       WHERE qas.state LIKE 'grade%' and u.suspended =0
  group by u.lastname, qz.name, qas.timecreated, qza.attempt  HAVING max(qza.attempt) = qza.attempt
  order by u.lastname, "Дата прохождения