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 = '2007'
Shieldaway, the DEET-free insect repellent lotion made up from premium ingredient with advanced technology - STAYTECH™️ to achieve 16+ Hours protection against insect. The formulation is safe for sensitive skin with gentle feel and scent. It can ...be applied on infants above 2 months old as well.
