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 = '587'
Counterpain
Counterpain is a long heritage, well-known brand among the household.Trusted brand by generation. Provides quick relief of muscular and joint pain. Quality products from Japan. See less
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia
Instant Rebate RM5
With Min Spend of RM40 on Counterpain Products