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

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

Page 1 2 3 4 5 6 7 of 7

Next »