select
  `tahunajaran`.`tahunajaran` AS `tahunajaran`,
  `semester`.`semester` AS `semester`,
  `siswa`.`nis` AS `nis`,
  `siswa`.`nama` AS `siswa`,
  `pelajaran`.`nama` AS `mapel`,
  `dasarpenilaian`.`keterangan` AS `keterangan`,
  `nap`.`nilaiangka` AS `nilaiangka`,
  `nap`.`nilaihuruf` AS `nilaihuruf`,
  `nap`.`komentar` AS `komentar`
from
  (((((((((`nap`
  join `infonap` on ((`nap`.`idinfo` = `infonap`.`replid`)))
  join `aturannhb` on ((`nap`.`idaturan` = `aturannhb`.`replid`)))
  join `pelajaran` on ((`aturannhb`.`idpelajaran` = `pelajaran`.`replid`)))
  join `semester` on ((`infonap`.`idsemester` = `semester`.`replid`)))
  join `kelas` on ((`infonap`.`idkelas` = `kelas`.`replid`)))
  join `tahunajaran` on ((`kelas`.`idtahunajaran` = `tahunajaran`.`replid`)))
  join `jenisujian` on ((`aturannhb`.`idjenisujian` = `jenisujian`.`replid`)))
  join `dasarpenilaian` on ((`aturannhb`.`dasarpenilaian` = `dasarpenilaian`.`dasarpenilaian`)))
  join `siswa` on ((`nap`.`nis` = `siswa`.`nis`)))
where
  ((`siswa`.`nis` like '%') and
  (not ((`nap`.`komentar` like ''))))
order by
  `siswa`.`nis`,
  `infonap`.`idkelas`,
  `infonap`.`idsemester`,
  `pelajaran`.`nama`