SELECT 
  cscart_categories.category_id, 
  cscart_categories.parent_id, 
  cscart_categories.id_path, 
  cscart_category_descriptions.category, 
  cscart_categories.position, 
  cscart_categories.status, 
  cscart_categories.company_id, 
  cscart_categories.storefront_id, 
  cscart_categories.product_count, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id 
  AND cscart_category_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  1 = 1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A') 
  AND cscart_categories.id_path LIKE '2653/2658/%' 
  AND cscart_categories.storefront_id IN (0, 1) 
ORDER BY 
  cscart_categories.is_trash asc, 
  cscart_categories.position asc, 
  cscart_category_descriptions.category asc

Query time 0.00622

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "222.55"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "range",
            "possible_keys": [
              "c_status",
              "id_path"
            ],
            "key": "id_path",
            "used_key_parts": [
              "id_path"
            ],
            "key_length": "767",
            "rows_examined_per_scan": 153,
            "rows_produced_per_join": 3,
            "filtered": "2.00",
            "index_condition": "(`webmarco`.`cscart_categories`.`id_path` like '2653/2658/%')",
            "cost_info": {
              "read_cost": "214.60",
              "eval_cost": "0.61",
              "prefix_cost": "215.21",
              "data_read_per_join": "18K"
            },
            "used_columns": [
              "category_id",
              "parent_id",
              "id_path",
              "company_id",
              "usergroup_ids",
              "status",
              "product_count",
              "position",
              "is_trash",
              "storefront_id"
            ],
            "attached_condition": "(((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` = 'A') and (`webmarco`.`cscart_categories`.`storefront_id` in (0,1)))"
          }
        },
        {
          "table": {
            "table_name": "cscart_category_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "webmarco.cscart_categories.category_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 3,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "3.06",
              "eval_cost": "0.61",
              "prefix_cost": "218.88",
              "data_read_per_join": "12K"
            },
            "used_columns": [
              "category_id",
              "lang_code",
              "category"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "webmarco.cscart_categories.category_id",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 3,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "3.06",
              "eval_cost": "0.61",
              "prefix_cost": "222.55",
              "data_read_per_join": "5K"
            },
            "used_columns": [
              "name",
              "object_id",
              "company_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}

Result

category_id parent_id id_path category position status company_id storefront_id product_count seo_name seo_path
9276 2658 2653/2658/9276 Accessories 0 A 0 0 155 accessories 2653/2658
9991 9990 2653/2658/9990/9991 Coats & Jackets 0 A 0 0 12 coats-and-jackets 2653/2658/9990
9990 2658 2653/2658/9990 Outerwear 0 A 0 0 1 outerwear-en 2653/2658
9365 2763 2653/2658/2763/9365 Bras 0 A 0 0 573 bras-en 2653/2658/2763
8984 2767 2653/2658/2767/8984 Contractor Pants & Coveralls 0 A 0 0 51 contractor-pants-and-coveralls-en 2653/2658/2767
9539 9538 2653/2658/2763/9538/9539 Garters 0 A 0 0 86 garters 2653/2658/2763/9538
9278 9277 2653/2658/9276/9277/9278 Headdresses 0 A 0 0 1 headdresses 2653/2658/9276/9277
9277 9276 2653/2658/9276/9277 Headwear 0 A 0 0 5 headwear 2653/2658/9276
9540 2763 2653/2658/2763/9540 Hosiery 0 A 0 0 30 hosiery-en 2653/2658/2763
9541 2763 2653/2658/2763/9541 Lingerie 0 A 0 0 7 lingerie-en 2653/2658/2763
9538 2763 2653/2658/2763/9538 Lingerie Accessories 0 A 0 0 0 lingerie-accessories-en 2653/2658/2763
9575 9574 2653/2658/9574/9575 Pajamas 0 A 0 0 325 pajamas 2653/2658/9574
9250 2658 2653/2658/9250 Shorts 0 A 0 0 56 shorts-en 2653/2658
9574 2658 2653/2658/9574 Sleepwear & Loungewear 0 A 0 0 0 sleepwear-and-loungewear-en 2653/2658
9257 2658 2653/2658/9257 Suits 0 A 0 0 4 suits-en 2653/2658
2776 2765 2653/2658/2729/2765/2776 Baptism & Communion Dresses 10 A 0 0 0 baptism-and-communion-dresses 2653/2658/2729/2765
2856 2763 2653/2658/2763/2856 Bra Accessories 10 A 0 0 1 bra-accessories 2653/2658/2763
2870 2856 2653/2658/2763/2856/2870 Bra Strap Pads 10 A 0 0 0 bra-strap-pads 2653/2658/2763/2856
2888 2763 2653/2658/2763/2888 Bras 10 A 0 0 33 bras 2653/2658/2763
2735 2729 2653/2658/2729/2735 Dirndls 10 A 0 0 0 dirndls 2653/2658/2729
2899 2895 2653/2658/2763/2895/2899 Garter Belts 10 A 0 0 0 garter-belts 2653/2658/2763/2895
2665 2657 2653/2658/2657/2665 Loungewear 10 A 0 0 2 loungewear 2653/2658/2657
2702 2695 2653/2658/2695/2702 Pant Suits 10 A 0 0 16 pant-suits 2653/2658/2695
2657 2658 2653/2658/2657 Sleepwear & Loungewear 10 A 0 0 0 sleepwear-and-loungewear 2653/2658
2726 2722 2653/2658/2722/2726 Baby & Toddler Bottoms 10 A 0 0 0 baby-and-toddler-bottoms-en 2653/2658/2722
2784 2778 2653/2658/2767/2778/2784 Baseball Uniforms 10 A 0 0 0 baseball-uniforms 2653/2658/2767/2778
2664 2661 2653/2658/2661/2664 Bicycle Activewear 10 A 0 0 0 bicycle-activewear-en 2653/2658/2661
2667 2664 2653/2658/2661/2664/2667 Bicycle Bibs 10 A 0 0 0 bicycle-bibs-en 2653/2658/2661/2664
2675 2671 2653/2658/2671/2675 Bridal Party Dresses 10 A 0 0 0 bridal-party-dresses 2653/2658/2671
2814 2810 2653/2658/2767/2810/2814 Chef's Hats 10 A 0 0 7 chefs-hats 2653/2658/2767/2810
2850 2843 2653/2658/2843/2850 Coats & Jackets 10 A 0 0 863 coats-and-jackets 2653/2658/2843
3418 3400 2653/2658/2671/3400/3418 Flower Girl Dress 10 A 0 0 17 flower-girl-dress 2653/2658/2671/3400
2693 2690 2653/2658/2661/2690/2693 Ghillie Suits 10 A 0 0 0 ghillie-suits-en 2653/2658/2661/2690
2859 2849 2653/2658/2849/2859 Jumpsuits & Rompers 10 A 0 0 8 jumpsuits-and-rompers 2653/2658/2849
10570 2779 2653/2658/2763/2779/10570 Men 10 A 0 0 80 meshkuj 2653/2658/2763/2779
2708 2704 2653/2658/2661/2704/2708 Motorcycle Jackets 10 A 0 0 0 motorcycle-jackets-en 2653/2658/2661/2704
2775 2763 2653/2658/2763/2775 Shapewear 10 A 0 0 88 shapewear 2653/2658/2763
2778 2767 2653/2658/2767/2778 Sports Uniforms 10 A 0 0 22 sports-uniforms 2653/2658/2767
2897 2671 2653/2658/2671/2897 Wedding Dresses 10 A 0 0 322 wedding-dresses-en 2653/2658/2671
2883 2856 2653/2658/2763/2856/2883 Bra Straps & Extenders 20 A 0 0 0 bra-straps-and-extenders 2653/2658/2763/2856
2906 2895 2653/2658/2763/2895/2906 Garters 20 A 0 0 0 garters 2653/2658/2763/2895
2738 2729 2653/2658/2729/2738 Hakama Trousers 20 A 0 0 0 hakama-trousers 2653/2658/2729
2670 2657 2653/2658/2657/2670 Nightgowns 20 A 0 0 62 nightgowns 2653/2658/2657
2711 2695 2653/2658/2695/2711 Skirt Suits 20 A 0 0 6 skirt-suits 2653/2658/2695
2661 2658 2653/2658/2661 Activewear 20 A 0 0 187 activewear-en 2653/2658
2732 2722 2653/2658/2722/2732 Baby & Toddler Diaper Covers 20 A 0 0 0 baby-and-toddler-diaper-covers-en 2653/2658/2722
2668 2664 2653/2658/2661/2664/2668 Bicycle Jerseys 20 A 0 0 0 bicycle-jerseys-en 2653/2658/2661/2664
2681 2661 2653/2658/2661/2681 Boxing Shorts 20 A 0 0 0 boxing-shorts-en 2653/2658/2661
2898 2837 2653/2658/2837/2898 Casual Dress 20 A 0 0 295 casual-dress 2653/2658/2837
2794 2778 2653/2658/2767/2778/2794 Cheerleading Uniforms 20 A 0 0 0 cheerleading-uniforms 2653/2658/2767/2778
2820 2810 2653/2658/2767/2810/2820 Chef's Jackets 20 A 0 0 81 chefs-jackets 2653/2658/2767/2810
2696 2690 2653/2658/2661/2690/2696 Hunting & Fishing Vests 20 A 0 0 0 hunting-and-fishing-vests-en 2653/2658/2661/2690
2868 2849 2653/2658/2849/2868 Leotards & Unitards 20 A 0 0 13 leotards-and-unitards 2653/2658/2849
2709 2704 2653/2658/2661/2704/2709 Motorcycle Pants 20 A 0 0 1 motorcycle-pants-en 2653/2658/2661/2704
2857 2843 2653/2658/2843/2857 Rain Pants 20 A 0 0 0 rain-pants 2653/2658/2843
2779 2763 2653/2658/2763/2779 Socks 20 A 0 0 139 socks 2653/2658/2763
10571 2779 2653/2658/2763/2779/10571 Women 20 A 0 0 32 femra 2653/2658/2763/2779
2885 2856 2653/2658/2763/2856/2885 Breast Enhancing Inserts 30 A 0 0 1 breast-enhancing-inserts 2653/2658/2763/2856
2890 2763 2653/2658/2763/2890 Hosiery 30 A 0 0 0 hosiery 2653/2658/2763
2746 2729 2653/2658/2729/2746 Japanese Black Formal Wear 30 A 0 0 0 japanese-black-formal-wear 2653/2658/2729
2714 2704 2653/2658/2661/2704/2714 Motorcycle Suits 30 A 0 0 23 motorcycle-suits-en 2653/2658/2661/2704
2679 2657 2653/2658/2657/2679 Pajamas 30 A 0 0 144 pajamas 2653/2658/2657
2719 2695 2653/2658/2695/2719 Tuxedos 30 A 0 0 5 tuxedos 2653/2658/2695
2741 2722 2653/2658/2722/2741 Baby & Toddler Dresses 30 A 0 0 79 baby-and-toddler-dresses-en 2653/2658/2722
2672 2664 2653/2658/2661/2664/2672 Bicycle Shorts & Briefs 30 A 0 0 0 bicycle-shorts-and-briefs-en 2653/2658/2661/2664
3400 2671 2653/2658/2671/3400 Bridesmaid Dress 30 A 0 0 0 bridesmaid-dress 2653/2658/2671
2826 2810 2653/2658/2767/2810/2826 Chef's Pants 30 A 0 0 12 chefs-pants 2653/2658/2767/2810
2808 2778 2653/2658/2767/2778/2808 Cricket Uniforms 30 A 0 0 0 cricket-uniforms 2653/2658/2767/2778
2682 2661 2653/2658/2661/2682 Dance Dresses, Skirts & Costumes 30 A 0 0 1 dance-dresses-skirts-and-costumes-en 2653/2658/2661
2805 2767 2653/2658/2767/2805 Flight Suits 30 A 0 0 0 flight-suits 2653/2658/2767
2900 2837 2653/2658/2837/2900 Formal Dress 30 A 0 0 5 formal-dress 2653/2658/2837
2699 2690 2653/2658/2661/2690/2699 Hunting & Tactical Pants 30 A 0 0 0 hunting-and-tactical-pants-en 2653/2658/2661/2690
10572 2779 2653/2658/2763/2779/10572 Kids 30 A 0 0 0 femije 2653/2658/2763/2779
2878 2849 2653/2658/2849/2878 Overalls 30 A 0 0 23 overalls 2653/2658/2849
2858 2843 2653/2658/2843/2858 Snow Pants & Suits 30 A 0 0 0 snow-pants-and-suits 2653/2658/2843
2671 2658 2653/2658/2671 Wedding & Bridal Party Dresses 30 A 0 0 18 wedding-and-bridal-party-dresses 2653/2658
2887 2856 2653/2658/2763/2856/2887 Breast Petals & Concealers 40 A 0 0 0 breast-petals-and-concealers 2653/2658/2763/2856
2751 2729 2653/2658/2729/2751 Kimono Outerwear 40 A 0 0 0 kimono-outerwear 2653/2658/2729
2695 2658 2653/2658/2695 Suits 40 A 0 0 92 suits 2653/2658
2745 2722 2653/2658/2722/2745 Baby & Toddler Outerwear 40 A 0 0 58 baby-and-toddler-outerwear-en 2653/2658/2722
2674 2664 2653/2658/2661/2664/2674 Bicycle Skinsuits 40 A 0 0 0 bicycle-skinsuits-en 2653/2658/2661/2664
2810 2767 2653/2658/2767/2810 Food Service Uniforms 40 A 0 0 21 food-service-uniforms 2653/2658/2767
2685 2661 2653/2658/2661/2685 Football Pants 40 A 0 0 16 football-pants-en 2653/2658/2661
2831 2778 2653/2658/2767/2778/2831 Hockey Uniforms 40 A 0 0 0 hockey-uniforms 2653/2658/2767/2778
10573 2779 2653/2658/2763/2779/10573 Modal 40 A 0 0 44 modal 2653/2658/2763/2779
2862 2843 2653/2658/2843/2862 Rain Suits 40 A 0 0 0 rain-suits 2653/2658/2843
2689 2657 2653/2658/2657/2689 Robes 40 A 0 0 24 robes 2653/2658/2657
2754 2722 2653/2658/2722/2754 Baby & Toddler Outfits 50 A 0 0 313 baby-and-toddler-outfits 2653/2658/2722
2756 2729 2653/2658/2729/2756 Kimonos 50 A 0 0 0 kimonos 2653/2658/2729
2722 2658 2653/2658/2722 Baby & Toddler Clothing 50 A 0 0 446 baby-and-toddler-clothing-en 2653/2658
10574 2779 2653/2658/2763/2779/10574 Bamboo 50 A 0 0 68 bamboo 2653/2658/2763/2779
2676 2664 2653/2658/2661/2664/2676 Bicycle Tights 50 A 0 0 1 bicycle-tights-en 2653/2658/2661/2664
2902 2837 2653/2658/2837/2902 Cocktail Dress 50 A 0 0 69 cocktail-dress 2653/2658/2837
2690 2661 2653/2658/2661/2690 Hunting Clothing 50 A 0 0 0 hunting-clothing-en 2653/2658/2661
2830 2767 2653/2658/2767/2830 Military Uniforms 50 A 0 0 0 military-uniforms 2653/2658/2767
2834 2778 2653/2658/2767/2778/2834 Officiating Uniforms 50 A 0 0 0 officiating-uniforms 2653/2658/2767/2778
2866 2843 2653/2658/2843/2866 Vests 50 A 0 0 156 vests 2653/2658/2843
2765 2729 2653/2658/2729/2765 Religious Ceremonial Clothing 60 A 0 0 0 religious-ceremonial-clothing 2653/2658/2729
2724 2658 2653/2658/2724 Swimwear 60 A 0 0 84 swimwear 2653/2658
2762 2722 2653/2658/2722/2762 Baby & Toddler Sleepwear 60 A 0 0 16 baby-and-toddler-sleepwear 2653/2658/2722
2884 2843 2653/2658/2843/2884 Chaps 60 A 0 0 0 chaps 2653/2658/2843
10575 2779 2653/2658/2763/2779/10575 Diabetic 60 A 0 0 30 diabetik 2653/2658/2763/2779
2838 2778 2653/2658/2767/2778/2838 Football Uniforms 60 A 0 0 0 football-uniforms 2653/2658/2767/2778
2701 2661 2653/2658/2661/2701 Martial Arts Shorts 60 A 0 0 0 martial-arts-shorts-en 2653/2658/2661
2839 2767 2653/2658/2767/2839 School Uniforms 60 A 0 0 0 school-uniforms 2653/2658/2767
2903 2837 2653/2658/2837/2903 Work Dress 60 A 0 0 4 work-dress 2653/2658/2837
2770 2722 2653/2658/2722/2770 Baby & Toddler Socks & Tights 70 A 0 0 40 baby-and-toddler-socks-and-tights 2653/2658/2722
2787 2729 2653/2658/2729/2787 Saris & Lehengas 70 A 0 0 0 saris-and-lehengas 2653/2658/2729
2904 2837 2653/2658/2837/2904 Evening and Ceremony Dresses 70 A 0 0 353 evening-and-ceremony-dresses 2653/2658/2837
2844 2778 2653/2658/2767/2778/2844 Martial Arts Uniforms 70 A 0 0 0 martial-arts-uniforms 2653/2658/2767/2778
2704 2661 2653/2658/2661/2704 Motorcycle Protective Clothing 70 A 0 0 6 motorcycle-protective-clothing-en 2653/2658/2661
2845 2767 2653/2658/2767/2845 Security Uniforms 70 A 0 0 0 security-uniforms 2653/2658/2767
2729 2658 2653/2658/2729 Traditional & Ceremonial Clothing 70 A 0 0 0 traditional-and-ceremonial-clothing 2653/2658
2803 2729 2653/2658/2729/2803 Traditional Leather Pants 80 A 0 0 0 traditional-leather-pants 2653/2658/2729
2777 2722 2653/2658/2722/2777 Baby & Toddler Swimwear 80 A 0 0 12 baby-and-toddler-swimwear 2653/2658/2722
2717 2661 2653/2658/2661/2717 Paintball Clothing 80 A 0 0 0 paintball-clothing-en 2653/2658/2661
2905 2837 2653/2658/2837/2905 Party Dress 80 A 0 0 42 party-dress 2653/2658/2837
2865 2778 2653/2658/2767/2778/2865 Soccer Uniforms 80 A 0 0 3 soccer-uniforms 2653/2658/2767/2778
2854 2767 2653/2658/2767/2854 White Coats 80 A 0 0 711 white-coats 2653/2658/2767
2815 2729 2653/2658/2729/2815 Yukata 90 A 0 0 0 yukata 2653/2658/2729
2790 2722 2653/2658/2722/2790 Baby & Toddler Tops 90 A 0 0 62 baby-and-toddler-tops 2653/2658/2722
2907 2837 2653/2658/2837/2907 Beach Dresses 90 A 0 0 10 beach-dresses 2653/2658/2837
2807 2722 2653/2658/2722/2807 Baby One-Pieces 100 A 0 0 85 baby-one-pieces 2653/2658/2722
2816 2722 2653/2658/2722/2816 Toddler Underwear 110 A 0 0 8 toddler-underwear 2653/2658/2722
2785 2763 2653/2658/2763/2785 Underwear 1020 A 0 0 81 underwear 2653/2658/2763
2763 2658 2653/2658/2763 Underwear & Socks 1020 A 0 0 115 underwear-and-socks 2653/2658
2791 2763 2653/2658/2763/2791 Undershirts 1030 A 0 0 158 undershirts 2653/2658/2763
2767 2658 2653/2658/2767 Uniforms 1030 A 0 0 0 uniforms 2653/2658
2769 2658 2653/2658/2769 Outfit Sets 1040 A 0 0 319 outfit-sets 2653/2658
2860 2778 2653/2658/2767/2778/2860 Softball Uniforms 1040 A 0 0 0 softball-uniforms 2653/2658/2767/2778
2795 2763 2653/2658/2763/2795 Underwear Slips 1040 A 0 0 2338 underwear-slips 2653/2658/2763
2892 2763 2653/2658/2763/2892 Jock Straps 1050 A 0 0 0 jock-straps 2653/2658/2763
2789 2658 2653/2658/2789 Pants 1050 A 0 0 786 pants 2653/2658
2864 2778 2653/2658/2767/2778/2864 Wrestling Uniforms 1050 A 0 0 0 wrestling-uniforms 2653/2658/2767/2778
2894 2763 2653/2658/2763/2894 Lingerie 1060 A 0 0 0 lingerie 2653/2658/2763
8942 2778 2653/2658/2767/2778/8942 Basketball Uniforms 1060 A 0 0 0 basketball-uniforms 2653/2658/2767/2778
2800 2658 2653/2658/2800 Shirts & Tops 1060 A 0 0 1833 shirts-and-tops 2653/2658
2895 2763 2653/2658/2763/2895 Lingerie Accessories 1070 A 0 0 10 lingerie-accessories 2653/2658/2763
2812 2658 2653/2658/2812 Shorts 1070 A 0 0 83 shorts 2653/2658
2908 2763 2653/2658/2763/2908 Long Johns 1080 A 0 0 0 long-johns 2653/2658/2763
2822 2658 2653/2658/2822 Skirts 1080 A 0 0 110 skirts 2653/2658
2909 2763 2653/2658/2763/2909 Petticoats & Pettipants 1090 A 0 0 0 petticoats-and-pettipants 2653/2658/2763
2829 2658 2653/2658/2829 Skorts 1090 A 0 0 0 skorts 2653/2658
2837 2658 2653/2658/2837 Dresses 1110 A 0 0 85 dresses 2653/2658
2843 2658 2653/2658/2843 Outerwear 1120 A 0 0 16 outerwear 2653/2658
2849 2658 2653/2658/2849 One-Pieces 1130 A 0 0 0 one-pieces 2653/2658
8851 2658 2653/2658/8851 Personalized Clothing & Accessories 1140 A 0 0 36 personalized-clothing-and-accessories 2653/2658
10562 2658 2653/2658/10562 Bodysuits 1150 A 0 0 1 bodysuits 2653/2658
10563 2658 2653/2658/10563 Jumpsuits 1160 A 0 0 7 jumpsuits 2653/2658
9670 9658 2653/2658/2767/9658/9670 Chef's Accessories 2020 A 0 0 16 chefs-accessories 2653/2658/2767/9658
9665 9658 2653/2658/2767/9658/9665 Chef's Jackets 2020 A 0 0 763 chefs-jackets 2653/2658/2767/9658
9658 2767 2653/2658/2767/9658 Man's Chef Uniforms 2020 A 0 0 0 mans-chef-uniforms 2653/2658/2767
9666 9658 2653/2658/2767/9658/9666 Chef's Pants 2030 A 0 0 48 chefs-pants 2653/2658/2767/9658