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 #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sprayequ_sprayequip1.xcart_classes.classid' 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 xcart_products.productid, xcart_products.provider, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, xcart_pricing.price, xcart_quick_prices.variantid, 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, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, IF(xcart_images_T.id IS NULL, '', 'Y') as is_thumbnail, xcart_images_T.image_path, xcart_product_taxes.taxid FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'US' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND 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.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND (IFNULL(xcart_variants.avail, xcart_products.avail) > '0' OR xcart_products.product_type NOT IN ('','N')) AND xcart_products_categories.categoryid IN ('253') AND xcart_products.views_stats > '0' AND xcart_products.sales_stats >= '0' GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
Spray Equipment Packages :: Miscellaneous and Used Equipment
CALL US: 1-888-302-0188
  



Spray Equipment Packages :: Miscellaneous and Used Equipment

Check back here frequently to find special values on select used equipment and other valuable offers. All used equipment is sold with a 30 day money back guarantee.

Miscellaneous and Used Equipment

Sort by: Sort direction Product Price Default

 Next page


205-038 Used Graco President Air Motor
See details
205-038 Used Graco President Air Motor

Used Graco 205-038 President Air Motor


 Market price: $3,310.00
Our price: $1,250.00 save 62%
Quantity

Buy Now



Binks 25' Air and Fluid Hose Set
See details
Binks 25' Air and Fluid Hose Set

25' Air and Fluid Hose Set
 


Our price: $180.79
Quantity

Buy Now



Binks PT-78-K10 2 Gallon Tank Liner (box of 10)
See details
Binks PT-78-K10 2 Gallon Tank Liner (box of 10)

2.8 Gallon pressure tank liner for Binks 83 series pressure tanks.



Our price: $51.73
Quantity

Buy Now



Graco 223-160 Stainless Steel Fluid Filter
See details
Graco 223-160 Stainless Steel Fluid Filter

Used Graco 223-160 Stainless Steel Fluid Filter




 Market price: $787.00
Our price: $300.00 save 62%
Quantity

Buy Now



Graco 224-040 Runaway Valve
See details
Graco 224-040 Runaway Valve

Used Graco 224-040 Runaway Valve

The 224-040 Runaway Valve allows users to set a maximum pump cycle rate and if that rate is exceeded this valve will relieve pressure from the system to ensure the pump does not runaway...

 Market price: $374.00
Our price: $100.00 save 73%
Quantity

Buy Now



SP-12 Lineal Molding Sprayer with Exhaust Enclosure
See details
SP-12 Lineal Molding Sprayer with Exhaust Enclosure

The SP-12 is an automatic lineal spray machine, perfect for businesses looking to put a high quality and repeatable finish on their millwork at very high production rates.  Boards are loaded in the front, pass through a De-nib/sanding zone then pass over a whisker switch that triggers 3 auto...

Our price: $32,400.00
Quantity

Buy Now



Used ARO 1" Aluminum Diaphragm Pump
See details
Used ARO 1" Aluminum Diaphragm Pump

Great General Transfer Pump
Used but has been rebuilt and tested


 Market price: $800.00
Our price: $350.00 save 56%
Quantity

Buy Now



Used Devilbiss Compact HVLP Spray Gun - COM-PS507B-14-00
See details
Used Devilbiss Compact HVLP Spray Gun - COM-PS507B-14-00

Used Devilbiss Compact HVLP Spray Gun
Pressure Feed Model
Part Number: COM-PS507B-14-00

 Market price: $486.40
Our price: $200.00 save 59%
Quantity

Buy Now



Used Graco 1050E Electric Diaphragm Pump
See details
Used Graco 1050E Electric Diaphragm Pump

Used Graco 1050E Electric Double Diaphragm Pump.



 Market price: $4,200.00
Our price: $2,940.00 save 30%
Quantity

Buy Now



Used Graco 208-997 Back Pressure Regulator
See details
Used Graco 208-997 Back Pressure Regulator

High Volume Back Pressure Regulator for Circulation Systems

SST Construction

5-180 PSI Regulated Range



 Market price: $664.00
Our price: $250.00 save 62%
Quantity

Buy Now



 
 Next page

 


Website by Zeus Copyright © 2008-2024 Spray Equipment Packages