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 (7034) 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, '9/07/2008 00:00:00', 103) AND CONVERT(datetime, '9/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 77 for home > books > true stories > Coming Soon

Page 1 2 of 2

Next »

Show Format: All

Tue 15 Jul 2008
Book	MUTCHNICK / MARTIN / CRIMINOLOGICAL THOUGHT	$56.23
Tue 22 Jul 2008
Book - Paperback	ASBURY, HERBERT / GANGS OF NEW YORK	$23.64
Mon 28 Jul 2008
Book - Hardcover	LINK, MARDI / WHEN EVIL CAME TO GOOD HART	$79.20
Book - Paperback	LINK, MARDI / WHEN EVIL CAME TO GOOD HART	$32.46
Tue 29 Jul 2008
Book - Paperback	DEAN, JOHN / HOUSE OF EVIL	$12.32
	MCGINNISS, JOE / NEVER ENOUGH	$13.57
Wed 30 Jul 2008
Book - Hardcover	BRENNER, MARIE / ON THE BORDER	$31.26
	HARDY, LIZ / RATS & SQUEALERS	$16.10
	KERR, GORDON / PROFESSIONAL KILLERS	$16.10
	PARISSIEN, STEVEN / ASSASSINATED!	$19.90
	WILLIAMS, ANNE / HEAD, VIVIAN / SEX LIES & SCANDALS	$16.10
Book - Paperback	RENNER, JAMES / SERIAL KILLER'S APPRENTICE	$22.36
Thu 31 Jul 2008
Book - Hardcover	FUCHS, MAREK / COLD BLOODED BUSINESS	$34.99
Sun 3 Aug 2008
Book	WHITICKER, ALAN / DEREK PERCY AUSTRALIAN PSYCHO	$23.40
Book - Hardcover	CHRISTY, BRYAN / LIZARD KING	$35.02
	JONES, ISHMAEL / HUMAN FACTOR	$38.76
Book - Paperback	CARLO, PHILIP / GASPIPE: CONFESSIONS OF A MAFIA BOSS	$26.18
	FOLLAIN, JOHN / LAST GODFATHERS	$32.76
	HOLLINGTON, KRIS / CRACK HOUSE	$28.02
	REICHERT, DAVID / CHASING THE DEVIL (REPRINT)	$14.17
	SMITH, CARLTON / BLOOD WILL TELL	$12.11
Mon 4 Aug 2008
Book	BUTCHER, LEE / TO LOVE, HONOR, & KILL	$12.14
	LASSETER, DON / MEET ME FOR MURDER	$12.14
	PENCE, IRENE / BURIED MEMORIES	$12.14
Book - Paperback	BAINBRIDGE, SCOTT / STILL MISSING	$32.78
	BAINBRIDGE, SCOTT / WITHOUT TRACE	$26.22
	MERRINER, JAMES L. / GRAFTERS & GOO GOOS	$28.67
Tue 5 Aug 2008
Book - Audio CD	COWELL, ALAN S. / TERMINAL SPY (ABRIDGED)	$35.40
Book - Hardcover	COWELL, ALAN S. / TERMINAL SPY	$37.50
Book - Paperback	HORNER, MARK / SEPTEMBER SACRIFICE	$12.32
	MINTS, PAULA / CATCH MY MOTHER'S KILLER	$12.32
	RIDDLE, LYN / FIRST WE'LL KILL MY HUSBAND	$12.32
Thu 7 Aug 2008
Book - Paperback	YATES, LEW / O'MAHONEY, BERNARD / WILD THING	$23.64
Tue 12 Aug 2008
Book - Hardcover	HALLWAS, JOHN / DIME NOVEL DESPERADOES	$41.29
Tue 19 Aug 2008
Book - Paperback	OWEN, FRANK / NO SPEED LIMIT	$22.36
Sat 30 Aug 2008
Book - Hardcover	GREIG, CHARLOTTE / ENCYCLOPEDIA OF TRUE CRIME	$19.90
	GREIG, CHARLOTTE / MARLOWE, JOHN / EVIL BEYOND BELIEF	$19.90
	MURRAY, WILLIAM / HOUSES OF DEATH	$19.90
Book - Paperback	NGENELWA, THEMBELANI / DAY I DIED	$29.52
Mon 1 Sep 2008
Book - Audio CD	HOSEY, JOSEPH / FATAL VOWS	$45.10

Page 1 2 of 2

Next »