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 = '218'
Ammeltz Yoko Yoko is specially formulated to thoroughly seep into affected parts, to help relieve shoulder stiffness and muscular aches effectively over a longer lasting period. Unlike normal plasters, there's no inconvenience of peeling it off. It c...an be applied on hairy skin areas, joints, perspirant area etc. Ammeltz contains no greasee, hence it is not sticky.
