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 (7022,7023) 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 470 for home > books > sports & recreation > Coming Soon
| Tue 8 Jul 2008 |
|
Book - Hardcover
|
SAINT SING, SUSAN /
WONDER CREW
|
$36.25
|
|
| Mon 14 Jul 2008 |
|
Book - Paperback
|
LYNCH, C /
RESEARCHING SPORT & EXERCISE
|
$51.02
|
|
| Tue 15 Jul 2008 |
|
Book - Hardcover
|
UNKNOWN /
PSYCHOLOGY OF MOTORSPORT SUCCESS
|
$53.89
|
|
|
Book - Paperback
|
CALZAGHE, JOE /
NO ORDINARY JOE
|
$23.34
|
|
|
|
FOX, CATHERINE /
FIGHT THE GOOD FIGHT
|
$26.15
|
|
|
|
HAY, PHIL /
LEEDS UNITED
|
$32.69
|
|
|
|
HOFFMAN, JAY / VAZQUEZ, JOSE /
TOTAL FITNESS FOR BASEBALL
|
$31.20
|
|
|
|
HONIGSTEIN, RAPHAEL /
HARDER, BETTER, FASTER, STRONGER
|
$42.04
|
|
|
|
MOLLER, LORRAINE /
ON THE WINGS OF MERCURY: THE LORRAINE MOLLER STORY
|
$46.72
|
|
|
|
PARISYAN, KARO / KRAUSS, ERICH / CORDOZA, GLEN /
JUDO FOR MIXED MARTIAL ARTS
|
$47.60
|
|
|
|
PRETTYMAN, BRETT /
FISHING UTAH (2)
|
$27.41
|
|
|
|
REYES, STEVE /
FUEL ALTEREDS FOREVER
|
$34.99
|
|
|
|
SMITH, AIDAN /
UNION JOCK
|
$42.08
|
|
|
|
SUINO, NICKLAUS /
ART OF JAPANESE SWORDSMANSHIP
|
$34.99
|
|
|
|
UNKNOWN /
HOW TO BUILD MOTORCYCLE-ENGINED RACING CARS
|
$66.52
|
|
| Sun 20 Jul 2008 |
|
Book - Hardcover
|
RICKARDS, BARRIE / BAILY, TIM /
NILE PERCH
|
$66.52
|
|
|
Book - Paperback
|
ADLER, RICHARD /
MACK, MCGRAW & THE 1913 BASEBALL SEASON
|
$75.81
|
|
|
|
ZARDETTO, RAY /
30
|
$75.81
|
|
| Tue 22 Jul 2008 |
|
Book - Hardcover
|
DEMPSEY, LUKE /
A SUPREMELY BAD IDEA
|
$35.02
|
|
|
|
JONES, ADAM /
ROSE BOWL DREAMS
|
$34.99
|
|
|
Book - Paperback
|
AMERICAN SPORT EDUCATION PROGRAM /
COACHING YOUTH CHEERLEADING
|
$24.89
|
|
|
|
NFL /
NFL RECORD & FACT BOOK 2008
|
$26.15
|
|
| Sun 27 Jul 2008 |
|
Book - Paperback
|
NEW YORK POST /
ELI MANNING & THE BIG BLUE
|
$22.36
|
|
| Mon 28 Jul 2008 |
|
Book - Hardcover
|
O'TOOLE, ANDREW /
PAUL BROWN
|
$33.79
|
|
| Tue 29 Jul 2008 |
|
Book - Hardcover
|
BOLLETTIERI, NICK /
BOLLISTIC BACKHAND (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
BUILDING POINTS & TACTICS (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
COMPETITIVE CLUB DOUBLES (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
DEADLY DROP SHOTS & LOBS (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
KILLER FOREHAND (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
PRACTICE DRILLS WITH A PURPOSE (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
RIGHT BACK ATCHA RETURNS (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
SHOT SELECTION & COURT POSITIONING (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
SONIC SERVE (DVD)
|
$34.99
|
|
|
|
BOLLETTIERI, NICK /
TENACIOUS NET PLAY (DVD)
|
$34.99
|
|
|
Book - Paperback
|
HARTMAN MUSIKER, LIZ /
SMART GIRL'S GUIDE TO SPORTS
|
$22.44
|
|
|
|
WINNER, DAVID /
BRILLIANT ORANGE
|
$22.36
|
|
| Wed 30 Jul 2008 |
|
Book - Hardcover
|
ARDITO, STEFANO /
MONT BLANC
|
$28.72
|
|
|
|
VELDENN, LEE VANDER / HUMPHREY, JAMES H. /
PSYCHOLOGY & SOCIOLOGY OF SPORT
|
$80.97
|
|
|
Book - Paperback
|
ANSELL, M /
PERSONAL TRAINING
|
$51.02
|
|
| Thu 31 Jul 2008 |
|
Book - Hardcover
|
ALPENFELS, ERIC /
INSTINCT PUTTING
|
$31.89
|
|
cart
