Racing & Metal
Fabrication Equipment
Call Today:


Log In

E-Mail Address:

Secure Log In
Password Forgotten?

Recently Viewed



Show Only: 
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