data.sql

INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Animal foods', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Aquatic foods', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Baby foods', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Baking foods', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Beverages', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cereals and cereal products', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cocoa and cocoa products', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Coffee and coffee products', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Confectioneries', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Dishes', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Eggs', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fats and oils', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fruits', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Gourds', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Herbs and Spices', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Milk and milk products', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Nuts', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Pulses', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Snack foods', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Soy', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Teas', NULL);
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Vegetables', NULL);

INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Alcoholic beverages',(SELECT id FROM foodcategory WHERE name='Beverages'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Amphibians',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Animal fats',(SELECT id FROM foodcategory WHERE name='Fats and oils'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Beans',(SELECT id FROM foodcategory WHERE name='Pulses'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Berries',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Bovines',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Brassicas',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cabbages',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Candies',(SELECT id FROM foodcategory WHERE name='Confectioneries'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Caprae',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cereal products',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cereals',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cetaceans',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Citrus',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cocoa',(SELECT id FROM foodcategory WHERE name='Cocoa and cocoa products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Cocoa products',(SELECT id FROM foodcategory WHERE name='Cocoa and cocoa products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Coffee',(SELECT id FROM foodcategory WHERE name='Coffee and coffee products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Condiments',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Crustaceans',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Desserts',(SELECT id FROM foodcategory WHERE name='Confectioneries'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Distilled beverages',(SELECT id FROM foodcategory WHERE name='Beverages'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Doughs',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Dressings',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Drupes',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Equines',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fermented beverages',(SELECT id FROM foodcategory WHERE name='Beverages'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fermented milk products',(SELECT id FROM foodcategory WHERE name='Milk and milk products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fermented milks',(SELECT id FROM foodcategory WHERE name='Milk and milk products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fish products',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fishes',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Flat breads',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fortified wines',(SELECT id FROM foodcategory WHERE name='Beverages'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Frozen desserts',(SELECT id FROM foodcategory WHERE name='Confectioneries'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fruit products',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Fruit vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Ground meat',(SELECT id FROM foodcategory WHERE name='Dishes'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Herb and spice mixtures',(SELECT id FROM foodcategory WHERE name='Herbs and Spices'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Herbal teas',(SELECT id FROM foodcategory WHERE name='Teas'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Herbs',(SELECT id FROM foodcategory WHERE name='Herbs and Spices'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Lagomorphs',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Leaf vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Leavened breads',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Lentils',(SELECT id FROM foodcategory WHERE name='Pulses'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Marsupials',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Meat products',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Mollusks',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Mushrooms',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Oilseed crops',(SELECT id FROM foodcategory WHERE name='Herbs and Spices'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Onion-family vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other aquatic foods',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other beverages',(SELECT id FROM foodcategory WHERE name='Beverages'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other breads',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other confectioneries',(SELECT id FROM foodcategory WHERE name='Confectioneries'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other dishes',(SELECT id FROM foodcategory WHERE name='Dishes'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other fruits',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other mammals',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other milk products',(SELECT id FROM foodcategory WHERE name='Milk and milk products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other pulses',(SELECT id FROM foodcategory WHERE name='Pulses'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other seeds',(SELECT id FROM foodcategory WHERE name='Herbs and Spices'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Other vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Ovis',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Peas',(SELECT id FROM foodcategory WHERE name='Pulses'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Pinnipeds',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Pomes',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Poultry',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Rodents',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Roe',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Root vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Sauces',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Seasonings',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Seaweed',(SELECT id FROM foodcategory WHERE name='Aquatic foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Shoot vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Soy products',(SELECT id FROM foodcategory WHERE name='Soy'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Spices',(SELECT id FROM foodcategory WHERE name='Herbs and Spices'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Spreads',(SELECT id FROM foodcategory WHERE name='Confectioneries'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Stalk vegetables',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Substitutes',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Sugars',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Sweet breads',(SELECT id FROM foodcategory WHERE name='Cereals and cereal products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Swine',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Tex-Mex cuisine',(SELECT id FROM foodcategory WHERE name='Dishes'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Tropical fruits',(SELECT id FROM foodcategory WHERE name='Fruits'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Tubers',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Unfermented milks',(SELECT id FROM foodcategory WHERE name='Milk and milk products'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Vegetable fats',(SELECT id FROM foodcategory WHERE name='Fats and oils'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Vegetable products',(SELECT id FROM foodcategory WHERE name='Vegetables'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Venison',(SELECT id FROM foodcategory WHERE name='Animal foods'));
INSERT INTO foodcategory (name, parentcategoryid) VALUES ('Waters',(SELECT id FROM foodcategory WHERE name='Beverages'));

INSERT INTO food (name, categoryid) VALUES('Angelica',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Savoy cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Silver linden',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Kiwi',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Allium (Onion)',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Garden onion',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Leek',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Garlic',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Chives',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Lemon verbena',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Cashew nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Pineapple',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Dill',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Custard apple',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Wild celery',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Peanut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Burdock',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Horseradish',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Tarragon',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Mugwort',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Asparagus',(SELECT id FROM foodcategory WHERE name='Shoot vegetables'));
INSERT INTO food (name, categoryid) VALUES('Oat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Star fruit',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Brazil nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Common beet',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Borage',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Chinese mustard',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Swede',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Rape',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Common cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Cauliflower',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Brussel sprouts',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Kohlrabi',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Broccoli',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Chinese cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Turnip',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Pigeon pea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Tea',(SELECT id FROM foodcategory WHERE name='Teas'));
INSERT INTO food (name, categoryid) VALUES('Capers',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Pepper (C. annuum)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Papaya',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Safflower',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Caraway',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Pecan nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Chestnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Roman camomile',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Chickpea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Endive',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Chicory',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Chinese cinnamon',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Ceylon cinnamon',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Watermelon',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Lime',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Lemon',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Pummelo',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Mandarin orange (Clementine, Tangerine)',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Sweet orange',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Coffee',(SELECT id FROM foodcategory WHERE name='Coffee'));
INSERT INTO food (name, categoryid) VALUES('Arabica coffee',(SELECT id FROM foodcategory WHERE name='Coffee'));
INSERT INTO food (name, categoryid) VALUES('Robusta coffee',(SELECT id FROM foodcategory WHERE name='Coffee'));
INSERT INTO food (name, categoryid) VALUES('Coriander',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Common hazelnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Saffron',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Muskmelon',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Cucumber',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Cucurbita (Gourd)',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Cumin',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Turmeric',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Quince',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Lemon grass',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Globe artichoke',(SELECT id FROM foodcategory WHERE name='Shoot vegetables'));
INSERT INTO food (name, categoryid) VALUES('Wild carrot',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Japanese persimmon',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Cardamom',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Black crowberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Loquat',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Rocket salad (ssp.)',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Wax apple',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Common buckwheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Tartary buckwheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Fig',(SELECT id FROM foodcategory WHERE name='Other fruits'));
INSERT INTO food (name, categoryid) VALUES('Fennel',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Strawberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Black huckleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Soy bean',(SELECT id FROM foodcategory WHERE name='Soy'));
INSERT INTO food (name, categoryid) VALUES('Sunflower',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Sea-buckthornberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Barley',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Hyssop',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Star anise',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Swamp cabbage',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Sweet potato',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Black walnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Common walnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Lettuce',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Grass pea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Sweet bay',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Lentils',(SELECT id FROM foodcategory WHERE name='Lentils'));
INSERT INTO food (name, categoryid) VALUES('Garden cress',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Lovage',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Flaxseed',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Mexican oregano',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Lichee',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Lupine',(SELECT id FROM foodcategory WHERE name='Other pulses'));
INSERT INTO food (name, categoryid) VALUES('Apple',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Mango',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('German camomile',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Lemon balm',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Mentha (Mint)',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Orange mint',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Cornmint',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Spearmint',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Peppermint',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Medlar',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Bitter gourd',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Mulberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Black mulberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Nutmeg',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Sweet basil',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Evening primrose',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Olive',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Sweet marjoram',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Pot marjoram',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Common oregano',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Rice',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Millet',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Poppy',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Passion fruit',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Parsnip',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Avocado',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Parsley',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Scarlet bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Lima bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Common bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Date',(SELECT id FROM foodcategory WHERE name='Other fruits'));
INSERT INTO food (name, categoryid) VALUES('Black chokeberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Anise',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Pine nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Pepper (Spice)',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Pistachio',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Common pea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Purslane',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Prunus (Cherry, Plum)',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Apricot',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Sweet cherry',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Sour cherry',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('European plum',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Almond',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Peach',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Guava',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pomegranate',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pear',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Radish',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Garden rhubarb',(SELECT id FROM foodcategory WHERE name='Stalk vegetables'));
INSERT INTO food (name, categoryid) VALUES('Blackcurrant',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Redcurrant',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Gooseberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Watercress',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Rosemary',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Rubus (Blackberry, Raspberry)',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Cloudberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Red raspberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Black raspberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Sorrel',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Common sage',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Black elderberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Summer savory',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Winter savory',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Rye',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Sesame',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Garden tomato',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Cherry tomato',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Garden tomato (var.)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Eggplant',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Potato',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Rowanberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Sorghum',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Spinach',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Cloves',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Tamarind',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Dandelion',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Cocoa bean',(SELECT id FROM foodcategory WHERE name='Cocoa'));
INSERT INTO food (name, categoryid) VALUES('Common thyme',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Linden',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Small-leaf linden',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Fenugreek',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Common wheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Vaccinium (Blueberry, Cranberry, Huckleberry)',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Lowbush blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Sparkleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Highbush blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('American cranberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Bilberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Lingonberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Vanilla',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Common verbena',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Broad bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Adzuki bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Gram bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Mung bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Climbing bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Cowpea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Muscadine grape',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Common grape',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Corn',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Ginger',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Arctic blackberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Banana',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Bayberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Elliotts blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Canada blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Bog bilberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Buffalo currant',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Celeriac',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Celery stalks',(SELECT id FROM foodcategory WHERE name='Stalk vegetables'));
INSERT INTO food (name, categoryid) VALUES('Chinese chives',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('European cranberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Deerberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Ginseng',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Cascade huckleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Oval-leaf huckleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Evergreen huckleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Red huckleberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Longan',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Macadamia nut (M. tetraphylla)',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Garden onion (var.)',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Summer grape',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Fox grape',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Nectarine',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Peach (var.)',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Pepper (C. baccatum)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Pepper (C. chinense)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Pepper (Capsicum)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Rambutan',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Red rice',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Annual wild rice',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Swiss chard',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Lemon thyme',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Tronchuda cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Japanese walnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Welsh onion',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Hard wheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Shallot',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Rocket salad',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Carrot',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Triticale',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Black cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Half-highbush blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Celery leaves',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Chicory leaves',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Komatsuna',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Pak choy',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Napa cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Chicory roots',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Grapefruit/Pummelo hybrid',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Grapefruit',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Jostaberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Kai-lan',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Italian oregano',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Oxheart cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Daikon radish',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Black radish',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Radish (var.)',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Red beetroot',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Sweet rowanberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Pineappple sage',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Skunk currant',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Beer',(SELECT id FROM foodcategory WHERE name='Fermented beverages'));
INSERT INTO food (name, categoryid) VALUES('Other bread',(SELECT id FROM foodcategory WHERE name='Other breads'));
INSERT INTO food (name, categoryid) VALUES('Breakfast cereal',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Other soy product',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Other cereal product',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Pasta',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Biscuit',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Sourdough',(SELECT id FROM foodcategory WHERE name='Doughs'));
INSERT INTO food (name, categoryid) VALUES('Spirit',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Fortified wine',(SELECT id FROM foodcategory WHERE name='Fortified wines'));
INSERT INTO food (name, categoryid) VALUES('Other alcoholic beverage',(SELECT id FROM foodcategory WHERE name='Alcoholic beverages'));
INSERT INTO food (name, categoryid) VALUES('Abalone',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Abiyuch',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Acerola',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Acorn',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Winter squash',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Agar',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Red king crab',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Alfalfa',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Allspice',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Amaranth',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Arrowhead',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Arrowroot',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Asian pear',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic herring',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic mackerel',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Painted comber',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic pollock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic wolffish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Bamboo shoots',(SELECT id FROM foodcategory WHERE name='Shoot vegetables'));
INSERT INTO food (name, categoryid) VALUES('Striped bass',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Beaver',(SELECT id FROM foodcategory WHERE name='Rodents'));
INSERT INTO food (name, categoryid) VALUES('Beech nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Beluga whale',(SELECT id FROM foodcategory WHERE name='Cetaceans'));
INSERT INTO food (name, categoryid) VALUES('Bison',(SELECT id FROM foodcategory WHERE name='Bovines'));
INSERT INTO food (name, categoryid) VALUES('Black bear',(SELECT id FROM foodcategory WHERE name='Other mammals'));
INSERT INTO food (name, categoryid) VALUES('Alaska blackfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Blue crab',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Blue mussel',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Northern bluefin tuna',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Bluefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Wild boar',(SELECT id FROM foodcategory WHERE name='Swine'));
INSERT INTO food (name, categoryid) VALUES('Bowhead whale',(SELECT id FROM foodcategory WHERE name='Cetaceans'));
INSERT INTO food (name, categoryid) VALUES('Breadfruit',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Breadnut tree seed',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Rapini',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Brown bear',(SELECT id FROM foodcategory WHERE name='Other mammals'));
INSERT INTO food (name, categoryid) VALUES('Buffalo',(SELECT id FROM foodcategory WHERE name='Bovines'));
INSERT INTO food (name, categoryid) VALUES('Burbot',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Giant butterbur',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('American butterfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Butternut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Butternut squash',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Calabash',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Cardoon',(SELECT id FROM foodcategory WHERE name='Shoot vegetables'));
INSERT INTO food (name, categoryid) VALUES('Caribou',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Natal plum',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Carob',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Common carp',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Cassava',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Channel catfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Chayote',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Cherimoya',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Chervil',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Chia',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Chicken (Cock, Hen, Rooster)',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Chinese broccoli',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Chinese chestnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Chinese water chestnut',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Garland chrysanthemum',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Cisco',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Nuttall cockle',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Coconut',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pacific cod',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic cod',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Common octopus',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Corn salad',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Cottonseed',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Catjang pea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Malus (Crab apple)',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Squashberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Atlantic croaker',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Cusk',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Cuttlefish',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Mule deer',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Devilfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Dock',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Dolphin fish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Freshwater drum',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Mallard duck',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Dungeness crab',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Durian',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Eastern oyster',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Freshwater eel',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Elderberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Elk',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Emu',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Oregon yampah',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('European anchovy',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('European chestnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Turbot',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Fireweed',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Florida pompano',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Ginkgo nuts',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Greylag goose',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Grape',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Greenland halibut/turbot',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Groundcherry',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Grouper',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Guinea hen',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Haddock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Hippoglossus (Common halibut)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Hazelnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Hickory nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Horse',(SELECT id FROM foodcategory WHERE name='Equines'));
INSERT INTO food (name, categoryid) VALUES('Horseradish tree',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Alaska blueberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Hyacinth bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Irish moss',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Pacific jack mackerel',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Jackfruit',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Japanese chestnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Java plum',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Jerusalem artichoke',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Jujube',(SELECT id FROM foodcategory WHERE name='Other fruits'));
INSERT INTO food (name, categoryid) VALUES('Jute',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Kale',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Kelp',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('King mackerel',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Kumquat',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Lambsquarters',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Leather chiton',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Wild leek',(SELECT id FROM foodcategory WHERE name='Onion-family vegetables'));
INSERT INTO food (name, categoryid) VALUES('Common ling',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Lingcod',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('American lobster',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Loganberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Lotus',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Sacred lotus',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('White lupine',(SELECT id FROM foodcategory WHERE name='Other pulses'));
INSERT INTO food (name, categoryid) VALUES('Malabar spinach',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Mammee apple',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Purple mangosteen',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Alpine sweetvetch',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Milkfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Monkfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Moose',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Moth bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Mountain yam',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Striped mullet',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Muskrat',(SELECT id FROM foodcategory WHERE name='Rodents'));
INSERT INTO food (name, categoryid) VALUES('White mustard',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Mustard spinach',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('New Zealand spinach',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Nopal',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Ocean pout',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('North Pacific giant octopus',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Ohelo berry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Okra',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Tunicate',(SELECT id FROM foodcategory WHERE name='Other aquatic foods'));
INSERT INTO food (name, categoryid) VALUES('Opossum',(SELECT id FROM foodcategory WHERE name='Marsupials'));
INSERT INTO food (name, categoryid) VALUES('Ostrich',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Spotted seal',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Pacific herring',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pacific oyster',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Pacific rockfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Velvet duck',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Pepper (C. frutescens)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Common persimmon',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pheasant',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Northern pike',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pili nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Colorado pinyon',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Pitanga',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Plains prickly pear',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('French plantain',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('American pokeweed',(SELECT id FROM foodcategory WHERE name='Shoot vegetables'));
INSERT INTO food (name, categoryid) VALUES('Polar bear',(SELECT id FROM foodcategory WHERE name='Other mammals'));
INSERT INTO food (name, categoryid) VALUES('Opium poppy',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Prairie turnip',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Prickly pear',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Quinoa',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('European rabbit',(SELECT id FROM foodcategory WHERE name='Lagomorphs'));
INSERT INTO food (name, categoryid) VALUES('Raccoon',(SELECT id FROM foodcategory WHERE name='Other mammals'));
INSERT INTO food (name, categoryid) VALUES('Rainbow smelt',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Rainbow trout',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Malabar plum',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Rose hip',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Roselle',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Orange roughy',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sablefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pink salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Chum salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Coho salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sockeye salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Chinook salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Salmonberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Common salsify',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Sapodilla',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Mamey sapote',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Spanish mackerel',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pacific sardine',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Scallop',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Scup',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sea cucumber',(SELECT id FROM foodcategory WHERE name='Other aquatic foods'));
INSERT INTO food (name, categoryid) VALUES('Steller sea lion',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Bearded seal',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Ringed seal',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Seatrout',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sesbania flower',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('American shad',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Shark',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sheefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sheep (Mutton, Lamb)',(SELECT id FROM foodcategory WHERE name='Ovis'));
INSERT INTO food (name, categoryid) VALUES('Sheepshead',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Hedge mustard',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Skipjack tuna',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Snapper',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Soursop',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Spelt',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Spirulina',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Squab',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Squirrel',(SELECT id FROM foodcategory WHERE name='Rodents'));
INSERT INTO food (name, categoryid) VALUES('Strawberry guava',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Greater sturgeon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('White sucker',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sugar apple',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pumpkinseed sunfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Swordfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Taro',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Teff',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Tilefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Mexican groundcherry',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Towel gourd',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Salmonidae (Salmon, Trout)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Turkey',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Cattle (Beef, Veal)',(SELECT id FROM foodcategory WHERE name='Bovines'));
INSERT INTO food (name, categoryid) VALUES('Walleye',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Alaska pollock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Wasabi',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Wax gourd',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Whelk',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Coalfish pollock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Broad whitefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Whitefish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Whiting',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Wild rice',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Tea leaf willow',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Winged bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Yam',(SELECT id FROM foodcategory WHERE name='Tubers'));
INSERT INTO food (name, categoryid) VALUES('Jicama',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Yautia',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Yellowfin tuna',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Yellowtail amberjack',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pollock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Albacore tuna',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Gadus (Common cod)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Atlantic halibut',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pacific halibut',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pacific salmon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Smelt',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Clupeinae (Herring, Sardine, Sprat)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Spiny lobster',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Snow crab',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Black-eyed pea',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Deer',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Macadamia nut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Percoidei (Bass and others)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Perciformes (Perch-like fishes)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Arctic ground squirrel',(SELECT id FROM foodcategory WHERE name='Rodents'));
INSERT INTO food (name, categoryid) VALUES('Rabbit',(SELECT id FROM foodcategory WHERE name='Lagomorphs'));
INSERT INTO food (name, categoryid) VALUES('Domestic goat',(SELECT id FROM foodcategory WHERE name='Caprae'));
INSERT INTO food (name, categoryid) VALUES('Beefalo',(SELECT id FROM foodcategory WHERE name='Bovines'));
INSERT INTO food (name, categoryid) VALUES('Antelope',(SELECT id FROM foodcategory WHERE name='Venison'));
INSERT INTO food (name, categoryid) VALUES('Bivalvia (Clam, Mussel, Oyster)',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Squid',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Shrimp',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Crayfish',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Flatfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Domestic pig (Piglet, Pork)',(SELECT id FROM foodcategory WHERE name='Swine'));
INSERT INTO food (name, categoryid) VALUES('Walrus',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Alaska wild rhubarb',(SELECT id FROM foodcategory WHERE name='Stalk vegetables'));
INSERT INTO food (name, categoryid) VALUES('Oriental wheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Yardlong bean',(SELECT id FROM foodcategory WHERE name='Peas'));
INSERT INTO food (name, categoryid) VALUES('Great horned owl',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Quail',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Boysenberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Persian lime',(SELECT id FROM foodcategory WHERE name='Citrus'));
INSERT INTO food (name, categoryid) VALUES('Feijoa',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Rowal',(SELECT id FROM foodcategory WHERE name='Other seeds'));
INSERT INTO food (name, categoryid) VALUES('Jews ear',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Common mushroom',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Shiitake',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Purple laver',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Wakame',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Enokitake',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Epazote',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Oyster mushroom',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Cloud ear fungus',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Maitake',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Ostrich fern',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Spot croaker',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Sourdock',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Tinda',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Atlantic menhaden',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Wheat',(SELECT id FROM foodcategory WHERE name='Cereals'));
INSERT INTO food (name, categoryid) VALUES('Common chokecherry',(SELECT id FROM foodcategory WHERE name='Drupes'));
INSERT INTO food (name, categoryid) VALUES('Agave',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Narrowleaf cattail',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Jellyfish',(SELECT id FROM foodcategory WHERE name='Other aquatic foods'));
INSERT INTO food (name, categoryid) VALUES('Anchovy',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Blue whiting',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Carp bream',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Chanterelle',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Sturgeon',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Charr',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Cinnamon',(SELECT id FROM foodcategory WHERE name='Spices'));
INSERT INTO food (name, categoryid) VALUES('Crab',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Common dab',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Spiny dogfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Anatidae (Duck, Goose, Swan)',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Anguilliformes (Eel)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('True frog',(SELECT id FROM foodcategory WHERE name='Amphibians'));
INSERT INTO food (name, categoryid) VALUES('Garfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Gadiformes (Cod, Hake)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Mountain hare',(SELECT id FROM foodcategory WHERE name='Lagomorphs'));
INSERT INTO food (name, categoryid) VALUES('Lake trout',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Lemon sole',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Clawed lobster',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Lumpsucker',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Scombridae (Bonito, Mackerel, Tuna)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Marine mussel',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Norway haddock',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Norway lobster',(SELECT id FROM foodcategory WHERE name='Crustaceans'));
INSERT INTO food (name, categoryid) VALUES('Norway pout',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Oil palm',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('True oyster',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Sago palm',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Persimmon',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Pikeperch',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Pleuronectidae (Dab, Halibut, Plaice)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Rock ptarmigan',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Pacific ocean perch',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Black salsify',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('True seal',(SELECT id FROM foodcategory WHERE name='Pinnipeds'));
INSERT INTO food (name, categoryid) VALUES('Red algae',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Kombu',(SELECT id FROM foodcategory WHERE name='Seaweed'));
INSERT INTO food (name, categoryid) VALUES('Snail',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('True sole',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Catfish',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Thistle',(SELECT id FROM foodcategory WHERE name='Root vegetables'));
INSERT INTO food (name, categoryid) VALUES('Thunnus (Common tuna)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Walnut',(SELECT id FROM foodcategory WHERE name='Nuts'));
INSERT INTO food (name, categoryid) VALUES('Cetacea (Dolphin, Porpoise, Whale)',(SELECT id FROM foodcategory WHERE name='Cetaceans'));
INSERT INTO food (name, categoryid) VALUES('Columbidae (Dove, Pigeon)',(SELECT id FROM foodcategory WHERE name='Poultry'));
INSERT INTO food (name, categoryid) VALUES('Conch',(SELECT id FROM foodcategory WHERE name='Mollusks'));
INSERT INTO food (name, categoryid) VALUES('Grape wine',(SELECT id FROM foodcategory WHERE name='Fermented beverages'));
INSERT INTO food (name, categoryid) VALUES('Berry wine',(SELECT id FROM foodcategory WHERE name='Fermented beverages'));
INSERT INTO food (name, categoryid) VALUES('Other wine',(SELECT id FROM foodcategory WHERE name='Fermented beverages'));
INSERT INTO food (name, categoryid) VALUES('Apple cider',(SELECT id FROM foodcategory WHERE name='Fermented beverages'));
INSERT INTO food (name, categoryid) VALUES('Liquor',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Cheese',(SELECT id FROM foodcategory WHERE name='Fermented milk products'));
INSERT INTO food (name, categoryid) VALUES('Milk (Cow)',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Eggs',(SELECT id FROM foodcategory WHERE name='Eggs'));
INSERT INTO food (name, categoryid) VALUES('Yogurt',(SELECT id FROM foodcategory WHERE name='Fermented milk products'));
INSERT INTO food (name, categoryid) VALUES('Bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Vodka',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Whisky',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Ice cream',(SELECT id FROM foodcategory WHERE name='Frozen desserts'));
INSERT INTO food (name, categoryid) VALUES('Gin',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Honey',(SELECT id FROM foodcategory WHERE name='Other confectioneries'));
INSERT INTO food (name, categoryid) VALUES('Liquorice',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Vinegar',(SELECT id FROM foodcategory WHERE name='Seasonings'));
INSERT INTO food (name, categoryid) VALUES('Rum',(SELECT id FROM foodcategory WHERE name='Distilled beverages'));
INSERT INTO food (name, categoryid) VALUES('Port wine',(SELECT id FROM foodcategory WHERE name='Fortified wines'));
INSERT INTO food (name, categoryid) VALUES('Vermouth',(SELECT id FROM foodcategory WHERE name='Fortified wines'));
INSERT INTO food (name, categoryid) VALUES('Sherry',(SELECT id FROM foodcategory WHERE name='Fortified wines'));
INSERT INTO food (name, categoryid) VALUES('Madeira wine',(SELECT id FROM foodcategory WHERE name='Fortified wines'));
INSERT INTO food (name, categoryid) VALUES('Nougat',(SELECT id FROM foodcategory WHERE name='Other confectioneries'));
INSERT INTO food (name, categoryid) VALUES('Toffee',(SELECT id FROM foodcategory WHERE name='Other confectioneries'));
INSERT INTO food (name, categoryid) VALUES('Cake',(SELECT id FROM foodcategory WHERE name='Desserts'));
INSERT INTO food (name, categoryid) VALUES('Pizza',(SELECT id FROM foodcategory WHERE name='Other dishes'));
INSERT INTO food (name, categoryid) VALUES('Ymer',(SELECT id FROM foodcategory WHERE name='Fermented milk products'));
INSERT INTO food (name, categoryid) VALUES('Other snack food',(SELECT id FROM foodcategory WHERE name='Snack foods'));
INSERT INTO food (name, categoryid) VALUES('Crisp bread',(SELECT id FROM foodcategory WHERE name='Flat breads'));
INSERT INTO food (name, categoryid) VALUES('Pastry',(SELECT id FROM foodcategory WHERE name='Desserts'));
INSERT INTO food (name, categoryid) VALUES('Dragée',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Chewing gum',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Marzipan',(SELECT id FROM foodcategory WHERE name='Other confectioneries'));
INSERT INTO food (name, categoryid) VALUES('Salad dressing',(SELECT id FROM foodcategory WHERE name='Dressings'));
INSERT INTO food (name, categoryid) VALUES('Sauce',(SELECT id FROM foodcategory WHERE name='Sauces'));
INSERT INTO food (name, categoryid) VALUES('Salt',(SELECT id FROM foodcategory WHERE name='Seasonings'));
INSERT INTO food (name, categoryid) VALUES('Butter',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Butter substitute',(SELECT id FROM foodcategory WHERE name='Substitutes'));
INSERT INTO food (name, categoryid) VALUES('Cream',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Sugar',(SELECT id FROM foodcategory WHERE name='Sugars'));
INSERT INTO food (name, categoryid) VALUES('Sausage',(SELECT id FROM foodcategory WHERE name='Ground meat'));
INSERT INTO food (name, categoryid) VALUES('Meatball',(SELECT id FROM foodcategory WHERE name='Ground meat'));
INSERT INTO food (name, categoryid) VALUES('Mustard',(SELECT id FROM foodcategory WHERE name='Condiments'));
INSERT INTO food (name, categoryid) VALUES('Pate',(SELECT id FROM foodcategory WHERE name='Ground meat'));
INSERT INTO food (name, categoryid) VALUES('Sugar substitute',(SELECT id FROM foodcategory WHERE name='Substitutes'));
INSERT INTO food (name, categoryid) VALUES('Meat bouillon',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO food (name, categoryid) VALUES('Other meat product',(SELECT id FROM foodcategory WHERE name='Meat products'));
INSERT INTO food (name, categoryid) VALUES('Whey',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Casein',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Fruit preserve',(SELECT id FROM foodcategory WHERE name='Fruit products'));
INSERT INTO food (name, categoryid) VALUES('Leavening agent',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO food (name, categoryid) VALUES('Marshmallow',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Gelatin',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO food (name, categoryid) VALUES('Water',(SELECT id FROM foodcategory WHERE name='Waters'));
INSERT INTO food (name, categoryid) VALUES('Other fish product',(SELECT id FROM foodcategory WHERE name='Fish products'));
INSERT INTO food (name, categoryid) VALUES('Milk (Human)',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Other beverage',(SELECT id FROM foodcategory WHERE name='Other beverages'));
INSERT INTO food (name, categoryid) VALUES('Baby food',(SELECT id FROM foodcategory WHERE name='Baby foods'));
INSERT INTO food (name, categoryid) VALUES('Dumpling',(SELECT id FROM foodcategory WHERE name='Other dishes'));
INSERT INTO food (name, categoryid) VALUES('Soup',(SELECT id FROM foodcategory WHERE name='Other dishes'));
INSERT INTO food (name, categoryid) VALUES('Other vegetable product',(SELECT id FROM foodcategory WHERE name='Vegetable products'));
INSERT INTO food (name, categoryid) VALUES('Syrup',(SELECT id FROM foodcategory WHERE name='Baking foods'));
INSERT INTO food (name, categoryid) VALUES('Tallow',(SELECT id FROM foodcategory WHERE name='Animal fats'));
INSERT INTO food (name, categoryid) VALUES('Remoulade',(SELECT id FROM foodcategory WHERE name='Condiments'));
INSERT INTO food (name, categoryid) VALUES('Chocolate spread',(SELECT id FROM foodcategory WHERE name='Spreads'));
INSERT INTO food (name, categoryid) VALUES('Fruit gum',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Curry powder',(SELECT id FROM foodcategory WHERE name='Herb and spice mixtures'));
INSERT INTO food (name, categoryid) VALUES('Other candy',(SELECT id FROM foodcategory WHERE name='Candies'));
INSERT INTO food (name, categoryid) VALUES('Meringue',(SELECT id FROM foodcategory WHERE name='Other confectioneries'));
INSERT INTO food (name, categoryid) VALUES('Lard',(SELECT id FROM foodcategory WHERE name='Animal fats'));
INSERT INTO food (name, categoryid) VALUES('Cocoa butter',(SELECT id FROM foodcategory WHERE name='Cocoa products'));
INSERT INTO food (name, categoryid) VALUES('Cocoa powder',(SELECT id FROM foodcategory WHERE name='Cocoa products'));
INSERT INTO food (name, categoryid) VALUES('Cocoa liquor',(SELECT id FROM foodcategory WHERE name='Cocoa products'));
INSERT INTO food (name, categoryid) VALUES('Chocolate',(SELECT id FROM foodcategory WHERE name='Cocoa products'));
INSERT INTO food (name, categoryid) VALUES('Hot chocolate',(SELECT id FROM foodcategory WHERE name='Cocoa products'));
INSERT INTO food (name, categoryid) VALUES('Dried milk',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Milk (Other mammals)',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Kefir',(SELECT id FROM foodcategory WHERE name='Fermented milks'));
INSERT INTO food (name, categoryid) VALUES('Buttermilk',(SELECT id FROM foodcategory WHERE name='Fermented milks'));
INSERT INTO food (name, categoryid) VALUES('Other fermented milk',(SELECT id FROM foodcategory WHERE name='Fermented milks'));
INSERT INTO food (name, categoryid) VALUES('Soy sauce',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Miso',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Tofu',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Zwieback',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Roe',(SELECT id FROM foodcategory WHERE name='Roe'));
INSERT INTO food (name, categoryid) VALUES('Tilapia (Cichlidae)',(SELECT id FROM foodcategory WHERE name='Fishes'));
INSERT INTO food (name, categoryid) VALUES('Nachos',(SELECT id FROM foodcategory WHERE name='Tex-Mex cuisine'));
INSERT INTO food (name, categoryid) VALUES('Processed cheese',(SELECT id FROM foodcategory WHERE name='Fermented milk products'));
INSERT INTO food (name, categoryid) VALUES('Hibiscus tea',(SELECT id FROM foodcategory WHERE name='Herbal teas'));
INSERT INTO food (name, categoryid) VALUES('Soy milk',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Semolina',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Butterfat',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Horned melon',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Canola',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Babassu palm',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Cupuaçu',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Shea tree',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Oil-seed Camellia',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Ucuhuba',(SELECT id FROM foodcategory WHERE name='Oilseed crops'));
INSERT INTO food (name, categoryid) VALUES('Shortening',(SELECT id FROM foodcategory WHERE name='Vegetable fats'));
INSERT INTO food (name, categoryid) VALUES('Soy cream',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Nance',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Naranjilla',(SELECT id FROM foodcategory WHERE name='Tropical fruits'));
INSERT INTO food (name, categoryid) VALUES('Natto',(SELECT id FROM foodcategory WHERE name='Soy products'));
INSERT INTO food (name, categoryid) VALUES('Tree fern',(SELECT id FROM foodcategory WHERE name='Other vegetables'));
INSERT INTO food (name, categoryid) VALUES('Evaporated milk',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Flour',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Wheat bread',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Rye bread',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Oat bread',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Potato bread',(SELECT id FROM foodcategory WHERE name='Other breads'));
INSERT INTO food (name, categoryid) VALUES('Cornbread',(SELECT id FROM foodcategory WHERE name='Flat breads'));
INSERT INTO food (name, categoryid) VALUES('Corn grits',(SELECT id FROM foodcategory WHERE name='Cereal products'));
INSERT INTO food (name, categoryid) VALUES('Multigrain bread',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Rice bread',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Pan dulce',(SELECT id FROM foodcategory WHERE name='Leavened breads'));
INSERT INTO food (name, categoryid) VALUES('Raisin bread',(SELECT id FROM foodcategory WHERE name='Sweet breads'));
INSERT INTO food (name, categoryid) VALUES('Yellow pond-lily',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Condensed milk',(SELECT id FROM foodcategory WHERE name='Other milk products'));
INSERT INTO food (name, categoryid) VALUES('Margarine',(SELECT id FROM foodcategory WHERE name='Vegetable fats'));
INSERT INTO food (name, categoryid) VALUES('Pepper (C. pubescens)',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Soft-necked garlic',(SELECT id FROM foodcategory WHERE name='Herbs'));
INSERT INTO food (name, categoryid) VALUES('Cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Chinese bayberry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Mushrooms',(SELECT id FROM foodcategory WHERE name='Mushrooms'));
INSERT INTO food (name, categoryid) VALUES('Pomes',(SELECT id FROM foodcategory WHERE name='Pomes'));
INSERT INTO food (name, categoryid) VALUES('Brassicas',(SELECT id FROM foodcategory WHERE name='Brassicas'));
INSERT INTO food (name, categoryid) VALUES('Sunburst squash (pattypan squash)',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Green zucchini',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Yellow zucchini',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('Green bell pepper',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Yellow bell pepper',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Orange bell pepper',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Red bell pepper',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Italian sweet red pepper',(SELECT id FROM foodcategory WHERE name='Fruit vegetables'));
INSERT INTO food (name, categoryid) VALUES('Yellow wax bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Green bean',(SELECT id FROM foodcategory WHERE name='Beans'));
INSERT INTO food (name, categoryid) VALUES('Saskatoon berry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Nanking cherry',(SELECT id FROM foodcategory WHERE name='Berries'));
INSERT INTO food (name, categoryid) VALUES('Japanese pumpkin',(SELECT id FROM foodcategory WHERE name='Gourds'));
INSERT INTO food (name, categoryid) VALUES('White cabbage',(SELECT id FROM foodcategory WHERE name='Cabbages'));
INSERT INTO food (name, categoryid) VALUES('Romaine lettuce',(SELECT id FROM foodcategory WHERE name='Leaf vegetables'));
INSERT INTO food (name, categoryid) VALUES('Cow milk, pasteurized, vitamin A + D added, 0% fat',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Cow milk, pasteurized, vitamin A + D added, 1% fat',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Cow milk, pasteurized, vitamin A + D added, 2% fat',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));
INSERT INTO food (name, categoryid) VALUES('Cow milk, pasteurized, vitamin D added, 3.25% fat',(SELECT id FROM foodcategory WHERE name='Unfermented milks'));