SELECT Product.ProductID FROM Additional WITH (NOLOCK) INNER JOIN PartnerProduct WITH (NOLOCK) ON Additional.ProductID = PartnerProduct.ProductID AND PartnerProduct.PartnerID = 2 AND PartnerProduct.Active = CONVERT(bit, 1) INNER JOIN Product WITH (NOLOCK) ON Additional.ProductID = Product.ProductID AND Product.Active = CONVERT(bit, 1) AND (Product.Deleted = CONVERT(bit, 0) OR (Product.Deleted = CONVERT(bit, 1) AND Product.SOH > 0)) INNER JOIN MenuProduct WITH (NOLOCK) ON Additional.ProductID = MenuProduct.ProductID AND MenuProduct.MenuID IN (4162,4163,4164,4165,4166,4167) INNER JOIN Artist WITH (NOLOCK) ON Product.ArtistID = Artist.ArtistID INNER JOIN PartnerGenre WITH (NOLOCK) ON Product.GenreID = PartnerGenre.GenreID AND PartnerGenre.PartnerID = 2 INNER JOIN PartnerFormat WITH (NOLOCK) ON Product.FormatID = PartnerFormat.FormatID AND PartnerFormat.PartnerID = 2 INNER JOIN Format WITH (NOLOCK) ON Product.FormatID = Format.FormatID LEFT OUTER JOIN Supplier WITH (NOLOCK) ON Product.SupplierID = Supplier.SupplierID LEFT OUTER JOIN CampaignView Campaign ON Additional.ProductID = Campaign.ProductID LEFT OUTER JOIN PartnerCampaign ON Campaign.CampaignID = PartnerCampaign.CampaignID AND PartnerCampaign.PartnerID = 2 WHERE ((CASE WHEN Campaign.DateStart >= GETDATE() THEN Campaign.DateStart ELSE dbo.fn_AdjustReleaseDate(Additional.ReleaseDate) END) BETWEEN CONVERT(datetime, '12/05/2008 00:00:00', 103) AND CONVERT(datetime, '12/05/2009 23:59:59', 103)) AND (dbo.fn_InStockOnly(ISNULL(Supplier.InStockOnly, 0), ISNULL(Supplier.InStockOnlyPreRelease, 0), Product.SOH, dbo.fn_AdjustReleaseDate(Additional.ReleaseDate), GETDATE()) = CONVERT(bit, 1)) ORDER BY (CASE WHEN Campaign.DateStart >= GETDATE() THEN Campaign.DateStart ELSE dbo.fn_AdjustReleaseDate(Additional.ReleaseDate) END), Format.Format, Artist.Artist, Product.Title
Results 1-40 of 417 for home > music > jazz & blues > Coming Soon
| Mon 12 May 2008 |
|
2 CD
|
STARR, KAY /
ON THE RADIO
|
$24.10
|
|
|
|
VARIOUS /
DERBY RECORDS STORY
|
$24.10
|
|
|
CD Album
|
HUMES, HELEN /
TODAY I SING THE BLUES
|
$19.27
|
|
|
|
MEMPHIS SLIM /
MEMPHIS SLIM USA 1961
|
$19.27
|
|
|
|
MENDES, SERGIO /
ENCANTO (US IMPORT)
|
$27.94
|
|
|
|
SPIVEY, ANGELA /
LIVE WITH THE VOICES OF VICTORY
|
$24.10
|
|
| Wed 14 May 2008 |
|
2 CD
|
NASCIMENTO, MILTON /
CLUBE DA ESQUINA 1 & 2 (JAPANESE IMPORT)
|
$87.70
|
|
|
|
VARIOUS /
TRUTH (JAPANESE IMPORT)
|
$36.62
|
|
|
CD Album
|
ABAIR, MINDI /
STARS (JAPANESE IMPORT)
|
$45.35
|
|
|
|
ABREU, FERNANDA /
MEMORIAS, CRONICAS, E DECLARACOES DE (JAPANESE IMPORT)
|
$47.18
|
|
|
|
CELTIC LEGEND /
LYONESSE (JAPANESE IMPORT)
|
$36.58
|
|
|
|
DJAVAN /
LIVE AT KNEBWORTH 1980 (LIMITED EDITION) (JAPANESE IMPORT)
|
$45.43
|
|
|
|
HAMILTON, SCOTT /
ACROSS THE TRACKS (JAPANESE IMPORT)
|
$45.35
|
|
|
|
HARGROVE, ROY /
EARFOOD (JAPANESE IMPORT)
|
$45.35
|
|
|
|
JOYCE /
ELECTRIC LADYLAND (LIMITED EDITION) (JAPANESE IMPORT)
|
$45.43
|
|
|
|
MATSUNAGA, TAKESHI /
BEST ALBUM (JAPANESE IMPORT)
|
$50.71
|
|
|
|
MATSUNAGA, TAKESHI /
X (JAPANESE IMPORT)
|
$50.71
|
|
|
|
MONTE, MARISA /
MUSIC FOR MONTSERRAT (LIMITED EDITION) (JAPANESE IMPORT)
|
$34.85
|
|
|
|
NASCIMENTO, MILTON /
AURA JAZZ (JAPANESE IMPORT)
|
$34.85
|
|
|
|
QUARTETO SAMBACANA /
ENDLESS HARMONY (LIMITED EDITION) (JAPANESE IMPORT)
|
$45.43
|
|
|
|
RAPHAEL /
CROSSROADS (LIMITED EDITION) (JAPANESE IMPORT)
|
$45.43
|
|
|
|
RICCIARDI, ALICE /
THERE CAME A LION (JAPANESE IMPORT)
|
$45.43
|
|
|
|
TERAI, NAOKO /
TONINHO HORTA (JAPANESE IMPORT)
|
$50.71
|
|
|
|
VALLE, MARCOS /
APOSTROPHE(')(& THE MOTHERS) (LIMITED EDITION) (JAPANESE IMPORT)
|
$47.18
|
|
|
|
VALLE, MARCOS /
ONE SIZE FITS ALL (JAPANESE IMPORT)
|
$47.18
|
|
|
|
VARIOUS /
ONE NIGHT ONLY (LIMITED EDITION) (JAPANESE IMPORT)
|
$47.18
|
|
|
|
VARIOUS /
WHO'S NEXT (LIMITED EDITION) (JAPANESE IMPORT)
|
$45.43
|
|
|
|
YELLOWJACKETS /
LIFECYCLE(FEAT.MIKE STERN) (JAPANESE IMPORT)
|
$45.35
|
|
| Sat 17 May 2008 |
|
2 CD
|
BAKER, CHET /
ONE NIGHT IN TOKYO
|
$25.61
|
|
| Mon 19 May 2008 |
|
CD Album
|
GARDOT, MELODY /
WORRISOME HEART
|
$18.00
|
|
|
|
KING, B.B. /
SINGIN' THE BLUES
|
$5.85
|
|
|
|
LANG, JEFF /
HALF SEAS OVER (DIGIPAK)
|
$27.23
|
|
| Wed 21 May 2008 |
|
2 CD
|
FRIED PRIDE /
BEST (JAPANESE IMPORT)
|
$59.54
|
|
|
|
MARLEY, BOB /
BEST OF THE EARLY SINGLES - JAPANESE (JAPANESE IMPORT)
|
$50.77
|
|
|
6 CD
|
VARIOUS /
RCA JAZZ! 100 (JAPANESE IMPORT)
|
$57.79
|
|
|
CD Album
|
ADDERLEY, CANNONBALL /
SOME LIKE IT HOT (LIMITED EDITION) (JAPANESE IMPORT)
|
$22.52
|
|
|
|
ADDERLEY, NAT /
JUST US (LIMITED EDITION) (JAPANESE IMPORT)
|
$22.52
|
|
|
|
ALEXANDER, MONTY /
TASTE OF FREEDOM (JAPANESE IMPORT)
|
$41.91
|
|
|
|
ALLEN, STEVE /
COOL QUIET BOSSA NOVA (JAPANESE IMPORT)
|
$41.91
|
|
|
|
AMMONS, GENE /
HEADING NORTHE (JAPANESE IMPORT)
|
$22.52
|
|
cart
