An Error Was Encountered
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 'AND tbl_album.iAlbumID IN (SELECT MAX(iAlbumID) FROM tbl_album WHERE i' at line 2
SELECT tbl_artist.iArtistID, tbl_artist.vcArtistName, tbl_artist.vcArtistWebsite, tbl_artist.vcArtistVideo, tbl_artist.vcArtistType, tbl_artist.txtArtistBio, tbl_artist.vcArtistPhoto, tbl_genre.vcGenreName, tbl_album.iAlbumID, tbl_album.vcAlbumTitle FROM tbl_artist LEFT JOIN tbl_genre ON tbl_artist.iGenreID = tbl_genre.iGenreID LEFT JOIN tbl_album ON tbl_artist.iArtistID = tbl_album.iArtistID WHERE tbl_artist.iArtistID = AND tbl_album.iAlbumID IN (SELECT MAX(iAlbumID) FROM tbl_album WHERE iArtistID = AND tiAlbumEnabled = 1)