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 (6883,6884,6885,6886,6887,6888,6889,6890,6891,6892) 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, '7/07/2008 00:00:00', 103) AND CONVERT(datetime, '7/07/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 4340 for home > books > childrens > Coming Soon

Page 1 2 3 4 5 6 7 8 9 10 11 of 109

Next »

Show Format: All

Mon 7 Jul 2008
Book - Paperback	ARBUTHNOTT, GILL / MAD SCIENTISTS	$16.03
	BEARDSLEY, MARTYN / SMUGGLER!	$16.03
	BRADMAN, TONY / HARALD HARDNUT	$16.03
	DEARY, TERRY / VAMPIRE OF CROGLIN GRANGE	$16.03
	FISHER, CATHERINE / PICKPOCKET'S GHOST	$16.03
	GIBBONS, ALAN / NUMBER SEVEN SHIRT	$16.03
	GROSSBLATT, BEN / ANIMAL CHALLENGE (SPI)	$28.72
	GROSSBLATT, BEN / BECK, PAUL / FACE OFF AIR HOCKEY	$28.72
	IVERSON, MARY / HORSE DRAWING STUDIO	$35.02
	LANDMAN, TANYA / TWO WORDS	$16.03
	LAWRENCE, MICHAEL / YOUNG WIZARDS	$14.12
	MCKAY, HILARY / AMAZING!	$14.12
	NAIDOO, BEVERLEY / CALL OF THE DEEP	$16.03
	POWLING, CHRIS / FLINT	$16.03
	UPDALE, ELEANOR / SAVED	$16.03
Tue 8 Jul 2008
Book - Audio CD	COLFER, EOIN / ARTEMIS FOWL 6 (UNABRIDGED)	$42.99
	LANG, LANG / LANG LANG (UNABRIDGED)	$33.31
	SENGE, PETER / POWER OF PRESENCE	$25.22
Book - Hardcover	BURNINGHAM, JOHN / JOHN PATRICK NORMAN MCHENNESSY (REPRINT)	$24.93
	CALLERY, SEAN / I WONDER WHY THERE'S A HOLE IN THE SKY	$19.84
	COLLINS, YVONNE / RIDEOUT, SANDY / GIRL V. BOY	$23.67
	DICAMILLO, KATE / MERCY WATSON THINKS LIKE A PIG	$19.90
	ELLIS, GWEN / OUR TOGETHER-TIME BIBLE	$19.90
	ENDERLE, DOTTI / MAN IN THE MOON	$22.41
	FRENCH, VIVIAN / ROBE OF SKULLS	$22.41
	GARLICK, MARK A. / ATLAS OF THE UNIVERSE	$28.72
	GOLDEN BOOKS PUBLISHING COMPANY / LYLE THE KINDLY VIKING (BRDBK)	$9.80
	HERSHEY, MARY / 10 LUCKY THINGS THAT HAVE HAPPENED TO ME SINCE I NEARLY GOT HIT BY LIGHTNING	$23.67
	JOCELYN, MARTHE / WOULD YOU	$23.67
	KATCHER, BRIAN / PLAYING WITH MATCHES	$23.67
	KOVAKS, TOMMY / WONDERLAND	$28.72
	LAWRENCE, IAIN / SEANCE	$23.67
	LLEWELLYN, CLAIRE / ASK DR. K. FISHER ABOUT CREEPY-CRAWLIES	$17.31
	MICHELSON, RICHARD / ANIMALS ANONYMOUS	$22.41
	NEUMEIER, RACHEL / CITY IN THE LAKE	$23.67
	PIENKOWSKI, JAN / DINNERTIME (REISSUE)	$12.32
	PIENKOWSKI, JAN / LITTLE MONSTERS (REISSUE)	$12.32
	PRIDDY, ROGER / AT THE ZOO (BRDBK)	$19.84
	PRIDDY, ROGER / COLORS (BRDBK)	$9.76
	PRIDDY, ROGER / HAUNTED HOUSE (BRDBK)	$16.06

Page 1 2 3 4 5 6 7 8 9 10 11 of 109

Next »