SELECT 
  category 
FROM 
  category_descriptions cd 
  LEFT JOIN categories c ON c.category_id = cd.category_id 
WHERE 
  id_path LIKE "%/7580/%" 
  OR id_path LIKE "7580/%"

Query time 0.00940

Result

category
Baked Goods
Bagels
Baking Mixes
Biscotti
Breads
Brownies
Cake & Cupcakes
Cookies
Donuts
Macarons
Pastries
Pies
Candy
Bark & Brittles
Caramels
Chocolates
Fudge
Gummy Candy
Hard Candy
Lollipops
Marshmallows
Toffee
Truffles
Beverages
Coffee
Hot Chocolate
Juice
Carbonated Beverages
Drink Mixes
Candied Spoons
Tea
Condiments & Sauces
Dressings
Mustard
Ketchup
Cooking Sauce
Marinades
Oils
Salsa & Dip
Syrups
Honey
Preserves
Chutneys
Jams & Jellies
Fruit Butter
Marmalades
Pickles
Snacks
Popcorn
Pretzels
Chips
Crackers
Granola
Nuts & Seeds
Dried Foods
Dried Fruits
Dried Vegetables
Jerky
Smoked Meat
Grains
Pasta
Cereal & Oats
Rice
Spices & Herbs
Spice Mixes
Rubs
Extracts
Soup Mixes