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