|
|
|
All lubricants meet or exceed the manufacturer's OEM specifications.
The manufacturers and the OEM part numbers are listed for reference only.
Orders of two (2) or more 55 gallon drums receive an additional 10% discount.
Improper mixing of fluids will cause compressor failure. Consult a CE representative if you have any questions.
Please see the Lubricant Cross Reference Table on our website.
All prices and specifications are subject to change without notice. |
| Displaying 1 to 20 (of 32 products) |
Result Pages: 1 |
1054 - Unknown column 'product_price' in 'order clause'
select DISTINCTROW pd.products_name, p.products_model, p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_qty_blocks, p.products_tax_class_id, p.products_sort from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '8' order by product_price , pd.products_name limit 0, 20
[TEP STOP]
| | |
