Create Account
Sign In
/>Contact Us
Español
>Hydrafil - The only way to buy hydraulic filters
>Home
>FAQ
/>My Account
/>Reviews
/>My Cart
By Manufacturer
Manufacturers
>
Popular Searches
 
 
 
 
  />Moog
 
 
  />EPE
 
 
  />Pall
 
 
 
 
 
OUR GUARANTEE
Guarantee
Free 15 Day Returns, No Restocking Fee, We Even Pay For The Return Freight, The Best Part - No Questions Asked. *Read More
Contact Us
/>Sales and Support
+1 (313) 915-4120
+1 (313) 668-6620
>UPS FedEx Shipping>UPS FedEx Shipping>UPS FedEx Shipping
1054 - Unknown column 'final_price' in 'order clause'

SELECT SQL_CALC_FOUND_ROWS p.products_image, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, pd.products_info, p.products_tax_class_id from products_description pd, manufacturers m, products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '114' order by final_price , pd.products_name limit 0, 50

[TEP STOP]