Access Magazines

INVALID SQL: 145 : Table './accessma_store/xcart_products' is marked as crashed and should be repaired
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, MIN(v_pricing.price) as v_price FROM( xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories )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.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/accessma/public_html/include/func.php on line 109
INVALID SQL: 145 : Table './accessma_store/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM( xcart_products, xcart_categories, xcart_products_categories, xcart_pricing )LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 10
Access Magazines


	Home


	FAQ


	Refunds & Shipping


	Shopping Cart


	Contact Us

Cart is empty

View cart | Checkout

Search:

Advanced search

Access Magazines

Special

Gift certificates

Help

Help Contact us Privacy statement Terms & Conditions Refunds & Shipping Details

Welcome to Access Magazines

Welcome to Accessmagazines.com. Take a look around and you will be surprised at the low cost of these magazine subscritpions. There are no hidden fees to these prices and no shipping costs, what you see is what you pay. Popular magazine titles starting at $5 for 12 issues.

Featured products

There are no available featured products...

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

Recover password

If Javascript is disabled in your browser click here

2Checkout.com is an authorized retailer for Accessmagazines.com.

We accept PayPal!!.
We accept PayPal!

Help | Contact us | Privacy statement | Terms & Conditions | Refunds & Shipping Details