INVALID SQL: 1021 : Disk full (/var/tmp/#sql_6c58_6); waiting for someone to free some space... 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, MIN(v_pricing.price) as v_price FROM ( xcart_products, xcart_pricing , 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_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.manufacturerid IN ('5') 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 ORDER BY price ASC, xcart_products.product ASC LIMIT 80, 20
CABOT STAIN
:: Manufacturers
:: DiscountPaint.net
Cabot
Stains are recognized as an industry leader in the development, manufacture
and distribution of premium quality exterior wood stains and surface
finishing products.
CABOT STAIN
There are no available products under this manufacturer.
Categories
Your cart
Authentication
News
