Database Error

Error: SQLSTATE[42000] [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 `Track`.`InstrumentID` = `Instrument`.`Instrument_id`) INNER JOIN `musicfind' at line 1

SQL Query: SELECT `Track`.`TrackID`, `Track`.`Duration`, `Track`.`FileLocation`, `Track`.`TrackTitle`, `Track`.`TempoID`, `cds`.`CDDesc`, (CASE WHEN Track.TempoID=1 THEN "Slow" WHEN Track.TempoID=2 THEN "N/R" WHEN Track.TempoID=6 THEN "Free" WHEN Track.TempoID=3 THEN "Unclassified" WHEN Track.TempoID=4 THEN "Mixed" WHEN Track.TempoID=5 THEN "Medium" ELSE "Fast" END) "Track.TempoID", `Instrument`.`instrument_text`, `Keywords`.`keyword_name` FROM `musicfinder`.`tracks` AS `Track` INNER JOIN `musicfinder`.`track_sub_genres` AS `genres` ON (`Track`.`TrackID` = `genres`.`trackID`) INNER JOIN `musicfinder`.`cds` AS `cds` ON (`Track`.`CDID` = `cds`.`CDID`) INNER JOIN `musicfinder`.`instruments` AS `Instrument` ON (`Instrument`.`language_id` = AND `Track`.`InstrumentID` = `Instrument`.`Instrument_id`) INNER JOIN `musicfinder`.`track_keywords` AS `TKeywords` ON (`Track`.`TrackID` = `TKeywords`.`trackID`) INNER JOIN `musicfinder`.`keywords` AS `Keywords` ON (`Keywords`.`language_id` = AND `Keywords`.`keyword_id` = `TKeywords`.`keywordID`) WHERE `genres`.`subgenreID` =317 AND `cds`.`LibraryID` = 25 GROUP BY `Track`.`TrackID` ORDER BY `Track`.`TrackTitle` ASC

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

(default) 3 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Countries`.`id`, `Countries`.`countryName`, `Countries`.`countryCode`, `Countries`.`language`, `Countries`.`flagUrl` FROM `musicfinder`.`countries` AS `Countries` WHERE `Countries`.`DisplayOnWebsite` = 149491
2SELECT `Library`.`LibraryID`, `Library`.`LibraryName`, `Library`.`Description_TextID`, `Library`.`Duration_TextID`, `Library`.`Sound`, `Library`.`ImageURL`, `Library`.`CAE`, `Library`.`SortOrder`, `Library`.`Created` FROM `musicfinder`.`libraries` AS `Library` WHERE 1 = 1 ORDER BY `Library`.`LibraryName` ASC25251
3SELECT `Countries`.`id`, `Countries`.`countryName`, `Countries`.`countryCode`, `Countries`.`language`, `Countries`.`flagUrl` FROM `musicfinder`.`countries` AS `Countries` WHERE `Countries`.`DisplayOnWebsite` = 149491