Coming Soon

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

  Page 1 2 3 4 5 6 7 8 9 10 11 of 11 Next »
Show Format:
Mon 12 May 2008
2 CD STARR, KAY / ON THE RADIO $24.10 Add To Cart
  VARIOUS / DERBY RECORDS STORY $24.10 Add To Cart
CD Album HUMES, HELEN / TODAY I SING THE BLUES $19.27 Add To Cart
  MEMPHIS SLIM / MEMPHIS SLIM USA 1961 $19.27 Add To Cart
  MENDES, SERGIO / ENCANTO (US IMPORT) $27.94 Add To Cart
Import
  SPIVEY, ANGELA / LIVE WITH THE VOICES OF VICTORY $24.10 Add To Cart
Wed 14 May 2008
2 CD NASCIMENTO, MILTON / CLUBE DA ESQUINA 1 & 2 (JAPANESE IMPORT) $87.70 Add To Cart
Import
  VARIOUS / TRUTH (JAPANESE IMPORT) $36.62 Add To Cart
Import
CD Album ABAIR, MINDI / STARS (JAPANESE IMPORT) $45.35 Add To Cart
Import
  ABREU, FERNANDA / MEMORIAS, CRONICAS, E DECLARACOES DE (JAPANESE IMPORT) $47.18 Add To Cart
Import
  CELTIC LEGEND / LYONESSE (JAPANESE IMPORT) $36.58 Add To Cart
Import
  DJAVAN / LIVE AT KNEBWORTH 1980 (LIMITED EDITION) (JAPANESE IMPORT) $45.43 Add To Cart
Import
  HAMILTON, SCOTT / ACROSS THE TRACKS (JAPANESE IMPORT) $45.35 Add To Cart
Import
  HARGROVE, ROY / EARFOOD (JAPANESE IMPORT) $45.35 Add To Cart
Import
  JOYCE / ELECTRIC LADYLAND (LIMITED EDITION) (JAPANESE IMPORT) $45.43 Add To Cart
Import
  MATSUNAGA, TAKESHI / BEST ALBUM (JAPANESE IMPORT) $50.71 Add To Cart
Import
  MATSUNAGA, TAKESHI / X (JAPANESE IMPORT) $50.71 Add To Cart
Import
  MONTE, MARISA / MUSIC FOR MONTSERRAT (LIMITED EDITION) (JAPANESE IMPORT) $34.85 Add To Cart
Import
  NASCIMENTO, MILTON / AURA JAZZ (JAPANESE IMPORT) $34.85 Add To Cart
Import
  QUARTETO SAMBACANA / ENDLESS HARMONY (LIMITED EDITION) (JAPANESE IMPORT) $45.43 Add To Cart
Import
  RAPHAEL / CROSSROADS (LIMITED EDITION) (JAPANESE IMPORT) $45.43 Add To Cart
Import
  RICCIARDI, ALICE / THERE CAME A LION (JAPANESE IMPORT) $45.43 Add To Cart
Import
  TERAI, NAOKO / TONINHO HORTA (JAPANESE IMPORT) $50.71 Add To Cart
Import
  VALLE, MARCOS / APOSTROPHE(')(& THE MOTHERS) (LIMITED EDITION) (JAPANESE IMPORT) $47.18 Add To Cart
Import
  VALLE, MARCOS / ONE SIZE FITS ALL (JAPANESE IMPORT) $47.18 Add To Cart
Import
  VARIOUS / ONE NIGHT ONLY (LIMITED EDITION) (JAPANESE IMPORT) $47.18 Add To Cart
Import
  VARIOUS / WHO'S NEXT (LIMITED EDITION) (JAPANESE IMPORT) $45.43 Add To Cart
Import
  YELLOWJACKETS / LIFECYCLE(FEAT.MIKE STERN) (JAPANESE IMPORT) $45.35 Add To Cart
Import
Sat 17 May 2008
2 CD BAKER, CHET / ONE NIGHT IN TOKYO $25.61 Add To Cart
Import
Mon 19 May 2008
CD Album GARDOT, MELODY / WORRISOME HEART $18.00 Add To Cart
  KING, B.B. / SINGIN' THE BLUES $5.85 Add To Cart
Import
  LANG, JEFF / HALF SEAS OVER (DIGIPAK) LANG, JEFF / HALF SEAS OVER (DIGIPAK)
$27.23 Add To Cart
Wed 21 May 2008
2 CD FRIED PRIDE / BEST (JAPANESE IMPORT) $59.54 Add To Cart
Import
  MARLEY, BOB / BEST OF THE EARLY SINGLES - JAPANESE (JAPANESE IMPORT) $50.77 Add To Cart
Import
6 CD VARIOUS / RCA JAZZ! 100 (JAPANESE IMPORT) $57.79 Add To Cart
Import
CD Album ADDERLEY, CANNONBALL / SOME LIKE IT HOT (LIMITED EDITION) (JAPANESE IMPORT) $22.52 Add To Cart
Import
  ADDERLEY, NAT / JUST US (LIMITED EDITION) (JAPANESE IMPORT) $22.52 Add To Cart
Import
  ALEXANDER, MONTY / TASTE OF FREEDOM (JAPANESE IMPORT) $41.91 Add To Cart
Import
  ALLEN, STEVE / COOL QUIET BOSSA NOVA (JAPANESE IMPORT) $41.91 Add To Cart
Import
  AMMONS, GENE / HEADING NORTHE (JAPANESE IMPORT) $22.52 Add To Cart
Import
  Page 1 2 3 4 5 6 7 8 9 10 11 of 11 Next »