INSERT INTO allergen_allergen_panel (allergen_id,allergen_panel_id)
SELECT allergen.allergen_id, 10 as 'allergen_panel_id' FROM allergen_allergen_panel
INNER JOIN allergen ON allergen_allergen_panel.allergen_id = allergen.allergen_id
INNER JOIN allergen_panel ON allergen_allergen_panel.allergen_panel_id = allergen_panel.allergen_panel_id
WHERE allergen_panel.allergen_panel_id = 2 and allergen_code IN 
('t3','t4','t9','t23','t25','g6','g12','g2','g17','w1','w6','w9','e1','e3','e5','dx2','m2','f1','f199','f3','f41','f23','f24','fx693','f4','f9','f14','f35','f13','f17','f20','f25','f31','f44','f49')