 Shop by Categories  AccessoriesAmericana/CountryAudiophileBlu-RayBluesBooksCD - AudiophileCD - StandardClassicalDowntempoExotica/Easy ListeningFolkGift VouchersJazzJazz Dance/FusionLeftfield/ExperimentalMerchMetal/AlternativePsychedelia/GarageR&BRap/Hip HopReggae/DubRock And PopRock'n'RollSinglesSoul/FunkSoundtrackTechno/ElectronicaWorld/Fusion
|
SELECT cecatalogue.SaleItem, cecatalogue.StockLevel, cecatalogue.ID, cecatalogue.NearlyNew, cecatalogue.Price, cecatalogue.Artist, cecatalogue.Title, cecatalogue.catalogueNumber, cecatalogue.ReleaseDate, cecatalogue.ConditionText, cecatalogue.FormatText, cecatalogue.LabelText, cecategory.ID AS cecategoryID, (cecategory.Category) AS cecategoryCategory, IF (cecatalogue.ReleaseDate > NOW(), true, false) AS forthcomingRelease FROM cecatalogue LEFT JOIN cecategory ON FIND_IN_SET(cecategory.ID, cecatalogue.Category) WHERE ceorders.DateStamp > DATE_SUB(NOW(), INTERVAL 1 MONTH) AND Available = 'Y' AND cecategory.Category NOT IN ('Accessories') GROUP BY cecatalogue.ID ORDER BY cecatalogue.Artist, cecatalogue.Title, cecatalogue.CatalogueNumber |