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 = '52'
DifflamAB™ and Difflam HEXTRA™ has a range of lozenges to help relieve your sore throat symptoms. For dry, tickly feeling then ask for a lozenge, try out DIFFLAM® AB Sore Throat Lozenges, which contains two antibacterial agents (dichlorobenzyl ...alcohol and amylmetacresol) to help kill bacteria associated with minor throat and mouth infections. When you have a sharp, stabbing sore throat, try DIFFLAM® HEXTRA Sore Throat Lozenges. They contain hexylresorcinol, an antibacterial that helps to fight infections combined with a local anaesthetic properties to numb throat pain.
