-- creating the temporary table
create table a (
a_id INT NOT NULL AUTO_INCREMENT,
allergen_id INT,
panelname char varying(5),
group_name char varying(50),
primary key(a_id)
);

-- inserting data into the temporary table
INSERT INTO `a` (`allergen_id`, `panelname`, `group_name`) VALUES
(1, 'E2', 'Vegetables'),
(2, 'E2', 'Vegetables'),
(3, 'E2', 'Vegetables'),
(4, 'E2', 'Miscellaneous'),
(5, 'E2', 'Fruits'),
(6, 'E2', 'Fruits'),
(7, 'E2', 'Fruits'),
(8, 'E2', 'Fruits'),
(9, 'E2', 'Fruits'),
(10, 'E2', 'Poultry'),
(11, 'E2', 'Milk & Other Dairy'),
(12, 'E2', 'Seafood'),
(13, 'E2', 'Seafood'),
(14, 'E2', 'Seafood'),
(15, 'E2', 'Seafood'),
(16, 'E2', 'Meats'),
(17, 'E2', 'Gluten-Containing Grains'),
(18, 'E2', 'Gluten-Free Grains'),
(19, 'E2', 'Beans'),
(20, 'E2', 'Vegetables'),
(21, 'E2', 'Nuts & Seeds'),
(22, 'E2', 'Nuts & Seeds'),
(23, 'E2', 'Nuts & Seeds'),
(24, 'E2', 'Miscellaneous Allergy'),
(25, 'E2', 'Miscellaneous Allergy'),
(26, 'G4_1', 'Seafood'),
(27, 'G4_1', 'Seafood'),
(28, 'G4_1', 'Seafood'),
(29, 'G4_1', 'Seafood'),
(30, 'G4_1', 'Seafood'),
(31, 'G4_1', 'Meats'),
(32, 'G4_1', 'Meats'),
(33, 'G4_1', 'Poultry'),
(34, 'G4_1', 'Gluten-Containing Grains'),
(35, 'G4_1', 'Gluten-Containing Grains'),
(36, 'G4_1', 'Gluten-Containing Grains'),
(37, 'G4_1', 'Vegetables'),
(38, 'G4_1', 'Gluten-Free Grains'),
(39, 'G4_1', 'Gluten-Free Grains'),
(40, 'G4_1', 'Gluten-Free Grains'),
(41, 'G4_1', 'Vegetables'),
(42, 'G4_1', 'Vegetables'),
(43, 'G4_1', 'Vegetables'),
(44, 'G4_1', 'Vegetables'),
(45, 'G4_1', 'Vegetables'),
(46, 'G4_1', 'Beans'),
(47, 'G4_1', 'Beans'),
(48, 'G4_1', 'Beans'),
(49, 'G4_1', 'Nuts & Seeds'),
(50, 'G4_1', 'Vegetables'),
(51, 'G4_1', 'Vegetables'),
(52, 'G4_1', 'Vegetables'),
(53, 'G4_1', 'Miscellaneous'),
(54, 'G4_1', 'Poultry'),
(55, 'G4_1', 'Poultry'),
(56, 'G4_1', 'Milk & Other Dairy'),
(57, 'G4_1', 'Milk & Other Dairy'),
(58, 'G4_1', 'Milk & Other Dairy'),
(59, 'G4_1', 'Fruits'),
(60, 'G4_1', 'Fruits'),
(61, 'G4_1', 'Fruits'),
(62, 'G4_1', 'Fruits'),
(63, 'G4_1', 'Nuts & Seeds'),
(64, 'G4_1', 'Nuts & Seeds'),
(65, 'G4_1', 'Nuts & Seeds'),
(66, 'G4_2', 'Seafood'),
(67, 'G4_2', 'Seafood'),
(68, 'G4_2', 'Seafood'),
(69, 'G4_2', 'Seafood'),
(70, 'G4_2', 'Seafood'),
(71, 'G4_2', 'Seafood'),
(72, 'G4_2', 'Meats'),
(73, 'G4_2', 'Meats'),
(74, 'G4_2', 'Meats'),
(75, 'G4_2', 'Gluten-Containing Grains'),
(76, 'G4_2', 'Gluten-Containing Grains'),
(77, 'G4_2', 'Nuts & Seeds'),
(78, 'G4_2', 'Gluten-Containing Grains'),
(79, 'G4_2', 'Gluten-Free Grains'),
(80, 'G4_2', 'Vegetables'),
(81, 'G4_2', 'Vegetables'),
(82, 'G4_2', 'Vegetables'),
(83, 'G4_2', 'Vegetables'),
(84, 'G4_2', 'Vegetables'),
(85, 'G4_2', 'Vegetables'),
(86, 'G4_2', 'Vegetables'),
(87, 'G4_2', 'Beans'),
(88, 'G4_2', 'Poultry'),
(89, 'G4_2', 'Poultry'),
(90, 'G4_2', 'Cheeses'),
(91, 'G4_2', 'Milk & Other Dairy'),
(92, 'G4_2', 'Fruits'),
(93, 'G4_2', 'Fruits'),
(94, 'G4_2', 'Fruits'),
(95, 'G4_2', 'Fruits'),
(96, 'G4_2', 'Fruits'),
(97, 'G4_2', 'Nuts & Seeds'),
(98, 'G4_2', 'Nuts & Seeds'),
(99, 'G4_2', 'Nuts & Seeds'),
(100, 'G4_2', 'Nuts & Seeds'),
(101, 'G4_2', 'Nuts & Seeds'),
(102, 'G4_2', 'Nuts & Seeds'),
(103, 'G4_2', 'Vegetables'),
(104, 'G4_2', 'Miscellaneous'),
(105, 'G4_2', 'Beans'),
(106, 'G4_3', 'Seafood'),
(107, 'G4_3', 'Seafood'),
(108, 'G4_3', 'Seafood'),
(109, 'G4_3', 'Seafood'),
(110, 'G4_3', 'Seafood'),
(111, 'G4_3', 'Seafood'),
(112, 'G4_3', 'Poultry'),
(113, 'G4_3', 'Poultry'),
(114, 'G4_3', 'Poultry'),
(115, 'G4_3', 'Gluten-Containing Grains'),
(116, 'G4_3', 'Gluten-Free Grains'),
(117, 'G4_3', 'Gluten-Containing Grains'),
(118, 'G4_3', 'Gluten-Containing Grains'),
(119, 'G4_3', 'Gluten-Free Grains'),
(120, 'G4_3', 'Gluten-Free Grains'),
(121, 'G4_3', 'Gluten-Containing Grains'),
(122, 'G4_3', 'Vegetables'),
(123, 'G4_3', 'Vegetables'),
(124, 'G4_3', 'Vegetables'),
(125, 'G4_3', 'Vegetables'),
(126, 'G4_3', 'Beans'),
(127, 'G4_3', 'Beans'),
(128, 'G4_3', 'Beans'),
(129, 'G4_3', 'Milk & Other Dairy'),
(130, 'G4_3', 'Milk & Other Dairy'),
(131, 'G4_3', 'Milk & Other Dairy'),
(132, 'G4_3', 'Fruits'),
(133, 'G4_3', 'Fruits'),
(134, 'G4_3', 'Fruits'),
(135, 'G4_3', 'Fruits'),
(136, 'G4_3', 'Fruits'),
(137, 'G4_3', 'Nuts & Seeds'),
(138, 'G4_3', 'Nuts & Seeds'),
(139, 'G4_3', 'Miscellaneous'),
(140, 'G4_3', 'Herbs & Spices'),
(141, 'G4_3', 'Herbs & Spices'),
(142, 'G4_3', 'Miscellaneous'),
(143, 'G4_3', 'Miscellaneous'),
(144, 'G4_3', 'Vegetables'),
(145, 'G4_3', 'Gluten-Free Grains'),
(146, 'E3', 'Tree pollen'),
(147, 'E3', 'Tree pollen'),
(148, 'E3', 'Tree pollen'),
(149, 'E3', 'Tree pollen'),
(150, 'E3', 'Tree pollen'),
(151, 'E3', 'Grass pollen'),
(152, 'E3', 'Grass pollen'),
(153, 'E3', 'Grass pollen'),
(154, 'E3', 'Grass pollen'),
(155, 'E3', 'Weed pollen'),
(156, 'E3', 'Weed pollen'),
(157, 'E3', 'Weed pollen'),
(158, 'E3', 'Pets'),
(159, 'E3', 'Pets'),
(160, 'E3', 'Pets'),
(161, 'E3', 'Dust'),
(162, 'E3', 'Insects'),
(163, 'E3', 'Mould'),
(164, 'E3', 'Poultry'),
(165, 'E3', 'Milk & Other Dairy'),
(166, 'E3', 'Seafood'),
(167, 'E3', 'Seafood'),
(168, 'E3', 'Seafood'),
(169, 'E3', 'Seafood'),
(170, 'E3', 'Meats'),
(171, 'E3', 'Gluten-Containing Grains'),
(172, 'E3', 'Gluten-Free Grains'),
(173, 'E3', 'Beans'),
(174, 'E3', 'Vegetables'),
(175, 'E3', 'Nuts & Seeds'),
(176, 'E3', 'Nuts & Seeds'),
(177, 'E3', 'Nuts & Seeds'),
(178, 'E3', 'Vegetables'),
(179, 'E3', 'Vegetables'),
(180, 'E3', 'Fruits'),
(181, 'E3', 'Fruits'),
(182, 'E3', 'Fruits'),
(183, 'E3', 'Fruits'),
(184, 'E3', 'Miscellaneous Allergy'),
(185, 'E3', 'Miscellaneous Allergy'),
(66, 'G4_2', 'Seafood'),
(67, 'G4_2', 'Seafood'),
(68, 'G4_2', 'Seafood'),
(69, 'G4_2', 'Seafood'),
(70, 'G4_2', 'Seafood'),
(71, 'G4_2', 'Seafood'),
(72, 'G4_2', 'Meats'),
(73, 'G4_2', 'Meats'),
(74, 'G4_2', 'Meats'),
(75, 'G4_2', 'Gluten-Containing Grains'),
(76, 'G4_2', 'Gluten-Containing Grains'),
(77, 'G4_2', 'Nuts & Seeds'),
(78, 'G4_2', 'Gluten-Containing Grains'),
(79, 'G4_2', 'Gluten-Free Grains'),
(80, 'G4_2', 'Vegetables'),
(81, 'G4_2', 'Vegetables'),
(82, 'G4_2', 'Vegetables'),
(83, 'G4_2', 'Vegetables'),
(84, 'G4_2', 'Vegetables'),
(85, 'G4_2', 'Vegetables'),
(86, 'G4_2', 'Vegetables'),
(87, 'G4_2', 'Beans'),
(88, 'G4_2', 'Poultry'),
(89, 'G4_2', 'Poultry'),
(90, 'G4_2', 'Cheeses'),
(91, 'G4_2', 'Milk & Other Dairy'),
(92, 'G4_2', 'Fruits'),
(93, 'G4_2', 'Fruits'),
(94, 'G4_2', 'Fruits'),
(95, 'G4_2', 'Fruits'),
(96, 'G4_2', 'Fruits'),
(97, 'G4_2', 'Nuts & Seeds'),
(98, 'G4_2', 'Nuts & Seeds'),
(99, 'G4_2', 'Nuts & Seeds'),
(100, 'G4_2', 'Nuts & Seeds'),
(101, 'G4_2', 'Nuts & Seeds'),
(102, 'G4_2', 'Nuts & Seeds'),
(103, 'G4_2', 'Vegetables'),
(104, 'G4_2', 'Miscellaneous'),
(105, 'G4_2', 'Beans'),
(106, 'G4_3', 'Seafood'),
(107, 'G4_3', 'Seafood'),
(108, 'G4_3', 'Seafood'),
(109, 'G4_3', 'Seafood'),
(110, 'G4_3', 'Seafood'),
(111, 'G4_3', 'Seafood'),
(112, 'G4_3', 'Poultry'),
(113, 'G4_3', 'Poultry'),
(114, 'G4_3', 'Poultry'),
(115, 'G4_3', 'Gluten-Containing Grains'),
(116, 'G4_3', 'Gluten-Free Grains'),
(117, 'G4_3', 'Gluten-Containing Grains'),
(118, 'G4_3', 'Gluten-Containing Grains'),
(119, 'G4_3', 'Gluten-Free Grains'),
(120, 'G4_3', 'Gluten-Free Grains'),
(121, 'G4_3', 'Gluten-Containing Grains'),
(122, 'G4_3', 'Vegetables'),
(123, 'G4_3', 'Vegetables'),
(124, 'G4_3', 'Vegetables'),
(125, 'G4_3', 'Vegetables'),
(126, 'G4_3', 'Beans'),
(127, 'G4_3', 'Beans'),
(128, 'G4_3', 'Beans'),
(129, 'G4_3', 'Milk & Other Dairy'),
(130, 'G4_3', 'Milk & Other Dairy'),
(131, 'G4_3', 'Milk & Other Dairy'),
(132, 'G4_3', 'Fruits'),
(133, 'G4_3', 'Fruits'),
(134, 'G4_3', 'Fruits'),
(135, 'G4_3', 'Fruits'),
(136, 'G4_3', 'Fruits'),
(137, 'G4_3', 'Nuts & Seeds'),
(138, 'G4_3', 'Nuts & Seeds'),
(139, 'G4_3', 'Miscellaneous'),
(140, 'G4_3', 'Herbs & Spices'),
(141, 'G4_3', 'Herbs & Spices'),
(142, 'G4_3', 'Miscellaneous'),
(143, 'G4_3', 'Miscellaneous'),
(144, 'G4_3', 'Vegetables'),
(145, 'G4_3', 'Gluten-Free Grains'),
(186, 'G4_4', 'Seafood'),
(187, 'G4_4', 'Seafood'),
(188, 'G4_4', 'Seafood'),
(189, 'G4_4', 'Seafood'),
(190, 'G4_4', 'Seafood'),
(191, 'G4_4', 'Seafood'),
(192, 'G4_4', 'Meats'),
(193, 'G4_4', 'Meats'),
(194, 'G4_4', 'Vegetables'),
(195, 'G4_4', 'Vegetables'),
(196, 'G4_4', 'Vegetables'),
(197, 'G4_4', 'Beans'),
(198, 'G4_4', 'Fruits'),
(199, 'G4_4', 'Vegetables'),
(200, 'G4_4', 'Vegetables'),
(201, 'G4_4', 'Vegetables'),
(202, 'G4_4', 'Vegetables'),
(203, 'G4_4', 'Vegetables'),
(204, 'G4_4', 'Vegetables'),
(205, 'G4_4', 'Vegetables'),
(206, 'G4_4', 'Milk & Other Dairy'),
(207, 'G4_4', 'Cheeses'),
(208, 'G4_4', 'Cheeses'),
(209, 'G4_4', 'Cheeses'),
(210, 'G4_4', 'Cheeses'),
(211, 'G4_4', 'Cheeses'),
(212, 'G4_4', 'Cheeses'),
(213, 'G4_4', 'Cheeses'),
(214, 'G4_4', 'Cheeses'),
(215, 'G4_4', 'Fruits'),
(216, 'G4_4', 'Fruits'),
(217, 'G4_4', 'Fruits'),
(218, 'G4_4', 'Fruits'),
(219, 'G4_4', 'Fruits'),
(220, 'G4_4', 'Fruits'),
(221, 'G4_4', 'Fruits'),
(222, 'G4_4', 'Fruits'),
(223, 'G4_4', 'Herbs & Spices'),
(224, 'G4_4', 'Herbs & Spices'),
(225, 'G4_4', 'Herbs & Spices'),
(226, 'G4_5', 'Seafood'),
(227, 'G4_5', 'Seafood'),
(228, 'G4_5', 'Seafood'),
(229, 'G4_5', 'Seafood'),
(230, 'G4_5', 'Meats'),
(231, 'G4_5', 'Meats'),
(232, 'G4_5', 'Vegetables'),
(233, 'G4_5', 'Beans'),
(234, 'G4_5', 'Vegetables'),
(235, 'G4_5', 'Vegetables'),
(236, 'G4_5', 'Vegetables'),
(237, 'G4_5', 'Vegetables'),
(238, 'G4_5', 'Vegetables'),
(239, 'G4_5', 'Beans'),
(240, 'G4_5', 'Vegetables'),
(241, 'G4_5', 'Vegetables'),
(242, 'G4_5', 'Fruits'),
(243, 'G4_5', 'Milk & Other Dairy'),
(244, 'G4_5', 'Cheeses'),
(245, 'G4_5', 'Milk & Other Dairy'),
(246, 'G4_5', 'Cheeses'),
(247, 'G4_5', 'Fruits'),
(248, 'G4_5', 'Fruits'),
(249, 'G4_5', 'Fruits'),
(250, 'G4_5', 'Fruits'),
(251, 'G4_5', 'Fruits'),
(252, 'G4_5', 'Fruits'),
(253, 'G4_5', 'Fruits'),
(254, 'G4_5', 'Nuts & Seeds'),
(255, 'G4_5', 'Nuts & Seeds'),
(256, 'G4_5', 'Fruits'),
(257, 'G4_5', 'Nuts & Seeds'),
(258, 'G4_5', 'Nuts & Seeds'),
(259, 'G4_5', 'Herbs & Spices'),
(260, 'G4_5', 'Herbs & Spices'),
(261, 'G4_5', 'Herbs & Spices'),
(262, 'G4_5', 'Herbs & Spices'),
(263, 'G4_5', 'Nuts & Seeds'),
(264, 'G4_5', 'Nuts & Seeds'),
(265, 'G4_5', 'Seafood'),
(226, 'G4_5', 'Seafood'),
(227, 'G4_5', 'Seafood'),
(228, 'G4_5', 'Seafood'),
(229, 'G4_5', 'Seafood'),
(230, 'G4_5', 'Meats'),
(231, 'G4_5', 'Meats'),
(232, 'G4_5', 'Vegetables'),
(233, 'G4_5', 'Beans'),
(234, 'G4_5', 'Vegetables'),
(235, 'G4_5', 'Vegetables'),
(236, 'G4_5', 'Vegetables'),
(237, 'G4_5', 'Vegetables'),
(238, 'G4_5', 'Vegetables'),
(239, 'G4_5', 'Beans'),
(240, 'G4_5', 'Vegetables'),
(241, 'G4_5', 'Vegetables'),
(242, 'G4_5', 'Fruits'),
(243, 'G4_5', 'Milk & Other Dairy'),
(244, 'G4_5', 'Cheeses'),
(245, 'G4_5', 'Milk & Other Dairy'),
(246, 'G4_5', 'Cheeses'),
(247, 'G4_5', 'Fruits'),
(248, 'G4_5', 'Fruits'),
(249, 'G4_5', 'Fruits'),
(250, 'G4_5', 'Fruits'),
(251, 'G4_5', 'Fruits'),
(252, 'G4_5', 'Fruits'),
(253, 'G4_5', 'Fruits'),
(254, 'G4_5', 'Nuts & Seeds'),
(255, 'G4_5', 'Nuts & Seeds'),
(256, 'G4_5', 'Fruits'),
(257, 'G4_5', 'Nuts & Seeds'),
(258, 'G4_5', 'Nuts & Seeds'),
(259, 'G4_5', 'Herbs & Spices'),
(260, 'G4_5', 'Herbs & Spices'),
(261, 'G4_5', 'Herbs & Spices'),
(262, 'G4_5', 'Herbs & Spices'),
(263, 'G4_5', 'Nuts & Seeds'),
(264, 'G4_5', 'Nuts & Seeds'),
(265, 'G4_5', 'Seafood'),
(66, 'G4_2', 'Seafood'),
(67, 'G4_2', 'Seafood'),
(68, 'G4_2', 'Seafood'),
(69, 'G4_2', 'Seafood'),
(70, 'G4_2', 'Seafood'),
(71, 'G4_2', 'Seafood'),
(72, 'G4_2', 'Meats'),
(73, 'G4_2', 'Meats'),
(74, 'G4_2', 'Meats'),
(75, 'G4_2', 'Gluten-Containing Grains'),
(76, 'G4_2', 'Gluten-Containing Grains'),
(77, 'G4_2', 'Nuts & Seeds'),
(78, 'G4_2', 'Gluten-Containing Grains'),
(79, 'G4_2', 'Gluten-Free Grains'),
(80, 'G4_2', 'Vegetables'),
(81, 'G4_2', 'Vegetables'),
(82, 'G4_2', 'Vegetables'),
(83, 'G4_2', 'Vegetables'),
(84, 'G4_2', 'Vegetables'),
(85, 'G4_2', 'Vegetables'),
(86, 'G4_2', 'Vegetables'),
(87, 'G4_2', 'Beans'),
(88, 'G4_2', 'Poultry'),
(89, 'G4_2', 'Poultry'),
(90, 'G4_2', 'Cheeses'),
(91, 'G4_2', 'Milk & Other Dairy'),
(92, 'G4_2', 'Fruits'),
(93, 'G4_2', 'Fruits'),
(94, 'G4_2', 'Fruits'),
(95, 'G4_2', 'Fruits'),
(96, 'G4_2', 'Fruits'),
(97, 'G4_2', 'Nuts & Seeds'),
(98, 'G4_2', 'Nuts & Seeds'),
(99, 'G4_2', 'Nuts & Seeds'),
(100, 'G4_2', 'Nuts & Seeds'),
(101, 'G4_2', 'Nuts & Seeds'),
(102, 'G4_2', 'Nuts & Seeds'),
(103, 'G4_2', 'Vegetables'),
(104, 'G4_2', 'Miscellaneous'),
(105, 'G4_2', 'Seafood'),
(106, 'G4_3', 'Seafood'),
(107, 'G4_3', 'Seafood'),
(108, 'G4_3', 'Beans'),
(109, 'G4_3', 'Seafood'),
(110, 'G4_3', 'Seafood'),
(111, 'G4_3', 'Seafood'),
(112, 'G4_3', 'Poultry'),
(113, 'G4_3', 'Poultry'),
(114, 'G4_3', 'Poultry'),
(115, 'G4_3', 'Gluten-Containing Grains'),
(116, 'G4_3', 'Gluten-Free Grains'),
(117, 'G4_3', 'Gluten-Containing Grains'),
(118, 'G4_3', 'Gluten-Containing Grains'),
(119, 'G4_3', 'Gluten-Free Grains'),
(120, 'G4_3', 'Gluten-Free Grains'),
(121, 'G4_3', 'Gluten-Containing Grains'),
(122, 'G4_3', 'Vegetables'),
(123, 'G4_3', 'Vegetables'),
(124, 'G4_3', 'Vegetables'),
(125, 'G4_3', 'Vegetables'),
(126, 'G4_3', 'Beans'),
(127, 'G4_3', 'Beans'),
(128, 'G4_3', 'Beans'),
(129, 'G4_3', 'Milk & Other Dairy'),
(130, 'G4_3', 'Milk & Other Dairy'),
(131, 'G4_3', 'Milk & Other Dairy'),
(132, 'G4_3', 'Fruits'),
(133, 'G4_3', 'Fruits'),
(134, 'G4_3', 'Fruits'),
(135, 'G4_3', 'Fruits'),
(136, 'G4_3', 'Fruits'),
(137, 'G4_3', 'Nuts & Seeds'),
(138, 'G4_3', 'Nuts & Seeds'),
(139, 'G4_3', 'Miscellaneous'),
(140, 'G4_3', 'Herbs & Spices'),
(141, 'G4_3', 'Herbs & Spices'),
(142, 'G4_3', 'Miscellaneous'),
(143, 'G4_3', 'Miscellaneous'),
(144, 'G4_3', 'Vegetables'),
(145, 'G4_3', 'Gluten-Free Grains'),
(186, 'G4_4', 'Seafood'),
(187, 'G4_4', 'Seafood'),
(188, 'G4_4', 'Seafood'),
(189, 'G4_4', 'Seafood'),
(190, 'G4_4', 'Seafood'),
(191, 'G4_4', 'Seafood'),
(192, 'G4_4', 'Meats'),
(193, 'G4_4', 'Meats'),
(194, 'G4_4', 'Vegetables'),
(195, 'G4_4', 'Vegetables'),
(196, 'G4_4', 'Vegetables'),
(197, 'G4_4', 'Beans'),
(198, 'G4_4', 'Fruits'),
(199, 'G4_4', 'Vegetables'),
(200, 'G4_4', 'Vegetables'),
(201, 'G4_4', 'Vegetables'),
(202, 'G4_4', 'Vegetables'),
(203, 'G4_4', 'Vegetables'),
(204, 'G4_4', 'Vegetables'),
(205, 'G4_4', 'Vegetables'),
(206, 'G4_4', 'Milk & Other Dairy'),
(207, 'G4_4', 'Cheeses'),
(208, 'G4_4', 'Cheeses'),
(209, 'G4_4', 'Cheeses'),
(210, 'G4_4', 'Cheeses'),
(211, 'G4_4', 'Cheeses'),
(212, 'G4_4', 'Cheeses'),
(213, 'G4_4', 'Cheeses'),
(214, 'G4_4', 'Cheeses'),
(215, 'G4_4', 'Fruits'),
(216, 'G4_4', 'Fruits'),
(217, 'G4_4', 'Fruits'),
(218, 'G4_4', 'Fruits'),
(219, 'G4_4', 'Fruits'),
(220, 'G4_4', 'Fruits'),
(221, 'G4_4', 'Fruits'),
(222, 'G4_4', 'Fruits'),
(223, 'G4_4', 'Herbs & Spices'),
(224, 'G4_4', 'Herbs & Spices'),
(225, 'G4_4', 'Herbs & Spices'),
(266, 'G4_6', 'Seafood'),
(267, 'G4_6', 'Seafood'),
(269, 'G4_6', 'Seafood'),
(270, 'G4_6', 'Seafood'),
(271, 'G4_6', 'Poultry'),
(272, 'G4_6', 'Fruits'),
(273, 'G4_6', 'Vegetables'),
(274, 'G4_6', 'Vegetables'),
(275, 'G4_6', 'Vegetables'),
(276, 'G4_6', 'Vegetables'),
(277, 'G4_6', 'Vegetables'),
(278, 'G4_6', 'Vegetables'),
(279, 'G4_6', 'Vegetables'),
(280, 'G4_6', 'Fruits'),
(281, 'G4_6', 'Fruits'),
(282, 'G4_6', 'Fruits'),
(283, 'G4_6', 'Fruits'),
(284, 'G4_6', 'Fruits'),
(285, 'G4_6', 'Fruits'),
(286, 'G4_6', 'Fruits'),
(287, 'G4_6', 'Fruits'),
(288, 'G4_6', 'Miscellaneous'),
(289, 'G4_6', 'Gluten-Containing Grains'),
(290, 'G4_6', 'Milk & Other Dairy'),
(291, 'G4_6', 'Herbs & Spices'),
(292, 'G4_6', 'Herbs & Spices'),
(293, 'G4_6', 'Herbs & Spices'),
(294, 'G4_6', 'Herbs & Spices'),
(295, 'G4_6', 'Herbs & Spices'),
(296, 'G4_6', 'Herbs & Spices'),
(297, 'G4_6', 'Herbs & Spices'),
(298, 'G4_6', 'Herbs & Spices'),
(299, 'G4_6', 'Herbs & Spices'),
(300, 'G4_6', 'Herbs & Spices'),
(301, 'G4_6', 'Herbs & Spices'),
(302, 'G4_6', 'Herbs & Spices'),
(303, 'G4_6', 'Milk & Other Dairy'),
(304, 'G4_6', 'Gluten-Free Grains'),
(305, 'G4_6', 'Gluten-Containing Grains'),
(306, 'G4_7', 'Seafood'),
(307, 'G4_7', 'Seafood'),
(308, 'G4_7', 'Seafood'),
(309, 'G4_7', 'Seafood'),
(310, 'G4_7', 'Seafood'),
(311, 'G4_7', 'Seafood'),
(312, 'G4_7', 'Seafood'),
(313, 'G4_7', 'Meats'),
(314, 'G4_7', 'Meats'),
(315, 'G4_7', 'Poultry'),
(316, 'G4_7', 'Poultry'),
(317, 'G4_7', 'Beans'),
(318, 'G4_7', 'Miscellaneous'),
(319, 'G4_7', 'Fruits'),
(320, 'G4_7', 'Vegetables'),
(321, 'G4_7', 'Vegetables'),
(322, 'G4_7', 'Vegetables'),
(323, 'G4_7', 'Vegetables'),
(324, 'G4_7', 'Vegetables'),
(325, 'G4_7', 'Herbs & Spices'),
(326, 'G4_7', 'Herbs & Spices'),
(327, 'G4_7', 'Vegetables'),
(328, 'G4_7', 'Vegetables'),
(329, 'G4_7', 'Fruits'),
(330, 'G4_7', 'Miscellaneous'),
(331, 'G4_7', 'Miscellaneous'),
(332, 'G4_7', 'Miscellaneous'),
(333, 'G4_7', 'Beans'),
(334, 'G4_7', 'Miscellaneous'),
(335, 'G4_7', 'Miscellaneous'),
(336, 'G4_7', 'Vegetables'),
(337, 'G4_7', 'Herbs & Spices'),
(338, 'G4_7', 'Herbs & Spices'),
(339, 'G4_7', 'Herbs & Spices'),
(340, 'G4_7', 'Herbs & Spices'),
(341, 'G4_7', 'Herbs & Spices'),
(342, 'G4_7', 'Milk & Other Dairy'),
(343, 'G4_7', 'Milk & Other Dairy'),
(344, 'G4_7', 'Miscellaneous'),
(345, 'G4_7', 'Gluten-Containing Grains'),
(268, 'G4_6', 'Seafood');

-- populating the allergen_allergen_group table
INSERT INTO allergen_allergen_group (allergen_id,allergen_group_id)
select al.allergen_id, (SELECT allergen_group_id FROM allergen_group ag WHERE al.group_name = ag.allergen_group_name ) as allergen_group_id from a al;
-- populating the allergen_allergen_panel table
INSERT INTO allergen_allergen_panel (allergen_id,allergen_panel_id)
SELECT tmp.allergen_id, (SELECT allergen_panel_id FROM allergen_panel tmp2 WHERE tmp.panelname = tmp2.allergen_panel_name) AS allergen_panel_id FROM bloodsuite.a tmp;

-- drop the table
-- DROP TABLE a;