SELECT p_model, p_gtin, p_title as p_titlang, p_title, p_descrip as p_descrip, p_longDescrip, p_sellBy, p_sell, p_listPrc, p_mapPrc, p_sku, prc_bustCart, prc_bustSite, prc_bustEmail, prc_bustFeed, v_id, v_name, v_code, sp_price, sp_height, sp_width, sp_depth, sp_cube, sp_weight, sp_zip, sp_freightClass, sp_fco, '' as wlmodel, CONCAT(sf_name, ":", sf_title) AS plug, c_id, c_name, c_site, c_desc FROM products JOIN pricing ON p_prc_id = prc_id JOIN vendor ON prc_v_id = v_id LEFT JOIN ship_prod ON sp_p_id = p_id LEFT JOIN special_features ON p_descrip LIKE CONCAT("% ", sf_name,"%") AND sf_class = "Plug Type" LEFT JOIN prod_cat ON pc_p_id = p_id LEFT JOIN category ON pc_c_id = c_id WHERE p_id=:p_id GROUP BY p_id
Replacement Rod, with washer, nut & wing nut, for french fry cutter (FF4)
Manufacturer | Alfa International |
Model Number | ALF-FF-ROD |
Packed By | Each |
Wing Nut, for ALFA french fry cutters
Tray, for ALFA french fry cutter, stainless steel
Feet, for french fry cutter (FF4) (set of 4)
Twoyco French Fry Cutter, manual, wall or table mount, 1/2" cut, up to 50 lbs. potatoes per hour, stainless steel tray and blades, heavy duty aluminum frame with steel base