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 (7042,4155,4156,4157,4159) 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-11 of 11 for home > music > easy listening > Coming Soon

Show Format: All CD CD Single Vinyl/LP's

Mon 12 May 2008
CD Album	CUGAT & HIS ORCHESTRA, XAVIER / LATIN-AMERICAN EXOTICA	$24.10
	SIMON & GARFUNKEL / BEST OF	$9.95
Double DVD Video (PAL)	LANO & WOODLEY / LANO & WOODLEY COLLECTION	$26.21
Mon 19 May 2008
2 CD	GARLAND, JUDY / GET HAPPY	$19.27
Wed 21 May 2008
CD Album	WINSTON, GEORGE / AUTUMN (LIMITED EDITION) (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / DECEMBER (LIMITED EDITION) (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / FOREST (LIMITED EDITION) (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / LINUS & LUCY -MUSIC OF VINCE G (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / PLAINS (LIMITED EDITION) (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / SUMMER (LIMITED EDITION) (JAPANESE IMPORT)	$38.34
	WINSTON, GEORGE / WINTER INTO SPRING (LIMITED EDITION) (JAPANESE IMPORT)	$38.34