INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, IF(xcart_products_lng.productid != '', xcart_products_lng.descr, xcart_products.descr) as descr, IF(xcart_products_lng.productid != '', xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = 0 LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='1' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale = 'Y' AND (IFNULL(xcart_variants.avail, xcart_products.avail) > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products.product ASC, xcart_products.product ASC LIMIT 0, 20
The Mills Archive Trust :: Books
E-Mail: ron.cookson@millsarchive.org

Home
Join the Friends
Shopping Cart
Contact Us
Mills Archive
Search: Advanced search
 
The Mills Archive Trust > Books
Printable version 

  Categories

  Bestsellers

  Special

  Help
We accept American Express, Visa, Master Card and Diners.

Book Shop

Please note that images are for illustrative purposes only, to enable you to identify the book. All books are donated to raise funds and are surplus to our library requirement. They are all second hand and may contain minor blemishes such as an indication of previous ownership and (occasionally) marginal notes. Serious faults will be described


  Your cart

  Authentication



Users online:  190 guests
Copyright © 2007-2015 The Mills Archive Trust
Another Divine-Creation