INVALID SQL: 1231 : Variable 'sql_mode' can't be set to the value of 'MYSQL40'
SQL QUERY FAILURE:SET sql_mode = 'MYSQL40'
INVALID SQL: 1055 : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'sprayequ_sprayequip1.xcart_products_categories.orderby' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid 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.forsale = 'Y' OR xcart_products.forsale = '') 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_categories.orderby ASC, xcart_products.product ASC
Spray Equipment Packages :: Search results
Spray Guns
Search: Advanced search
 
Categories Categories


Manufacturers Manufacturers
Graco


Special Special
Gift certificates


Help Help
Contact us
Privacy statement
Terms & Conditions
Graco Paint Sprayers
Global Finishing Solutions
ITW Binks and Devilbiss
Miracle Paint Mixers and Shakers
Nordson Systems
HVLP Spray Guns
Spray Equipment
Electrostatic Spray Guns or Powder Coating
Paint Spray Guns
Airless Disinfectant Sprayers - Graco SaniSpray HP

Spray Equipment Packages :: Search results


Search for products

Search for pattern:  
     
Search in:
        

Click to open Advanced search options

 



 

Quick Contact







Your cart Your cart
Cart is empty
 

View cart
Checkout
Orders history


Authentication Authentication
Secure login 
Register 
Recover password

If Javascript is disabled in your browser click here


Website by Zeus Copyright © 2008-2024 Spray Equipment Packages