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 = '2943'
500mg Daflon Tablet is used to treat haemorrhoids, varicose veins, and lymphedema, both acute and chronic. It improves blood flow and restores the function of the veins. Daflon tablet is taken with or without food, according to the doctor's instructi...ons.
