=== Category Hierarchy Validation Report ===

1. PARENT CATEGORY DIRECT ASSIGNMENTS (Should be 0):
   ⚠️  VIOLATIONS FOUND: 11 parent categories have direct book assignments!
   - Age: 1 books (has 10 children)
   - Bestseller: 73 books (has 0 children)
   - Books: 1512 books (has 11 children)
   - Toys: 49 books (has 5 children)
   - Tiktok Made Me Buy it: 9 books (has 0 children)
   - Uncategorized: 36 books (has 0 children)
   - Fantasy: 20 books (has 1 children)
   - Pick Of The Week: 17 books (has 0 children)
   - Popular Series: 4 books (has 12 children)
   - Computer: 4 books (has 0 children)
   - Stationery: 1 books (has 0 children)

2. LEAF CATEGORY UTILIZATION:
   Total leaf categories: 55
   Leaf categories with books: 50
   Empty leaf categories: 5

3. CATEGORY DEPTH DISTRIBUTION:
   Level 0: 11 categories
   Level 1: 39 categories
   Level 2: 1 categories

4. SAMPLE CATEGORY HIERARCHY (First 5 parent categories):

   📁 Age (Direct: 1 books)
      └─ 0-3 (Direct: 0 books)
      └─ 0-3 Years (Direct: 32 books)
      └─ 11-14 Years (Direct: 935 books)
      └─ 14-16 Years (Direct: 1008 books)
      └─ 3-5 Years (Direct: 163 books)

   📁 Bestseller (Direct: 73 books)

   📁 Books (Direct: 1512 books)
      └─ Baby /Toddler (Direct: 39 books)
      └─ Business Development (Direct: 9 books)
      └─ Collections/box sets (Direct: 30 books)
      └─ Dictionaries (Direct: 11 books)
      └─ Encyclopedias (Direct: 106 books)

   📁 Computer (Direct: 4 books)

   📁 Fantasy (Direct: 20 books)
      └─ Sarah J Maas (Direct: 14 books)

5. AGGREGATION TEST:
   Testing if parent category '9-11 Years' includes all descendant books...
   - Direct assignments to '9-11 Years': 898
   - Aggregated (with direct children): 898
   - Children count: 0

=== END OF REPORT ===