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 (6918,7027,7028) 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 927 for home > books > education > Coming Soon
| Wed 9 Jul 2008 |
|
Book - Paperback
|
CROCKETT, MICHELLE D. /
MATHEMATICS & TEACHING
|
$48.20
|
|
| Thu 10 Jul 2008 |
|
Book - Hardcover
|
ARVIDSON, P. SVEN /
TEACHING NONMAJORS
|
$96.59
|
|
|
|
HUNT, LESTER H. /
GRADE INFLATION
|
$116.60
|
|
|
|
ROBBINS, CHRISTOPHER G. /
EXPELLING HOPE
|
$116.60
|
|
|
|
SINGER, ALAN J. /
NEW YORK & SLAVERY
|
$89.63
|
|
|
|
STRONG, SUSAN RUMSEY /
THOUGHT KNOWS NO SEX
|
$125.29
|
|
|
Book - Paperback
|
ARVIDSON, P. SVEN /
TEACHING NONMAJORS
|
$34.75
|
|
|
|
COFFIELD, FRANK / EDWARD, SHEILA / FINLAY, IAN / HODGSON, ANN / SPOURS, KEN /
IMPROVING LEARNING, SKILLS & INCLUSION (1)
|
$76.48
|
|
|
|
KISSNER, EMILY /
FOREST & THE TREES
|
$55.17
|
|
|
|
SINGER, ALAN J. /
NEW YORK & SLAVERY
|
$24.89
|
|
|
|
STRONG, SUSAN RUMSEY /
THOUGHT KNOWS NO SEX
|
$41.70
|
|
| Sat 12 Jul 2008 |
|
Book - Paperback
|
COATES, MAX /
CONSTANT LEADER
|
$90.42
|
|
|
|
PALMER, S /
TEACHING RELIGIOUS EDUCATION
|
$48.20
|
|
| Mon 14 Jul 2008 |
|
Book - Hardcover
|
BARNETT, RONALD /
WISDOM IN THE UNIVERSITY (1)
|
$194.88
|
|
|
|
CHOO, LEE SAI /
INFORMATION COMMUNICATION TECHNOLOGY IN EDUCATION (HAR/DVDR)
|
$87.01
|
|
|
|
FLIPPO, RONA F. /
HANDBOOK OF COLLEGE READING & STUDY STRATEGY RESEARCH
|
$455.80
|
|
|
|
LLOYD, LYLE L. /
ASSISTIVE TECHNOLOGY PRINCIPLES & APPLICATIONS FOR COMMUNICATION DISORDERS & SPECIAL EDUCATION
|
$127.35
|
|
|
Book - Paperback
|
FLIPPO, RONA F. /
HANDBOOK OF COLLEGE READING & STUDY STRATEGY RESEARCH (1)
|
$168.70
|
|
|
|
WALKER, HILARY /
STUDYING FOR YOUR SOCIAL WORK DEGREE
|
$51.02
|
|
| Tue 15 Jul 2008 |
|
Book
|
GREEN /
DIGITAL IMAGING FASHION DESIGN
|
$74.99
|
|
|
Book - Hardcover
|
BREAKSTONE, STEVE / DREIBLATT, MICHAEL / DREIBLATT, KAREN /
HOW TO STOP BULLYING & SOCIAL AGGRESSION
|
$119.98
|
|
|
|
MCEWAN, ELAINE K. /
TEN TRAITS OF HIGHLY EFFECTIVE SCHOOLS
|
$130.42
|
|
|
|
MCNEAL, WILLIAM R. / OXHOLM, THOMAS B. /
A SCHOOL DISTRICT'S JOURNEY TO EXCELLENCE
|
$113.03
|
|
|
|
NAVAN, JOY /
NURTURING THE GIFTED FEMALE
|
$106.06
|
|
|
|
RICHARDSON, WILL /
BLOGS, WIKIS, PODCASTS, & OTHER POWERFUL WEB TOOLS FOR CLASSROOMS (2)
|
$113.03
|
|
|
|
TILLMAN, LINDA C. /
SAGE HANDBOOK OF AFRICAN AMERICAN EDUCATION
|
$209.98
|
|
|
Book - Paperback
|
BREAKSTONE, STEVE / DREIBLATT, MICHAEL / DREIBLATT, KAREN /
HOW TO STOP BULLYING & SOCIAL AGGRESSION
|
$62.57
|
|
|
|
ENGLISH, /
HANDBOOK OF INTERNATIONAL RESEARCH IN MATHEMATICAL EDUCATION
|
$170.09
|
|
|
|
MCEWAN, ELAINE K. /
TEN TRAITS OF HIGHLY EFFECTIVE SCHOOLS
|
$62.57
|
|
|
|
MCNEAL, WILLIAM R. / OXHOLM, THOMAS B. /
A SCHOOL DISTRICT'S JOURNEY TO EXCELLENCE
|
$53.88
|
|
|
|
NAVAN, JOY /
NURTURING THE GIFTED FEMALE
|
$50.40
|
|
|
|
PARSONS, RICHARD D. /
A GUIDE TO THINKING & ACTING LIKE AN EXPERT (1)
|
$71.36
|
|
|
|
RICHARDSON, WILL /
BLOGS, WIKIS, PODCASTS, & OTHER POWERFUL WEB TOOLS FOR CLASSROOMS (2)
|
$53.88
|
|
| Wed 16 Jul 2008 |
|
Book - Paperback
|
BERGER, LARRY /
UP YOUR SCORE
|
$18.59
|
|
|
|
GOODLIFF, GILL / TRODD, LYN /
SUCCESS IN YOUR ASSESSMENT
|
$79.83
|
|
|
|
NEWTON, DOUGLAS, P /
A PRACTICAL GUIDE TO TEACHING SCIENCE IN THE SECONDARY SCHOOL (1)
|
$77.77
|
|
| Thu 17 Jul 2008 |
|
Book - Paperback
|
BROWN, KEITH / RUTTER, LYNNE /
CRITICAL THINKING FOR SOCIAL WORK (2)
|
$59.19
|
|
|
|
SCHREFER, ELIOT /
HACK THE SAT
|
$22.44
|
|
| Sat 19 Jul 2008 |
|
Book - Hardcover
|
MCCULLOCH, GARY /
ROUTLEDGE INTERNATIONAL ENCYCLOPEDIA OF EDUCATION (1)
|
$519.94
|
|
| Sun 20 Jul 2008 |
|
Book - Hardcover
|
GOODWIN, PRUE /
UNDERSTANDING CHILDREN'S BOOKS
|
$175.73
|
|
cart
