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,
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
liso Shieldâ„¢ protector de comida, autoservicio vidrio frontal, de doble lado, 101.6cmde profundidad x 335.28cmW, 45.72cm de altura con repisa superior de vidrio, .635cm de grosor vidrio templado al calor parte frontal & paneles laterales, .9525cm de grosor Calor templado superior/superficie (de) vidrio/vaso, equipado con cámara cerraduraâ„¢ TecnologÃa fijo(a)(s) a patas, permitiendo rotación en 15 grado(s) intervalos, máximo carga arriba (de) vidrio/vaso 100 libras distribuido en forma pareja peso
Fabricante | Advance Tabco |
Modelo # | ADV-GSGD-40-132 |
Empacado | Each |
SERVICE | Self-service |
FRAME CONSTRUCTION | Stainless Steel |
TYPE | Single-sided |
LENGTH (SIDE - SIDE) | 129" - 134" |
Sleek Shield Food Shield, self service, double sided, 40"D x 60"W, 3/8" thick heat tempered glass front & 1/4" thick side panels (side panels 18" deep to meet NSF requirements), equipped with Chamber Lock technology fixed to upright legs, allowing rotation in 15 degree intervals, maximum load on top glass 100 pounds evenly distributed weight
Sleek Shield Food Shield, self service, double sided, 40"D x 120"W, 3/8" thick heat tempered glass front & 1/4" thick side panels (side panels 18" deep to meet NSF requirements), equipped with Chamber Lock technology fixed to upright legs, allowing rotation in 15 degree intervals, maximum load on top glass 100 pounds evenly distributed weight
Sleek Shield Food Shield, self service, double sided, 40"D x 48"W, 18" tall with Glass top shelf, 1/4" thick heat tempered glass front & side panels, 3/8" thick heat tempered top glass, equipped with Chamber Lock technology fixed to upright legs, allowing rotation in 15 degree intervals, maximum load on top glass 100 pounds evenly distributed weight
Sleek Shield Food Shield, self service, double sided, 40"D x 96"W, 18" tall with Glass top shelf, 1/4" thick heat tempered glass front & side panels, 3/8" thick heat tempered top glass, equipped with Chamber Lock technology fixed to upright legs, allowing rotation in 15 degree intervals, maximum load on top glass 100 pounds evenly distributed weight