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 (7004,7003) 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 1279 for home > books > religion > Coming Soon
| Mon 7 Jul 2008 |
|
Book - Hardcover
|
MCLAREN, JAMES /
WHY JESUS DIED
|
$252.85
|
|
|
Book - Paperback
|
ADAMS, MARILYN MCCORD /
OPENING TO GOD
|
$24.89
|
|
|
|
BOLLEY, CHRS / BOLLEY, CRIS / WEBSTER, J C /
WHEN EVERY HOUR IS A RUSH HOUR
|
$19.90
|
|
|
|
LONG, THOMAS G. /
TEACHING PREACHING AS A CHRISTIAN PRACTICE
|
$41.29
|
|
|
|
UNKNOWN /
MISSING MINISTRY
|
$34.80
|
|
| Tue 8 Jul 2008 |
|
Book - Hardcover
|
BAYDA, EZRA /
ZEN HEART
|
$31.20
|
|
|
|
DUPLANTIS, JESSE /
EVERYDAY VISIONARY
|
$31.26
|
|
|
|
HART, WILLIAM DAVID /
BLACK RELIGION
|
$133.89
|
|
|
|
KONGTRUL, DZIGAR /
LIGHT COMES THROUGH
|
$31.20
|
|
|
Book - Paperback
|
BOOHER, DIANNA /
ESTHER EFFECT
|
$23.67
|
|
|
|
HERTZBERG, ARTHUR /
JUDAISM (REPRINT)
|
$23.69
|
|
|
|
LAHAYE, TIM F. /
MIND SIEGE (LDG)
|
$18.62
|
|
|
|
MACARTHUR, JOHN /
GOD WHO LOVES
|
$22.41
|
|
|
|
PRINCE, DEREK /
GATEWAY TO GOD'S BLESSING
|
$18.62
|
|
|
|
RIGNEY, JAMES /
WOMEN AS BISHOPS
|
$46.92
|
|
|
|
SAJOO, AMYN B. /
MUSLIM ETHICS
|
$51.35
|
|
|
|
SEAY, CHRIS / CAPES, DAVID / HALL, KELLY /
VOICE OF ROMANS
|
$16.10
|
|
| Thu 10 Jul 2008 |
|
Book - Hardcover
|
ABU-RABI, IBRAHIM M. /
SPIRITUAL DIMENSIONS OF BEDIUZZAMAN SAID NURSI'S RISALE-I-NUR
|
$159.21
|
|
|
|
CHAPPLE, CHRISTOPHER KEY /
YOGA & THE LUMINOUS
|
$133.11
|
|
|
|
DOZEMAN, THOMAS B. /
HOLINESS & MINISTRY
|
$130.71
|
|
|
|
SREE, PADMA /
BUDDHISM IN THE KRISHNA RIVER VALLEY OF ANDHRA
|
$116.60
|
|
|
Book - Paperback
|
ABU-RABI, IBRAHIM M. /
SPIRITUAL DIMENSIONS OF BEDIUZZAMAN SAID NURSI'S RISALE-I-NUR
|
$55.62
|
|
|
|
CHAPPLE, CHRISTOPHER KEY /
YOGA & THE LUMINOUS
|
$31.20
|
|
| Sun 13 Jul 2008 |
|
Book - Hardcover
|
GWYNNE, PAUL /
WORLD RELIGIONS IN PRACTICE
|
$159.98
|
|
|
|
HABERMAS, RONALD T. /
INTRODUCTION TO CHRISTIAN EDUCATION
|
$41.33
|
|
|
Book - Paperback
|
ROUTLEDGE /
TET OFFENSIVE
|
$42.54
|
|
| Mon 14 Jul 2008 |
|
Book - Hardcover
|
HUSSAIN, ASAF /
ISLAMIC CIVILIZATION
|
$148.02
|
|
|
|
MCGUCKIN, JOHN ANTHONY /
ORTHODOX CHURCH
|
$264.36
|
|
|
Book - Paperback
|
ASH, CHRISTOPHER /
BIBLE DELIGHT
|
$19.90
|
|
|
|
HUSSAIN, ASAF /
ISLAMIC CIVILIZATION
|
$74.77
|
|
|
|
JOHNS, LAURENTIA /
TOUCHED BY GOD
|
$28.67
|
|
|
|
MACLEAY, ANGUS /
TEACHING 1 PETER
|
$17.37
|
|
|
|
MIKE SHREVE /
GOD'S PROMISES FOR YOUR CHILDREN
|
$22.41
|
|
|
|
ORTLUND, DANE /
A NEW INNER RELISH
|
$22.41
|
|
|
|
ROSEVEARE, HELEN /
LIVING FELLOWSHIP
|
$17.37
|
|
|
|
ROSEVEARE, HELEN /
LIVING HOLINESS
|
$17.37
|
|
|
|
UNKNOWN /
READ MARK LEARN: ROMANS
|
$19.90
|
|
| Tue 15 Jul 2008 |
|
Book - Hardcover
|
BLACK, C. CLIFTON /
EIGHTH DAY OF CREATION
|
$33.79
|
|
|
|
BROCK, RITA NAKASHIMA / PARKER, REBECCA ANN /
SAVING PARADISE
|
$47.60
|
|
|
|
CHAPMAN, GARY /
LOVE AS A WAY OF LIFE
|
$28.67
|
|
cart
