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
| 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
|

|