select m.manufacturers_id, m.manufacturers_name, m.address_key, mi.manufacturers_meta_title, mi.manufacturers_meta_descp, mp.manufacturersportion_image from manufacturers m left join manufacturers_portion mp on m.manufacturers_id = mp.manufacturers_id and mp.manufacturersportion_position = 'Left Menu', manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and m.manufacturers_id = '2635'
BFit, a health & wellness support brand to provide support and protection for your all-day activities. We aim to provide support in relieve painfulness and soreness, especially for Physiotherapy use and it is quality fir for all body size. Be Competi...tive. Be Protected. Be Fit.
