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

Query time 0.00974

Result

category
Metal Art
Art Prints
Digital Art Prints
Giclée
Letterpress
Screenprints
Wood & Linocut Prints
Etchings & Engravings
Lithograph & Monotypes
Photography
Painting
Acrylic
Gouache
Ink
Oil
Spray Paint
Watercolor
Sculpture
Glass Art
Drawing & Illustration
Digital Drawings
Marker Drawings
Pastel or Charcoal Drawings
Pen & Ink Drawings
Pencil Drawings
Mixed Media & Collage
Fiber & Textile Arts
Collectibles
Artist Trading Cards
Sports Collectibles
Art Objects
Militaria
Dolls & Miniatures
Figurines
Miniatures
Dollhouse Miniatures
Dollhouse
Collectable Dolls
Ceramics