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 = '1178'
Useful for fast and effective relief of dizziness, headaches, motion sickness, blocked nose, stomachaches, sprains, rheumatic pains and speeds healing of insect bites. Keep a bottle of Kwan Loong Medicated Oil close to you at all times. You never kno...w when you are going to need it. Kwan Loong Medicated Oil contains ingredients that helps promote healing at the same time provides a cooling and invigorating sensation.
