A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.book_id join author a on a.author_id=author_book.author_id ' at line 2

select count(DISTINCT book.book_id) as jumlah FROM book join book.book_id=author_book.book_id join author a on a.author_id=author_book.author_id join prodi p on a.kode_prodi=p.kode_prodi where a.author_id='53604' and title like '%%'and tahun >= YEAR(DATE_SUB(CURDATE(), INTERVAL 3 YEAR))

Filename: controllers/Authors.php

Line Number: 2275