SELECT
				id_mhs,
				nim,
				nama as nama_mahasiswa
				, sum( IF (( temu = (1) AND absen = 'Ada' ), 1, 0 )) AS absen1, sum( IF (( temu = (2) AND absen = 'Ada' ), 1, 0 )) AS absen2, sum( IF (( temu = (3) AND absen = 'Ada' ), 1, 0 )) AS absen3, sum( IF (( temu = (4) AND absen = 'Ada' ), 1, 0 )) AS absen4, sum( IF (( temu = (5) AND absen = 'Ada' ), 1, 0 )) AS absen5, sum( IF (( temu = (6) AND absen = 'Ada' ), 1, 0 )) AS absen6, sum( IF (( temu = (7) AND absen = 'Ada' ), 1, 0 )) AS absen7, sum( IF (( temu = (8) AND absen = 'Ada' ), 1, 0 )) AS absen8, sum( IF (( temu = (9) AND absen = 'Ada' ), 1, 0 )) AS absen9, sum( IF (( temu = (10) AND absen = 'Ada' ), 1, 0 )) AS absen10, sum( IF (( temu = (11) AND absen = 'Ada' ), 1, 0 )) AS absen11, sum( IF (( temu = (12) AND absen = 'Ada' ), 1, 0 )) AS absen12, sum( IF (( temu = (13) AND absen = 'Ada' ), 1, 0 )) AS absen13, sum( IF (( temu = (14) AND absen = 'Ada' ), 1, 0 )) AS absen14, sum( IF (( temu = (15) AND absen = 'Ada' ), 1, 0 )) AS absen15, sum( IF (( temu = (16) AND absen = 'Ada' ), 1, 0 )) AS absen16,
				prodi
			
			FROM
				(
				SELECT
					mhs.nim,
					mhs.nama, mhs.prodi, 
				IF
					( InStr( data_pertemuan, id_mhs )> 0, 'Ada', '-' ) AS absen,
					tr.id_mhs, posDHMD,  
					dh.pertemuan_ke AS temu 
				FROM
					( tr_nilai_mhs AS tr INNER JOIN db_mahasiswa AS mhs ON tr.id_mhs = mhs.id )
					LEFT JOIN ( SELECT tr_dhmd.id as posDHMD, id_kelas, pertemuan_ke, data_pertemuan FROM tr_dhmd WHERE id_kelas = 875 ) AS dh ON tr.kelas_id = dh.id_kelas 
				WHERE
					(tr.kelas_id = 875 ) 
				) AS tb_hadir 
			GROUP BY id_mhs, nim, nama