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 = '1167'
KOOLFEVER, Japan’s best selling fever relief pad was initially developed to provide effective and convenient relief for children suffering from a fever. The popularity of our product has since encouraged us to develop a range of fever relief pads f...or babies and adults. Through extensive testing, research and the use of technological advancements, KOOLFEVER fever relief pads now bring quick, effective relief and an enhanced feeling of well-being. Kobayashi Pharmaceutical is committed to applying our expertise and research based on unique ideas to create effective, safe and convenient products
