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 (7014,7017,7016,7015) 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 274 for home > books > self-help > Coming Soon

  Page 1 2 3 4 5 6 7 of 7 Next »
Show Format:
Mon 7 Jul 2008
Book - Paperback FIELDS, RICHARD, PH.D. / AWAKENING TO MINDFULLNESS $22.36 Add To Cart
Import
  SANDERSON, STAN / BIG LIE $22.36 Add To Cart
Import
  SIPLE, MOLLY / EATING FOR RECOVERY $26.15 Add To Cart
Import
Wed 9 Jul 2008
Book - Hardcover HOLLAN PUBLISHING, INC. / SENSUAL BATH $26.15 Add To Cart
Import
Thu 10 Jul 2008
Book - Audio CD ALLEN, MARC / GREATEST SECRET OF ALL $22.94 Add To Cart
  HENDRICKS, GAY / FIVE WISHES $22.94 Add To Cart
Book - Paperback ALLEN, MARC / HOW TO THINK LIKE A MILLIONAIRE $18.89 Add To Cart
  EYERS, KERRIE / PARKER, GORDON / MASTERING BIPOLAR DISORDER $23.35 Add To Cart
Tue 15 Jul 2008
Book - Audio CD TRAIG, JENNIFER / WELL ENOUGH ALONE $35.40 Add To Cart
Import
Book - Paperback BRUCE ANDAMP / HAMES / SAVVY! $46.72 Add To Cart
  MOORE, DANTE, SR. / RE-EDUCATION OF THE FEMALE $19.92 Add To Cart
Import
Sun 20 Jul 2008
Book - Paperback SAYRE, KENT / UNSTOPPABLE CONFIDENCE $23.64 Add To Cart
Import
Tue 22 Jul 2008
Book - Audio CD PAUL, RUSSILL / TANTRIC EMBRACE & ECSTATIC HEART (ABRIDGED) $24.67 Add To Cart
Import
Book - Paperback ROCKMORE, ALICIA / WELCH, SARAH / EVERYTHING (ALMOST) IN ITS PLACE $21.11 Add To Cart
Import
Sun 27 Jul 2008
Book - Hardcover NARDINI, SADIE / ROAD TRIP GUIDE TO THE SOUL $32.46 Add To Cart
Import
Mon 28 Jul 2008
Book - Paperback FISHER, MARK / ALLEN, MARK / HOW TO THINK LIKE A MILLIONAIRE (2) $19.84 Add To Cart
Import
Wed 30 Jul 2008
Book - Hardcover HUMPHREY, JAMES H. / HUMAN STRESS $80.97 Add To Cart
Import
Book - Paperback FERRE, WHITNEY / ARTIST WITHIN $31.26 Add To Cart
Import
  RUIZ, DON MIGUEL / FOUR AGREEMENTS (10 ANV) $28.67 Add To Cart
Import
Sun 3 Aug 2008
Book - Audio CD CLOUD, HENRY / ONE-LIFE SOLUTION (ABRIDGED) $35.40 Add To Cart
Import
Book - Hardcover BOOTHMAN, NICHOLAS / HOW TO MAKE PEOPLE LIKE YOU IN 90 SECS $18.85 Add To Cart
  LEMAN, KEVIN / FIRSTBORN ADVANTAGE $28.72 Add To Cart
Import
  LOWE, PETER / SUCCESS & SPIRITUALITY $36.30 Add To Cart
Import
  USBORNE / BABY SCRAPBOOK GIRLS $23.38 Add To Cart
Book - Paperback BRACY, KATE / ARENDT, KATHRYN / COMPLETE IDIOT'S GUIDE TO SEXUAL HEALTH & FITNESS $25.28 Add To Cart
  CORONATO, HELEN / ECO-FRIENDLY FAMILIES $21.52 Add To Cart
  DEACON, CAROLINE / TEACH YOURSELF YOUR TODDLER'S DEVELOPMENT $23.40 Add To Cart
  EDITORS OF CONCEIVE MAGAZINE / FERTILITY FACTS $25.47 Add To Cart
  FRIEDMAN, C / YORIO, K / GIRL'S GUIDE TO KICKING YOUR CAREER INTO GEAR $23.35 Add To Cart
  GOODMAN, KATIE / IMPROVISATION FOR THE SPIRIT $22.36 Add To Cart
Import
  JAMES, URSULA / YOU CAN THINK YOURSELF THIN $30.82 Add To Cart
  JANELLE, LISE, DR. / CONVERSATION WITH THE HEART $22.36 Add To Cart
Import
  KOMPARE, TARA / COLIC CHRONICLES $25.52 Add To Cart
  LAFLEY, A.G. / CHARAN, RAM / GAME CHANGER $32.76 Add To Cart
  LATTA, NIGEL / BEFORE YOUR TEENAGERS DRIVE YOU CRAZY, READ THIS! $26.18 Add To Cart
  LOBO ANTUNES, ANTONIO / WHAT CAN I DO WHEN EVERYTHING'S ON FIRE? $28.67 Add To Cart
Import
  LOCKLEY, ELFREA / THINGS TO DO NOW THAT YOU'RE A MUM $17.78 Add To Cart
  MATTHEWS, UHL ARLENE / COMPLETE IDIOT'S GUIDE TO THE PSYCHOLOGY OF HAPPINESS $28.09 Add To Cart
  MCCLOUD / FORTUNE-TELLING BOOK OF NAMES $14.12 Add To Cart
  MILLER, KAY / TEACH YOURSELF BABY SIGNING & DVD $37.43 Add To Cart
  Page 1 2 3 4 5 6 7 of 7 Next »