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_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 '266/%' 
  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.00640

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "494.78"
    },
    "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": 341,
            "rows_produced_per_join": 6,
            "filtered": "2.00",
            "index_condition": "(`webmarco`.`cscart_categories`.`id_path` like '266/%')",
            "cost_info": {
              "read_cost": "477.05",
              "eval_cost": "1.36",
              "prefix_cost": "478.41",
              "data_read_per_join": "40K"
            },
            "used_columns": [
              "category_id",
              "parent_id",
              "id_path",
              "company_id",
              "usergroup_ids",
              "status",
              "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": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "6.82",
              "eval_cost": "1.36",
              "prefix_cost": "486.59",
              "data_read_per_join": "27K"
            },
            "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": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "6.82",
              "eval_cost": "1.36",
              "prefix_cost": "494.78",
              "data_read_per_join": "11K"
            },
            "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 seo_name seo_path
9401 1309 266/1584/1309/9401 0 A 0 0
2269 2265 266/990/2265/2269 Acrylic Decoration 0 A 0 0 acrylic-decoration 266/990/2265
2534 2529 266/356/2529/2534 Advanced E-commercial 0 A 0 0 e-commerce-advanced 266/356/2529
2399 2397 266/356/2397/2399 Armored doors 0 A 0 0 armored-doors-en 266/356/2397
2376 2374 266/2373/2374/2376 Arts and Humanities 0 A 0 0 art-e-humanities-en 266/2373/2374
1696 1695 266/327/1695/1696 Autoscale 0 A 0 0 autoscale-en 266/327/1695
2537 2529 266/356/2529/2537 Bindery 0 A 0 0 bindery-en 266/356/2529
2377 2374 266/2373/2374/2377 Business 0 A 0 0 business 266/2373/2374
2396 2388 266/2373/2388/2396 Business Development 0 A 0 0 business-development 266/2373/2388
2390 2388 266/2373/2388/2390 Commercial 0 A 0 0 commercial 266/2373/2388
2272 2265 266/990/2265/2272 Decorations on the Wall 0 A 0 0 decorations-on-the-wall 266/990/2265
2268 2265 266/990/2265/2268 Decorative Arts 0 A 0 0 art-decorative-en 266/990/2265
2530 2529 266/356/2529/2530 Document Archiving 0 A 0 0 document-archiving-en 266/356/2529
2392 2388 266/2373/2388/2392 Finance and Bancing 0 A 0 0 finance-and-bancing 266/2373/2388
2391 2388 266/2373/2388/2391 Green Jobs 0 A 0 0 green-jobs 266/2373/2388
2375 2374 266/2373/2374/2375 Health 0 A 0 0 health 266/2373/2374
356 266 266/356 Home & Office 0 A 0 0 home-and-office-en 266
2395 2388 266/2373/2388/2395 Human Resources 0 A 0 0 human-resources 266/2373/2388
2394 2388 266/2373/2388/2394 insurance 0 A 0 0 insurance 266/2373/2388
2398 2397 266/356/2397/2398 Interior doors 0 A 0 0 interior-doors-en 266/356/2397
2393 2388 266/2373/2388/2393 IT 0 A 0 0 it 266/2373/2388
2532 2529 266/356/2529/2532 Mailing management 0 A 0 0 mailing-management-en 266/356/2529
2531 2529 266/356/2529/2531 Management of assistance, contracts and construction sites 0 A 0 0 management-construction-sites 266/356/2529
2400 2397 266/356/2397/2400 Mosquito nets Blinds 0 A 0 0 mosquito-nets 266/356/2397
2271 2265 266/990/2265/2271 Mural 0 A 0 0 mural-en 266/990/2265
2401 2397 266/356/2397/2401 Overhead doors for Box 0 A 0 0 overhead-doors 266/356/2397
2266 2265 266/990/2265/2266 Paintings 0 A 0 0 paintings-en 266/990/2265
2273 2265 266/990/2265/2273 Panorama 0 A 0 0 panorama-en 266/990/2265
2535 2529 266/356/2529/2535 Photocopiers 0 A 0 0 photocopiers-en 266/356/2529
2538 2529 266/356/2529/2538 Press 0 A 0 0 press-en 266/356/2529
2536 2529 266/356/2529/2536 Publishing 0 A 0 0 publishing-en 266/356/2529
2402 2397 266/356/2397/2402 Security Grates 0 A 0 0 security-grates-en 266/356/2397
2267 2265 266/990/2265/2267 Tappezzerie 0 A 0 0 tappezzerie-en 266/990/2265
10667 266 266/10667 Test Category 0 A 0 0 test-category 266
10669 10667 266/10667/10669 Test SubCategory 0 A 0 0 test-subcategory 266/10667
2270 2265 266/990/2265/2270 Troppe oil 0 A 0 0 troppe-oil-en 266/990/2265
2533 2529 266/356/2529/2533 Vetrina web 0 A 0 0 vetrina-web-en 266/356/2529
9624 2393 266/2373/2388/2393/9624 Web Design 0 A 0 0 web-design-en 266/2373/2388/2393
2403 2397 266/356/2397/2403 Windows and Shutters 0 A 0 0 windows-shutters 266/356/2397
10249 10248 266/2577/10248/10249 1 Day 10 A 0 0 1-day 266/2577/10248
328 327 266/327/328 Advertising Monitors 10 A 0 0 advertising-monitors 266/327
2406 2405 266/2404/2405/2406 Appetizers 10 A 0 0 appetizers-en 266/2404/2405
9955 2604 266/2577/2604/9955 Bus Tickets 10 A 0 0 bus-tickets 266/2577/2604
395 394 266/394/395 Car Repair 10 A 0 0 car-repair 266/394
936 935 266/930/935/936 Car Stickers 10 A 0 0 stickers-auto-en 266/930/935
2612 2611 266/2611/2612 Cellular Repairs 10 A 0 0 celular-repair 266/2611
933 932 266/930/932/933 Custom Printed Clothing 10 A 0 0 custom-printed-clothing 266/930/932
1514 1409 266/443/1409/1514 Decorative Painting 10 A 0 0 decorative-painting 266/443/1409
1407 445 266/443/445/1407 Electrical Installations 10 A 0 0 electrical-installations 266/443/445
2434 2433 266/2433/2434 Electricity & Gas 10 A 0 0 electricity-and-gas 266/2433
342 341 266/341/342 Environment Sanitizing 10 A 0 0 environment-sanitizing-en 266/341
9963 9928 266/9926/9928/9963 Event Reservations 10 A 0 0 event-reservations 266/9926/9928
2480 2478 266/2433/2478/2480 Families in Difficulty 10 A 0 0 families-in-difficulty 266/2433/2478
2172 2171 266/2171/2172 Fiorista 10 A 0 0 fiorista-en 266/2171
2592 2591 266/2591/2592 Fire Safety 10 A 0 0 fire-safety-en 266/2591
2548 2374 266/2373/2374/2548 Foreign languages 10 A 0 0 foreign-languages 266/2373/2374
9841 9840 266/9840/9841 Formation 10 A 0 0 formation 266/9840
1501 1500 266/1498/1500/1501 Gabion Retaining Wall 10 A 0 0 gabion-retaining-wall 266/1498/1500
2578 2577 266/2577/2578 Hotel Booking 10 A 0 0 hotel-booking-en 266/2577
1516 393 266/356/393/1516 House Cleaning and Sanitation 10 A 0 0 house-cleaning-and-sanitation 266/356/393
345 344 266/344/345 Hydraulic Repairs 10 A 0 0 hydraulic-repairs 266/344
1480 1479 266/1498/1479/1480 Industrial Machines 10 A 0 0 industrial-machines 266/1498/1479
2405 2404 266/2404/2405 Italian Food 10 A 0 0 italian-food 266/2404
2479 2388 266/2373/2388/2479 Jobs Abroad 10 A 0 0 jobs-abroad 266/2373/2388
1415 929 266/356/929/1415 Kitchen & Dining Room 10 A 0 0 kitchen-and-dining-room 266/356/929
267 443 266/443/267 Lift Service 10 A 0 0 lift-service 266/443
2435 2434 266/2433/2434/2435 Light Connection 10 A 0 0 light-connection 266/2433/2434
1522 1497 266/1498/1479/1497/1522 Locks Repairs 10 A 0 0 locks-repairs 266/1498/1479/1497
1909 1907 266/1907/1909 Manicure & Pedicure 10 A 0 0 manicure-e-pedicure-en 266/1907
1411 1410 266/443/1410/1411 Marble Laying 10 A 0 0 marble-laying 266/443/1410
1908 1907 266/1907/1908 Massages and Physiotherapy 10 A 0 0 massages-and-physiotherapy 266/1907
9695 9694 266/9692/9694/9695 Mobile Apps 10 A 0 0 mobile-apps 266/9692/9694
2470 346 266/344/346/2470 Modular Switches 10 A 0 0 modular-switches 266/344/346
2616 2615 266/2615/2616 Musical Productions 10 A 0 0 musical-productions-en 266/2615
1499 1498 266/1498/1499 Naturalistic Engineering 10 A 0 0 naturalistic-engineering 266/1498
716 715 266/715/716 Pantograph Construction 10 A 0 0 pantograph-construction 266/715
9845 9844 266/9844/9845 Penal Cases 10 A 0 0 penal-cases-en 266/9844
946 945 266/930/945/946 Personalized Pens 10 A 0 0 personalized-pens 266/930/945
2466 2465 266/2465/2466 Pet Caregiver 10 A 0 0 pet-caregiver 266/2465
991 990 266/990/991 Photography Services 10 A 0 0 photography-services 266/990
1519 1518 266/443/1518/1519 Plasterboard Ceilings 10 A 0 0 plasterboard-ceilings 266/443/1518
9944 9941 266/394/9941/9944 Premium Tyres 10 A 0 0 premium-tyres 266/394/9941
2374 2373 266/2373/2374 Professional courses 10 A 0 0 professional-courses 266/2373
1441 447 266/443/447/1441 PVC & Aluminum Windows 10 A 0 0 pvc-and-aluminum-windows 266/443/447
2179 2178 266/2178/2179 Rehabilitation Center 10 A 0 0 rehabilitation-center 266/2178
444 443 266/443/444 Renovation 10 A 0 0 renovation 266/443
2631 444 266/443/444/2631 Roof Repair & Replacement 10 A 0 0 roof-repair-and-replacement-en 266/443/444
9693 9692 266/9692/9693 Support Packages 10 A 0 0 support-packages 266/9692
953 933 266/930/932/933/953 T-Shirt 10 A 0 0 t-shirt-en 266/930/932/933
955 934 266/930/932/934/955 T-Shirt 10 A 0 0 t-shirt-en 266/930/932/934
1937 1936 266/1936/1937 Tax Advice 10 A 0 0 tax-advice 266/1936
2387 2386 266/1498/2386/2387 Taxi service 10 A 0 0 service-taxi 266/1498/2386
1511 1510 266/443/1510/1511 Thermal Insulation 10 A 0 0 thermal-insulation 266/443/1510
1691 1690 266/443/1690/1691 Transportation of Materials 10 A 0 0 transportation-of-materials 266/443/1690
1697 1695 266/327/1695/1697 Vans 10 A 0 0 vans 266/327/1695
2455 2454 266/443/2454/2455 Verniciatura Mobili 10 A 0 0 verniciatura-mobili-en 266/443/2454
2618 2616 266/2615/2616/2618 Vinyl and Disc Printing 10 A 0 0 vinyl-and-disc-printing 266/2615/2616
9927 9926 266/9926/9927 Wedding 10 A 0 0 wedding 266/9926
9930 9927 266/9926/9927/9930 Wedding Menu 10 A 0 0 wedding-menu 266/9926/9927
2174 2173 266/2171/2173/2174 Wedding Planner 10 A 0 0 wedding-planner 266/2171/2173
994 990 266/990/994 Videography Services 15 A 0 0 video-services 266/990
10250 10248 266/2577/10248/10250 2 Days 20 A 0 0 2-days 266/2577/10248
1698 1695 266/327/1695/1698 Aerial Platform 20 A 0 0 aerial-platform 266/327/1695
1523 1497 266/1498/1479/1497/1523 Armored Doors Repair 20 A 0 0 armored-doors-repair 266/1498/1479/1497
2617 2615 266/2615/2617 Audio and Recording 20 A 0 0 audio-recordings 266/2615
2175 2173 266/2171/2173/2175 Birthdays & Anniversaries 20 A 0 0 birthday-anniversaries 266/2171/2173
947 945 266/930/945/947 Business Cards 20 A 0 0 business-cards 266/930/945
1938 1936 266/1936/1938 Business Consultant 20 A 0 0 business-consultant 266/1936
398 394 266/394/398 Car Painting 20 A 0 0 car-painting 266/394
9846 9844 266/9844/9846 Civil, Heritage and Family 20 A 0 0 civil-inheritance-and-family-en 266/9844
393 356 266/356/393 Cleaning Services 20 A 0 0 cleaning-services 266/356
934 932 266/930/932/934 Custom Embroidered Clothing 20 A 0 0 custom-embroidered-clothing 266/930/932
1692 1690 266/443/1690/1692 Demolition 20 A 0 0 demolition 266/443/1690
2483 2388 266/2373/2388/2483 Domestic Workers 20 A 0 0 domestic-workers 266/2373/2388
1442 447 266/443/447/1442 Door Hardware & Locks 20 A 0 0 door-hardware-and-locks 266/443/447
2481 2478 266/2433/2478/2481 Elderly Care 20 A 0 0 elderly-care 266/2433/2478
346 344 266/344/346 Electrician Service 20 A 0 0 electrician-service 266/344
1481 1479 266/1498/1479/1481 Equipment & Accessories 20 A 0 0 equipment-and-accessories 266/1498/1479
2173 2171 266/2171/2173 Event Planner 20 A 0 0 event-planner 266/2171
9928 9926 266/9926/9928 Events 20 A 0 0 events 266/9926
1517 393 266/356/393/1517 Facade Cleaning 20 A 0 0 facade-cleaning 266/356/393
1910 1907 266/1907/1910 Face Treatments 20 A 0 0 face-treatments 266/1907
9956 2604 266/2577/2604/9956 Ferry Tickets 20 A 0 0 ferry-tickets 266/2577/2604
2407 2405 266/2404/2405/2407 First dishes 20 A 0 0 first-dishes-en 266/2404/2405
1412 1410 266/443/1410/1412 Floor Tiling 20 A 0 0 floor-tiling 266/443/1410
2370 2178 266/2178/2370 Food Intolerance Test 20 A 0 0 food-intolerance-test 266/2178
992 990 266/990/992 Graphic & Design 20 A 0 0 graphic-and-design 266/990
956 934 266/930/932/934/956 Hats & Accessories 20 A 0 0 hats-and-accessories 266/930/932/934
954 933 266/930/932/933/954 Hats & Accessories 20 A 0 0 hats-and-accessories 266/930/932/933
1408 445 266/443/445/1408 Hydraulic Systems 20 A 0 0 hydraulic-systems 266/443/445
1502 1500 266/1498/1500/1502 Hydroseeding 20 A 0 0 hydroseeding 266/1498/1500
445 443 266/443/445 Implants / Installations 20 A 0 0 installations 266/443
2539 2404 266/2404/2539 Indian Food 20 A 0 0 indian-food 266/2404
1515 1409 266/443/1409/1515 Industrial Painting and Varnishing 20 A 0 0 industrial-painting-and-varnishing 266/443/1409
2471 346 266/344/346/2471 Installation Antenna TV and Parables 20 A 0 0 installation-antenna-tv-and-parables 266/344/346
1512 1510 266/443/1510/1512 Insulating Panels 20 A 0 0 insulating-panels 266/443/1510
1584 266 266/1584 Intelligent Electronic Devices & Security 20 A 0 0 services-of-electronic 266
1416 929 266/356/929/1416 Living Room 20 A 0 0 living-room 266/356/929
9694 9692 266/9692/9694 Our Reference Apps 20 A 0 0 our-reference-apps 266/9692
2456 2454 266/443/2454/2456 Parti di Ricambio 20 A 0 0 parti-di-ricambio-en 266/443/2454
932 930 266/930/932 Personalized Clothing 20 A 0 0 personalized-clothing 266/930
343 341 266/341/343 Pest Control 20 A 0 0 pest-control 266/341
2467 2465 266/2465/2467 Pet Trainer 20 A 0 0 pet-trainer-en 266/2465
1018 327 266/327/1018 Photo Studio 20 A 0 0 photo-studio 266/327
2436 2434 266/2433/2434/2436 Posa Contatore 20 A 0 0 posa-contatore-en 266/2433/2434
9945 9941 266/394/9941/9945 Quality Tyres 20 A 0 0 quality-tyres 266/394/9941
2388 2373 266/2373/2388 Recruitment 20 A 0 0 recruitment 266/2373
944 935 266/930/935/944 Shop Window Stickers 20 A 0 0 shop-window-stickers 266/930/935
1500 1498 266/1498/1500 Soil Reinforcement & Defense 20 A 0 0 soil-reinforcement-and-defense 266/1498
1315 715 266/715/1315 Technical Assistance 20 A 0 0 technical-assistance 266/715
2604 2577 266/2577/2604 Travel Tickets 20 A 0 0 travel-tickets-en 266/2577
1513 1510 266/443/1510/1513 Acoustic Insulations 30 A 0 0 acoustic-insulations 266/443/1510
9847 9844 266/9844/9847 Administrative 30 A 0 0 administrative-en 266/9844
397 341 266/341/397 Agricultural Pest Control 30 A 0 0 agricultural-pest-control 266/341
1417 929 266/356/929/1417 Bedroom 30 A 0 0 bedroom-service 266/356/929
10409 447 266/443/447/10409 Blinds 30 A 0 0 jaluzele 266/443/447
1524 1497 266/1498/1479/1497/1524 Blinds Repairs 30 A 0 0 blinds-repairs 266/1498/1479/1497
1911 1907 266/1907/1911 Body Treatments 30 A 0 0 body-treatments 266/1907
347 346 266/344/346/347 Boiler Assistance & Repair 30 A 0 0 boiler-assistance-and-repair 266/344/346
399 394 266/394/399 Car Wash 30 A 0 0 car-wash 266/394
2265 990 266/990/2265 Classical Arts 30 A 0 0 classical-arts 266/990
2540 2404 266/2404/2540 Cucina Francese 30 A 0 0 cucina-francese-en 266/2404
2371 2178 266/2178/2371 Dietician 30 A 0 0 dietician 266/2178
396 356 266/356/396 Displacement 30 A 0 0 displacement 266/356
9946 9941 266/394/9941/9946 Economic Tyres 30 A 0 0 economic-tyres 266/394/9941
2621 2173 266/2171/2173/2621 Festive Events 30 A 0 0 festive-events 266/2171/2173
1496 1479 266/1498/1479/1496 Hand Tools 30 A 0 0 hand-tools 266/1498/1479
1939 1936 266/1936/1939 Insurance 30 A 0 0 insurance 266/1936
446 443 266/443/446 Iron Workings 30 A 0 0 iron-workings 266/443
941 932 266/930/932/941 Logo for Professional Clothing 30 A 0 0 logo-for-professional-clothing 266/930/932
1306 2611 266/2611/1306 Mobile Presence 30 A 0 0 mobile-presence 266/2611
952 935 266/930/935/952 Mural Stickers 30 A 0 0 stickers-mural 266/930/935
2568 1695 266/327/1695/2568 Noleggio E- Bike 30 A 0 0 e-bike 266/327/1695
2437 2434 266/2433/2434/2437 Offerte Luce e Gas 30 A 0 0 offerte-luce-e-gas-en 266/2433/2434
1316 945 266/930/945/1316 Personalized Badges 30 A 0 0 personalized-badges 266/930/945
9957 2604 266/2577/2604/9957 Plane Tickets 30 A 0 0 plane-tickets 266/2577/2604
344 266 266/344 Plumbing & Electrical Services 30 A 0 0 plumbing-and-electrical-services 266
1693 1690 266/443/1690/1693 Recycling of Inert Materials 30 A 0 0 recycling-of-inert-materials 266/443/1690
1503 1500 266/1498/1500/1503 Reinforced Lands 30 A 0 0 reinforced-lands 266/1498/1500
1438 327 266/327/1438 Scaffolding 30 A 0 0 scaffolding 266/327
935 930 266/930/935 Stampe Stickers 30 A 0 0 stampe-stickers-en 266/930
2482 2478 266/2433/2478/2482 Support for women 30 A 0 0 support-for-women 266/2433/2478
2623 2577 266/2577/2623 Tours 30 A 0 0 tours-en 266/2577
1413 1410 266/443/1410/1413 Wall Tiling 30 A 0 0 wall-tiling 266/443/1410
2338 2580 266/1936/2580/2338 Bank Loans 40 A 0 0 bank-loans 266/1936/2580
1418 929 266/356/929/1418 Bathroom 40 A 0 0 bathroom 266/356/929
1497 1479 266/1498/1479/1497 Blacksmith Services 40 A 0 0 blacksmith-services 266/1498/1479
394 266 266/394 Car Services 40 A 0 0 car-services 266
1861 394 266/394/1861 Car Wrapping 40 A 0 0 car-wrapping 266/394
2372 2178 266/2178/2372 Check-Up 40 A 0 0 check-up 266/2178
9848 9844 266/9844/9848 commercial 40 A 0 0 commercial-lawservice 266/9844
2472 346 266/344/346/2472 Domestic Appliance Repair 40 A 0 0 appliance-repair 266/344/346
1694 1690 266/443/1690/1694 Excavations 40 A 0 0 excavations 266/443/1690
2587 2478 266/2433/2478/2587 Family Reunification 40 A 0 0 family-reunification-en 266/2433/2478
447 443 266/443/447 Fixtures 40 A 0 0 fixtures 266/443
2404 266 266/2404 Food Delivery 40 A 0 0 food-delivery-en 266
929 356 266/356/929 Furniture Assembly 40 A 0 0 furniture 266/356
1912 1907 266/1907/1912 Hand & Foot Treatments 40 A 0 0 hand-and-foot-treatments 266/1907
1695 327 266/327/1695 Means of Transport 40 A 0 0 means-of-transport 266/327
945 930 266/930/945 Personalized Office Products 40 A 0 0 personalized-office-products 266/930
10410 447 266/443/447/10410 PVC Carpentry 40 A 0 0 tamplarie-pvc 266/443/447
1521 1510 266/443/1510/1521 Roof Insulation 40 A 0 0 roof-insulation 266/443/1510
1525 1497 266/1498/1479/1497/1525 Shutters Repairs 40 A 0 0 shutters-repairs-en 266/1498/1479/1497
9867 2577 266/2577/9867 Tour Packages 40 A 0 0 tour-packages-en 266/2577
1504 1500 266/1498/1500/1504 Trenches & Drains 40 A 0 0 trenches-and-drains 266/1498/1500
348 344 266/344/348 Unblocking Pipes 40 A 0 0 unblocking-pipes 266/344
1414 1410 266/443/1410/1414 Wall Texturing 40 A 0 0 wall-texturing 266/443/1410
2581 2580 266/1936/2580/2581 Banking Consultancy 50 A 0 0 banking-consultancy-en 266/1936/2580
2389 394 266/394/2389 Car Sales 50 A 0 0 car-sales 266/394
9855 9844 266/9844/9855 Civil Cases 50 A 0 0 civil-cases 266/9844
443 266 266/443 Construction 50 A 0 0 construction 266
10411 447 266/443/447/10411 Door 50 A 0 0 usile 266/443/447
1913 1907 266/1907/1913 Hair Treatments 50 A 0 0 hair-treatments 266/1907
1427 1410 266/443/1410/1427 Parquet Installation 50 A 0 0 parquet-installation 266/443/1410
8944 930 266/930/8944 Personalized Supplies 50 A 0 0 personalized-supplies 266/930
2528 327 266/327/2528 Printer - Photocopy 50 A 0 0 printer-photocopy-for-rent 266/327
2559 2178 266/2178/2559 Psychotherapy 50 A 0 0 psychoterapy-en 266/2178
2579 1936 266/1936/2579 Revenue Agencies 50 A 0 0 revenue-agencies-en 266/1936
9920 2577 266/2577/9920 Room Type 50 A 0 0 room-type 266/2577
349 344 266/344/349 Sewer Purge 50 A 0 0 sewer-purge 266/344
1419 929 266/356/929/1419 Studio & Office 50 A 0 0 studio-and-office 266/356/929
1409 443 266/443/1409 Wall Painting 50 A 0 0 wall-painting-en 266/443
2542 1510 266/443/1510/2542 Waterproofing 50 A 0 0 waterproofing 266/443/1510
2566 327 266/327/2566 Apartments to Rent 60 A 0 0 apartments-rent 266/327
2580 1936 266/1936/2580 Bank Services 60 A 0 0 bank-services-en 266/1936
1420 929 266/356/929/1420 Bar & Restaurant 60 A 0 0 bar-and-restaurant 266/356/929
2176 2433 266/2433/2176 Beauty Products Consultant 60 A 0 0 beauty-products-consultant 266/2433
2554 394 266/394/2554 Colonnine di Ricarica per Auto 60 A 0 0 colonnine-di-ricarica-per-auto-en 266/394
352 344 266/344/352 De-flooding Services 60 A 0 0 de-flooding-services 266/344
1936 266 266/1936 Economy & Finance Services 60 A 0 0 economy-and-finance-services 266
9856 9844 266/9844/9856 Family Matters 60 A 0 0 family-cases-en 266/9844
1410 443 266/443/1410 Floor & Wall Tiling 60 A 0 0 floor-and-wall-tiling 266/443
10247 2577 266/2577/10247 Guides 60 A 0 0 guides 266/2577
2582 2580 266/1936/2580/2582 Payments & Transactions 60 A 0 0 payments-and-transactions-en 266/1936/2580
1508 1410 266/443/1410/1508 Resin Floors 60 A 0 0 resin-floors 266/443/1410
9961 930 266/930/9961 Textiles 60 A 0 0 textiles 266/930
1907 266 266/1907 Beauty & Wellness 65 A 0 0 wellness 266
990 266 266/990 Art & Photography 70 A 0 0 art-and-photography 266
2478 2433 266/2433/2478 Assistance and Social Services 70 A 0 0 assistance-and-social-services 266/2433
1505 443 266/443/1505 Carpenter 70 A 0 0 carpenter 266/443
2180 1907 266/1907/2180 Hairstylist & Hairdressers 70 A 0 0 hairstylist-and-hairdressers 266/1907
9294 394 266/394/9294 Hydrogen Engine Cleaning 70 A 0 0 hydrogen-engine-cleaning 266/394
10413 447 266/443/447/10413 Insect Nets 70 A 0 0 plase-insecte-en 266/443/447
2567 327 266/327/2567 Noleggio Camera 70 A 0 0 noleggio-camera-en 266/327
9857 9844 266/9844/9857 Pharmaceutical & Medical System Regulator 70 A 0 0 pharmaceutical-medical-system-regulator 266/9844
1520 1410 266/443/1410/1520 Plasterboard Walls 70 A 0 0 plasterboard-walls 266/443/1410
10248 2577 266/2577/10248 Skiing 70 A 0 0 ski 266/2577
2583 1936 266/1936/2583 Transfers of Ownership 70 A 0 0 transfers-of-ownership-en 266/1936
2541 929 266/356/929/2541 Urban furniture 70 A 0 0 urban-furniture 266/356/929
2584 1936 266/1936/2584 Certifications 80 A 0 0 certifications-en 266/1936
1509 443 266/443/1509 Concrete Works 80 A 0 0 concrete-works 266/443
9858 9844 266/9844/9858 Financial Issues 80 A 0 0 financial-cases-en 266/9844
2597 327 266/327/2597 Itinerant Equipment Rental 80 A 0 0 itinerant-equipment 266/327
9849 1907 266/1907/9849 Makeup 80 A 0 0 makeup 266/1907
2549 2433 266/2433/2549 Tender Information 80 A 0 0 tender-info 266/2433
2599 1695 266/327/1695/2599 Car Rental 90 A 0 0 car-rental-en 266/327/1695
2585 1936 266/1936/2585 Compilations 90 A 0 0 compilations-en 266/1936
9864 1907 266/1907/9864 Hair removal 90 A 0 0 hair-removal-en 266/1907
9859 9844 266/9844/9859 Immigration Issues 90 A 0 0 immigration-cases-en 266/9844
1510 443 266/443/1510 Insulation 90 A 0 0 insulation 266/443
1479 1498 266/1498/1479 Mechanics & Metallurgy 90 A 0 0 mechanics-and-metallurgy 266/1498
2602 1695 266/327/1695/2602 Motorcycle Rental 90 A 0 0 motocycle-rental 266/327/1695
930 266 266/930 Personalized Products 90 A 0 0 personalized-products 266
1303 1584 266/1584/1303 Time Attendance Services 90 A 0 0 time-attendance-services 266/1584
2586 1936 266/1936/2586 Authentications 100 A 0 0 authentications-en 266/1936
1518 443 266/443/1518 Ceilings 100 A 0 0 ceilings 266/443
1498 266 266/1498 Engineering & Transportation 100 A 0 0 engineering-and-transportation 266
9860 9844 266/9844/9860 Property Issues 100 A 0 0 property-cases-en 266/9844
1309 1584 266/1584/1309 Security Systems 100 A 0 0 security-systems 266/1584
2386 1498 266/1498/2386 Transportation Services 100 A 0 0 transportation-service 266/1498
1690 443 266/443/1690 Construction Site 110 A 0 0 construction-site 266/443
1506 356 266/356/1506 Garden Maintenance 110 A 0 0 garden-maintenance 266/356
2473 1584 266/1584/2473 LED Panels 110 A 0 0 led-panels 266/1584
9861 9844 266/9844/9861 Legal Mediation 110 A 0 0 legal-mediation 266/9844
2601 1936 266/1936/2601 Payments and Telephone Top-ups 110 A 0 0 payments-and-telephone-top-ups-en 266/1936
2469 1498 266/1498/2469 Road Reinforcements 110 A 0 0 road-reinforcements 266/1498
341 266 266/341 Sanitizing 110 A 0 0 sanitizing 266
9929 1936 266/1936/9929 Company Support 120 A 0 0 company-support 266/1936
1714 356 266/356/1714 Courier Service 120 A 0 0 courier-service 266/356
2553 1498 266/1498/2553 Electricity production 120 A 0 0 electricity-production-en 266/1498
2596 1584 266/1584/2596 Equipment Maintenance 120 A 0 0 equipments-maintenance 266/1584
9862 9844 266/9844/9862 Legal Documents 120 A 0 0 legal-documents 266/9844
2454 443 266/443/2454 Riparazione Mobili 120 A 0 0 riparazione-mobili 266/443
9863 9844 266/9844/9863 Employment Issues 130 A 0 0 employment-cases-en 266/9844
1715 356 266/356/1715 Real Estate 130 A 0 0 real-estate 266/356
2613 1584 266/1584/2613 Solar Energy System 130 A 0 0 solar-energy-system-en 266/1584
1914 356 266/356/1914 Awnings 140 A 0 0 awnings 266/356
9958 1584 266/1584/9958 Electronic Locks 140 A 0 0 electronic-locks 266/1584
9865 9844 266/9844/9865 Legal Services 140 A 0 0 legal-services-en 266/9844
327 266 266/327 Rental 140 A 0 0 rental 266
9866 9844 266/9844/9866 Advocacy Services 150 A 0 0 advocacy-services-en 266/9844
715 266 266/715 After-Sale Services 150 A 0 0 after-sale-services 266
2397 356 266/356/2397 Hardware & Tools 150 A 0 0 hardware-and-tools-en 266/356
2171 266 266/2171 Gifts & Events 160 A 0 0 gifts-and-events 266
9918 9844 266/9844/9918 Investigation Services 160 A 0 0 investigation-services 266/9844
2468 356 266/356/2468 Pool maintenance 160 A 0 0 pool-maintenance-en 266/356
2529 356 266/356/2529 Business & Office Services 170 A 0 0 bussines-and-office-services 266/356
2178 266 266/2178 Health Care Services 170 A 0 0 health-care-services-en 266
9919 9844 266/9844/9919 Visas and Permits 170 A 0 0 visas-and-permits 266/9844
2373 266 266/2373 Jobs & Education 180 A 0 0 jobs-and-education 266
2552 356 266/356/2552 Various supplies 180 A 0 0 various-supplies-en 266/356
2433 266 266/2433 Consulting and Various Offers 190 A 0 0 consulting-and-various-offers 266
9290 356 266/356/9290 Internet Services 190 A 0 0 internet-services 266/356
2465 266 266/2465 Pet Care 200 A 0 0 pet-care-en 266
2577 266 266/2577 Holidays and Travel 210 A 0 0 holiday-travel 266
2591 266 266/2591 Security and Protection 220 A 0 0 security-protection 266
2611 266 266/2611 Phones and Smartphones 230 A 0 0 phones-smartphones 266
2615 266 266/2615 Music and Sounds 240 A 0 0 music-sound 266
9692 266 266/9692 Programming and Tech 250 A 0 0 programming-and-tech 266
9830 266 266/9830 Electric Energy and Natural Gas 260 A 0 0 electric-energy-and-natural-gas 266
2603 991 266/990/991/2603 Development, Digitization and Photo Printing 280 A 0 0 development-digitization-and-photo-printing-en 266/990/991
2595 344 266/344/2595 Fixed Water Systems 280 A 0 0 fixed-water-systems-en 266/344
2593 2591 266/2591/2593 Private Security Guard 280 A 0 0 private-security-guard-en 266/2591
2610 443 266/443/2610 Stone Processing 280 A 0 0 stone-processing-en 266/443
2634 443 266/443/2634 Architectural Design 290 A 0 0 architectural-design-en 266/443
2594 2591 266/2591/2594 Surveillance and Television Service 290 A 0 0 surveillance-and-television-service-en 266/2591
9840 266 266/9840 Training In The Place Of Advice And Various Offers 290 A 0 0 training-in-the-place-of-advice-and-various-offers 266
9264 344 266/344/9264 Water Filtration Systems 290 A 0 0 water-filtration-systems 266/344
9844 266 266/9844 Legal Services 300 A 0 0 law-services 266
9842 443 266/443/9842 ​Thermal Insulation 300 A 0 0 thermal-insulation 266/443
9843 443 266/443/9843 Surface and Material Recovery Treatments 310 A 0 0 surface-and-material-recovery-treatments 266/443
9926 266 266/9926 Venue Booking 310 A 0 0 venue-booking 266
9936 266 266/9936 Funeral Services 320 A 0 0 funeral-services 266
10425 443 266/443/10425 Wooden House 320 A 0 0 shtepi-druri 266/443
10631 266 266/10631 Hidrosanitare 330 A 0 0 hidrosanitare 266
10426 443 266/443/10426 Roof 330 A 0 0 cati 266/443
10632 266 266/10632 Sisteme Ngrohje - Ftohje 340 A 0 0 sisteme-ngrohje-ftohje 266
10633 266 266/10633 Hidraulike 350 A 0 0 hidraulike 266
2638 346 266/344/346/2638 Air Conditioning Systems 1030 A 0 0 air-conditioning-systems-en 266/344/346
9623 394 266/394/9623 Driving School 2020 A 0 0 driving-school 266/394
9921 394 266/394/9921 Auto Servis 2030 A 0 0 auto-servis-en 266/394
9922 394 266/394/9922 Vulcanizer 2040 A 0 0 vulcanizer 266/394
9923 394 266/394/9923 Car Insurance 2050 A 0 0 car-insurance 266/394
9924 394 266/394/9924 Car Financials 2060 A 0 0 car-financials 266/394
9940 394 266/394/9940 Lubricants 2070 A 0 0 lubricants 266/394
9941 394 266/394/9941 Tyres 2080 A 0 0 tyres 266/394
9942 394 266/394/9942 Battery 2090 A 0 0 battery 266/394
9943 394 266/394/9943 Spare Parts 2100 A 0 0 spare-parts 266/394