Racing & Metal
Fabrication Equipment
Call Today:
800-221-7223

Products

Log In

E-Mail Address:
Password:

Secure Log In
Password Forgotten?

Recently Viewed

Manufacturer

ENGLISH WHEELS

Show Only: 
ENGLISH WHEELS
Irvan-Smith, Inc. is proud to carry the Fournier and MetalAce line of quality English wheels and metal forming accessories.  These wheeling machines and tools are used by the finest craftsmen in the country to shape metal for projects such as NASCAR race cars to vintage aircraft.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'limit 0, 200' at line 1

select p.products_image, m.manufacturers_name, pd.products_name, p.products_model, p.products_id, pd.short_desc, p.manufacturers_id, p.products_uom, p.products_price, p.exclude_free_shipping, p.products_call_to_order, p.products_call_for_price, p.products_mpn, p.products_special_in_cart, p.products_master, p.products_master_status, p.products_tax_class_id, m.manufacturers_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m, products_to_categories p2c left join categories c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.products_listing_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '50' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '32' order by limit 0, 200

[TEP STOP]