Uncaught exception: mysql error: [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 '' at line 7] in EXECUTE("SELECT Media.strMedia, Catalogue.strCatalogueNum, ROUND(Catalogue.dblCataloguePrice,2) AS catPrice, Catalogue.dblSalePrice, Releases.dblReleaseDatePrimary, IF(Releases.dblReleaseDatePrimary > CURRENT_DATE, 1, 0) AS boolPreOrder, Catalogue.boolCatalogueItemInStock, Catalogue.boolIsOnSale, Releases.strReleaseTitle,Releases.lngLabel,Releases.lngGenreID, Genres.txtGenre,Releases.lngFormatID,Format.strFormatType,Catalogue.strCatalogueNum,Catalogue.strCatalogueBarcode,Catalogue.BoxNumber,Catalogue.dblDealerPrice
FROM Media
INNER JOIN Catalogue ON Media.lngMediaID = Catalogue.lngMediaID
INNER JOIN Releases ON Catalogue.lngReleaseID = Releases.lngReleaseID
INNER JOIN Genres ON Genres.lngGenreID=Releases.lngGenreID
INNER JOIN Format ON Releases.lngFormatID=Format.lngFormatID
WHERE Releases.boolActive<>-1 AND Catalogue.lngReleaseID=;")
