A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by B.judul, B.pengarang_new ) AND (tahun >=2000 AND is_visible='Y' at line 8

select * from buku_fix where kode_buku in ( select max(B.kode_buku) from buku_fix as B where group by B.judul, B.pengarang_new ) AND (tahun >=2000 AND is_visible='Y') ORDER BY judul asc

Filename: /var/www/perpustakaan.poltekkes-malang.ac.id/public_html/models/m_buku.php

Line Number: 269