Ministry Through Magazines

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, v_pricing.price as v_price FROM xcart_products, xcart_pricing , xcart_featured_products LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND xcart_pricing.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.*, MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, v_pricing.price as v_price FROM xcart_products, xcart_pricing , xcart_featured_products LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND xcart_pricing.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order LIMIT 0, 20
Ministry Through Magazines

Search:

MAGAZINES THEY'LL READ ... LIVES HE'LL CHANGE!

CATEGORIES

NEWSLETTER

Please notify me of new magazines as they are added.

Your email:

Subscribe

Bestsellers

1. Quick Pick Package
2. Build Your Own Package
3. Decision

Customer Login

Username

Password

If Javascript is disabled in your browser click here

Family Friendly Magazines for Your Waiting Room

WHAT WE WILL DO FOR YOU: You want family friendly publications in your waiting room, but you can’t spend a lot of time searching for them and handling the different subscriptions. Ministry Through Magazines removes the hassles. We offer 21 top Christian magazines at a discount …choose as many as you want ... with the convenience of one order. When it comes time to renew, it’s one easy renewal. And it all can be done in minutes on-line. Fast and Easy.

General Interest Package
SKU: 1001

Male Interest Package
SKU: 1002A

CLICK FOR PRODUCT DETAILS

OUR PRICE: $110.00

Female Interest Package
SKU: 1003A

Build Your Own Package
SKU: 1004A

CLICK FOR PRODUCT DETAILS

OUR PRICE: $110.00

Quick Pick Package
SKU: 1005A

CLICK FOR PRODUCT DETAILS

OUR PRICE: $60.00

HOW IT WORKS: Ministry Through Magazines has joined with top Christian publishers to provide quality Christian magazines for waiting rooms in businesses and professional offices. These magazines are available in convenient packages, as well as a la cart. Select the magazines you want, choose your preferred payment method, and we take care of the rest. We’ll notify the publishers, they will send you the magazines, and your clients will have life-changing reading material. When it comes time to renew, you get one notice. It’s that simple.

Many Magazines. One Order. One Renewal.
No Hassles!