pineapple is the flavor of what manufactured drug?
(AND medicine.manufactured_drug_form (JOIN medicine.manufactured_drug_form.flavor m.0fp6w))