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

Query time 0.01759

Result

category
Shoes
Men's Shoes
Women's Shoes
Bags & Purses
Bag Accessories
Market Bags & Totes
Pouches & Coin Purses
Shoulder
Crossbody & Messenger
Hobo
Wristlets
Clutch & Evening Bags
Purse Inserts & Straps
Backpacks
Diaper Bags
Duffle & Overnight Bags
Cosmetic & Toiletry Bags
Luggage & Travel
Wallets & Money Clips
Clothing Accessories
Belts & Sashes
Patches & Pins
Women's
Dresses
Skirts
Shirts, Tops & Tees
Jackets & Coats
Pants
Shorts
Swimwear
Sweaters
Pajamas & Loungewear
Sweatshirts & Sweatpants
Gloves & Mittens
Fingerless Gloves
Mittens
Winter Gloves
Arm Warmers
Evening & Formal Gloves
Men's
Shirts
Sweaters
Jackets & Coats
Pants
Shorts
Pajamas
Kids & Baby
Boys Clothing
Tops & Tees
Shorts & Pants
Sweaters & Sweatshirts
Pajamas
Swimwear
Jackets & Coats
Girls Clothing
Tops & Tees
Dresses & Skirts
Shorts & Pants
Sweaters & Sweatshirts
Pajamas
Swimwear
Jackets & Coats
Baby Clothing
Bodysuits
Clothing Sets
Bloomers & Diaper Covers
Leg Warmers
Coming Home
Booties
Baby Accessories
Scarves & Wraps
Scarves
Wraps & Shawls
Bandanas
Hair Accessories
Hair Bows
Scrunchies & Hair Ties
Headbands & Turbans
Barrettes & Clips
Elastics & Ties
Wreaths & Tiaras
Hair Pins
Hats
Hat Accessories
Winter Hats
Formal Hats
Sun Hats & Visors
Baseball & Trucker Hats
Fascinators & Mini Hats
Cowboy Hats
Keychains & Lanyards