SELECT p_model, p_gtin, CONCAT(p_title_es,'
(', p_title ,')') as p_titlang, p_title, p_descrip_es 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, 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 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
C5™ 3 Series Conservador de calor & Gabinete de Fermentación, mas bajo vatiaje, con gris aislado Armour™, móvil, bajo encimera, isotérmico(s), puerta de policarbonato transparente, módulo de control montado en la parte inferior módulo, termostato a 200°F, guías de alambre universales en 7.62cm centros, ajustable en 3.81cm incrementos (5) 45.72cm x 66.04cm o (10) 30.48cm x 50.8cm x 6.35cm capacidad de bandejas, 7.62cm ruedas (2 con frenos), aluminio, 120V/60/1-PH, 1400 vatios, 12 Amperios, NEMA 5-15P, cULus, NSF
Fabricante | Intermetro |
Modelo # | INT-C533-CLFC-U-GYA |
Empacado | Each |
C5 3 Series Heated Holding & Proofing Cabinet, lower wattage, with Gray Insulation Armour, mobile, under counter, insulated, clear polycarbonate door, removable bottom mount control module, thermostat to 200F, lip-load slides on 1-1/2" centers, (10) 18" x 26" pan capacity, 3" casters (2 with brakes), aluminum, 120v/60/1-ph, 1400 watts, 12 amps, NEMA 5-15P, cULus, NSF
C5 3 Series Heated Holding & Proofing Cabinet, lower wattage, with Red Insulation Armour, mobile, under counter, insulated, clear polycarbonate door, removable bottom mount control module, thermostat to 200F, universal wire slides on 3" centers, adjustable on 1-1/2" increments (5) 18" x 26" or (10) 12" x 20" x 2-1/2" pan capacity, 3" casters (2 with brakes), aluminum, 120v/60/1-ph, 1400 watts, 12 amps, NEMA 5-15P, cULus, NSF
C5 3 Series Heated Holding & Proofing Cabinet, lower wattage, with Gray Insulation Armour, mobile, under counter, insulated, clear polycarbonate door, removable bottom mount control module, thermostat to 200F, lip-load slides on 1-1/2" centers, (10) 18" x 26" pan capacity, 3" casters (2 with brakes), aluminum, 120v/60/1-ph, 1400 watts, 12 amps, NEMA 5-15P, cULus, NSF
C5 3 Series Heated Holding & Proofing Cabinet, lower wattage, with Gray Insulation Armour, mobile, under counter, insulated, clear polycarbonate door, removable bottom mount control module, thermostat to 200F, universal wire slides on 3" centers, adjustable on 1-1/2" increments (5) 18" x 26" or (10) 12" x 20" x 2-1/2" pan capacity, 3" casters (2 with brakes), aluminum, 120v/60/1-ph, 1400 watts, 12 amps, NEMA 5-15P, cULus, NSF