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 = '2004'
Uright
Uright dedicates to develop unique technologies for medical application. We currently have 149 patents worldwide for the IR thermometer, blood glucose meter, ...
Happening Now!!
FREE SHIPPING
Max capped RM6 OFF