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, MAX(IF(m_type = "Image", m_value, NULL)) AS image, MAX(IF(m_type = "Spec Sheet", m_value, NULL)) AS sheet, MAX(IF(m_type = "Video", m_value, NULL)) as video, GROUP_CONCAT( DISTINCT CONCAT("[", ps_title, ":", ps_value, "]") ) as specs, 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 JOIN media ON m_p_id = p_id JOIN product_specs ON ps_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
Steam'N'Hold⢠Boilerless Convection Steamer, countertop, electric, holds (6) 12"x 20"x 2-1/2" deep pans, vacuum cooking, manual mechanical timer controls, NO water or drain connections required, 6kw, 240/60/1ph, 5' cord & NEMA L6-30P, ENERGY STAR®
Manufacturer | Accutemp |
Model Number | ACC-S62401D060 |
Packed By | Each |
ELECTRIC OR GAS | Electric Operation |
PAN CAPACITY | (6) 12"x20"x2-1/2" Deep Pans |
ENERGY EFFICIENCY | Energy Star® |
CONTROLS | Manual |
COMPARTMENTS | 1 |
(QUICK SHIP) Connectionless Evolution Boilerless, Convection Steamer featuring Steam Vector Technology, counter top, electric, holds (6) 12"x 20"x 2-1/2" deep pans, Digital Controls, NO water and drain connection required, warranty NOT voided by water quality, NO water filtration required, 12kw, 440/60/3ph, 5' cord & NEMA L15-30P, ENERGY STAR
Steam'N'Hold Boilerless Convection Steamer, countertop, electric, holds (3) 12"x 20"x 2-1/2" deep pans, vacuum cooking, manual mechanical timer controls, NO water or drain connections required, 6kw, 208/60/1ph, 5' cord & NEMA L6-30P, ENERGY STAR
(QUICK SHIP) Connected Evolution Boilerless, Convection Steamer featuring Steam Vector Technology, flush mount countertop, natural gas, holds (6) 12"x 20"x 2-1/2" deep pans, Digital Controls, water and drain connection required, warranty NOT voided by water quality, NO water filtration required, 60,000BTU, 120/60/1ph, 5' cord & NEMA 5-15P, ENERGY STAR
Steam'N'Hold Boilerless Convection Steamer, countertop, electric, holds (3) 12" x 20" x 2-1/2" deep pans each compartment, vacuum cooking, manual mechanical timer controls, NO water or drain connections required, 11kw each, 480/60/3ph, 5' cord & NEMA L16-20P, ENERGY STAR