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
Fabricante | Witt Industries |
Modelo # | WTI-M3601-ATL-BN |
Empacado | Each |
Oakley Collection Ash Top Lid, 23-3/4" diameter, black finish, steel construction, for outdoor use, for M3601
Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, rain cap top lid, brown finish, steel construction, for outdoor use
Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, dome top lid, green finish, steel construction, for outdoor use
Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, rain cap top lid, black finish, steel construction, for outdoor use