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_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 = 'ro' 
  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 = 'ro' 
  AND cscart_seo_names.company_id = cscart_categories.company_id 
WHERE 
  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 '290/1035/%' 
  AND cscart_categories.company_id = 1 
ORDER BY 
  cscart_categories.is_trash asc, 
  cscart_categories.position asc, 
  cscart_category_descriptions.category asc

Query time 0.00514

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "181.76"
    },
    "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": 208,
            "rows_produced_per_join": 2,
            "filtered": "1.00",
            "index_condition": "(`maniamall_cscart`.`cscart_categories`.`id_path` like '290/1035/%')",
            "cost_info": {
              "read_cost": "177.25",
              "eval_cost": "0.21",
              "prefix_cost": "177.46",
              "data_read_per_join": "5K"
            },
            "used_columns": [
              "category_id",
              "parent_id",
              "id_path",
              "company_id",
              "usergroup_ids",
              "status",
              "position",
              "is_trash"
            ],
            "attached_condition": "((`maniamall_cscart`.`cscart_categories`.`company_id` = 1) and ((`maniamall_cscart`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`))) and (`maniamall_cscart`.`cscart_categories`.`status` = 'A'))"
          }
        },
        {
          "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": [
              "maniamall_cscart.cscart_categories.category_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 2,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.84",
              "eval_cost": "0.21",
              "prefix_cost": "179.50",
              "data_read_per_join": "6K"
            },
            "used_columns": [
              "category_id",
              "lang_code",
              "category"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_seo_names",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code",
              "company_id"
            ],
            "key_length": "210",
            "ref": [
              "maniamall_cscart.cscart_categories.category_id",
              "const",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 2,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.05",
              "eval_cost": "0.21",
              "prefix_cost": "181.76",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "name",
              "object_id",
              "company_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}

Result

category_id parent_id id_path category position status company_id seo_name seo_path
5111 1035 290/1035/5111 Navigatii Playere Multimedia 5 A 1 navigatii-playere-multimedia 290/1035
5365 5111 290/1035/5111/5365 Navigatii Auto Universale 10 A 1 navigatii-auto-universale 290/1035/5111
23282 1035 290/1035/23282 Accesorii Multimedia 90 A 1 accesorii-multimedia 290/1035
8908 1035 290/1035/8908 Accesorii Sonorizare Auto 90 A 1 accesorii-sonorizare-auto 290/1035
23399 23282 290/1035/23282/23399 Accesorii Telefoane 90 A 1 accesorii-telefoane-ro 290/1035/23282
20794 20793 290/1035/20793/20794 adaptori Kit Xenon 90 A 1 adaptori-kit-xenon-ro 290/1035/20793
6628 1035 290/1035/6628 Aeroterme Auto 90 A 1 aeroterme-auto 290/1035
2699 1266 290/1035/1266/2699 Alarme Auto 90 A 1 alarme-auto 290/1035/1266
20792 19541 290/1035/19541/20792 alarme Auto 90 A 1 alarme-auto-ro-2 290/1035/19541
1266 1035 290/1035/1266 Alarme Inchideri Centralizate si Senzori Parcare 90 A 1 alarme-inchideri-centralizate-si-senzori-parcare 290/1035
19445 1035 290/1035/19445 alte Accesorii Electrice 90 A 1 alte-accesorii-electrice-ro 290/1035
1201 1035 290/1035/1201 Amplificator Statie Auto 90 A 1 amplificator-statie-auto 290/1035
1044 1035 290/1035/1044 Antene Auto 90 A 1 antene-auto 290/1035
29881 1035 290/1035/29881 Anulatori eroare bec ars 90 A 1 anulatori-eroare-bec-ars 290/1035
23265 23264 290/1035/23264/23265 Aparataje Electrice 90 A 1 aparataje-electrice 290/1035/23264
20975 1035 290/1035/20975 aspiratoare Auto 90 A 1 aspiratoare-auto-ro-2 290/1035
20835 20793 290/1035/20793/20835 balast Xenon 90 A 1 balast-xenon-ro 290/1035/20793
20830 19445 290/1035/19445/20830 banda Cu Leduri 90 A 1 banda-cu-leduri-ro 290/1035/19445
8781 1035 290/1035/8781 Baterie Cheie Auto 90 A 1 baterie-cheie-auto 290/1035
23252 1035 290/1035/23252 Baterii 90 A 1 baterii-ro-2 290/1035
23255 23252 290/1035/23252/23255 Baterii 90 A 1 baterii-ro-3 290/1035/23252
20827 19541 290/1035/19541/20827 baterii Telecomanda 90 A 1 baterii-telecomanda 290/1035/19541
21157 20793 290/1035/20793/21157 bec Hid Xenon 90 A 1 bec-hid-xenon-ro 290/1035/20793
1325 1035 290/1035/1325 Becuri Auto 90 A 1 becuri-auto 290/1035
23307 23306 290/1035/23306/23307 Becuri Cu Led 90 A 1 becuri-cu-led 290/1035/23306
2696 2686 290/1035/2686/2696 Becuri Xenon 90 A 1 becuri-xenon 290/1035/2686
23323 23306 290/1035/23306/23323 Benzi Cu Led 90 A 1 benzi-cu-led 290/1035/23306
1090 1035 290/1035/1090 Boxe Auto 90 A 1 boxe-auto 290/1035
2706 1035 290/1035/2706 Brichete Auto 90 A 1 brichete-auto 290/1035
20834 19541 290/1035/19541/20834 brichete Auto Si Prize Masina 90 A 1 brichete-auto-si-prize-masina-ro 290/1035/19541
8780 1035 290/1035/8780 Butoane Electrice Chei Auto 90 A 1 butoane-electrice-chei-auto 290/1035
23256 1035 290/1035/23256 Cabluri 90 A 1 cabluri-ro 290/1035
1375 1035 290/1035/1375 Cabluri Audio Putere 90 A 1 cabluri-audio-putere 290/1035
23262 23258 290/1035/23258/23262 Cabluri Audio-video Hdmi 90 A 1 cabluri-audio-video-hdmi 290/1035/23258
28622 23258 290/1035/23258/28622 Cabluri De Telefon 90 A 1 cabluri-de-telefon 290/1035/23258
23855 23256 290/1035/23256/23855 Cabluri Difuzoare 90 A 1 cabluri-difuzoare 290/1035/23256
23840 23258 290/1035/23258/23840 Cabluri It 90 A 1 cabluri-it 290/1035/23258
23258 1035 290/1035/23258 Cabluri Montate 90 A 1 cabluri-montate 290/1035
19548 19541 290/1035/19541/19548 camera Marsarier 90 A 1 camera-marsarier 290/1035/19541
19577 19541 290/1035/19541/19577 camere Auto Dvr 90 A 1 camere-auto-dvr-ro-3 290/1035/19541
21091 19541 290/1035/19541/21091 car Kit 90 A 1 car-kit-ro 290/1035/19541
5187 1035 290/1035/5187 Car Kit Bluetooth Handsfree 90 A 1 car-kit-bluetooth-handsfree 290/1035
23276 23230 290/1035/23230/23276 Ciocane De Lipit 90 A 1 ciocane-de-lipit 290/1035/23230
23230 1035 290/1035/23230 Ciocane Si Statii De Lipit 90 A 1 ciocane-si-statii-de-lipit 290/1035
19566 1035 290/1035/19566 claxoane Auto 90 A 1 claxoane-auto-ro-2 290/1035
5772 1035 290/1035/5772 Compresoare Auto 90 A 1 compresoare-auto 290/1035
5716 1035 290/1035/5716 Convertoare Auto 90 A 1 convertoare-auto 290/1035
19491 19445 290/1035/19445/19491 cutie Sigurante Si Cutie Conectori 90 A 1 cutie-sigurante-si-cutie-conectori 290/1035/19445
13057 1035 290/1035/13057 Diagnoza Auto 90 A 1 diagnoza-auto 290/1035
20927 20924 290/1035/19541/20924/20927 difuzoare Auto 90 A 1 difuzoare-auto 290/1035/19541/20924
19446 19445 290/1035/19445/19446 diverse 90 A 1 diverse-ro-18 290/1035/19445
1345 1035 290/1035/1345 Diverse Auto 90 A 1 diverse-auto 290/1035
23847 23277 290/1035/23277/23847 Dome 90 A 1 dome 290/1035/23277
23264 1035 290/1035/23264 Electronica Generala 90 A 1 electronica-generala 290/1035
19541 1035 290/1035/19541 electronice Auto 90 A 1 electronice-auto-ro 290/1035
1310 1035 290/1035/1310 Filtre Auto Diverse 90 A 1 filtre-auto-diverse 290/1035
19540 1035 290/1035/19540 girofaruri Auto 90 A 1 girofaruri-auto-ro 290/1035
2700 1035 290/1035/2700 Inchideri Centralizate 90 A 1 inchideri-centralizate 290/1035
19497 1035 290/1035/19497 intrerupatoare Comutatoare 90 A 1 intrerupatoare-comutatoare-ro 290/1035
1318 1131 290/1035/1131/1318 Invertoare 12V 90 A 1 invertoare-12v 290/1035/1131
1131 1035 290/1035/1131 Invertoare Tensiune Auto 90 A 1 invertoare-tensiune-auto 290/1035
21323 1035 290/1035/21323 kit Incalzire Scaune Auto 90 A 1 kit-incalzire-scaune-auto-ro 290/1035
20793 1035 290/1035/20793 kituri Hid Xenon 90 A 1 kituri-hid-xenon-ro 290/1035
20968 20793 290/1035/20793/20968 kituri Xenon 90 A 1 kituri-xenon-ro 290/1035/20793
20923 19445 290/1035/19445/20923 lamela Cheie Auto 90 A 1 lamela-cheie-auto-ro 290/1035/19445
21141 19445 290/1035/19445/21141 lanterna 90 A 1 lanterna-ro 290/1035/19445
2689 1035 290/1035/2689 Leduri Auto 90 A 1 leduri-auto 290/1035
23306 1035 290/1035/23306 Lumini 90 A 1 lumini 290/1035
23393 23306 290/1035/23306/23393 Lumini De Craciun 90 A 1 lumini-de-craciun 290/1035/23306
23332 23306 290/1035/23306/23332 Lumini De Veghe 90 A 1 lumini-de-veghe 290/1035/23306
19542 19541 290/1035/19541/19542 modul Inchidere Centralizata 90 A 1 modul-inchidere-centralizata-ro 290/1035/19541
1306 1035 290/1035/1306 Modulatoare FM 90 A 1 modulatoare-fm 290/1035
2702 2700 290/1035/2700/2702 Module Inchideri Centralizate 90 A 1 module-inchideri-centralizate 290/1035/2700
7162 1035 290/1035/7162 Monitoare TV Auto 90 A 1 monitoare-tv-auto 290/1035
7203 7201 290/1035/5111/7201/7203 Navigatie Alfa Romeo 159 90 A 1 navigatie-alfa-romeo-159 290/1035/5111/7201
7204 7201 290/1035/5111/7201/7204 Navigatie Alfa Romeo Brera 90 A 1 navigatie-alfa-romeo-brera 290/1035/5111/7201
7202 7201 290/1035/5111/7201/7202 Navigatie Alfa Romeo Spider 90 A 1 navigatie-alfa-romeo-spider 290/1035/5111/7201
7205 7201 290/1035/5111/7201/7205 Navigatie Alfa Romeo Sportwagon 90 A 1 navigatie-alfa-romeo-sportwagon 290/1035/5111/7201
7212 5375 290/1035/5111/5375/7212 Navigatie Audi TT 90 A 1 navigatie-audi-tt 290/1035/5111/5375
5432 5384 290/1035/5111/5384/5432 Navigatie BMW Seria 1 90 A 1 navigatie-bmw-seria-1 290/1035/5111/5384
7230 5384 290/1035/5111/5384/7230 Navigatie BMW Seria 2 90 A 1 navigatie-bmw-seria-2 290/1035/5111/5384
5417 5384 290/1035/5111/5384/5417 Navigatie BMW Seria 3 90 A 1 navigatie-bmw-seria-3 290/1035/5111/5384
7233 5384 290/1035/5111/5384/7233 Navigatie BMW Seria 4 90 A 1 navigatie-bmw-seria-4 290/1035/5111/5384
5385 5384 290/1035/5111/5384/5385 Navigatie BMW Seria 5 90 A 1 navigatie-bmw-seria-5 290/1035/5111/5384
7231 5384 290/1035/5111/5384/7231 Navigatie BMW X3 90 A 1 navigatie-bmw-x3 290/1035/5111/5384
5386 5384 290/1035/5111/5384/5386 Navigatie BMW X5 90 A 1 navigatie-bmw-x5 290/1035/5111/5384
7232 5384 290/1035/5111/5384/7232 Navigatie BMW X6 90 A 1 navigatie-bmw-x6 290/1035/5111/5384
5752 5747 290/1035/5111/5747/5752 Navigatie Dacia Dokker 90 A 1 navigatie-dacia-dokker 290/1035/5111/5747
5748 5747 290/1035/5111/5747/5748 Navigatie Dacia Duster 90 A 1 navigatie-dacia-duster 290/1035/5111/5747
5751 5747 290/1035/5111/5747/5751 Navigatie Dacia Lodgy 90 A 1 navigatie-dacia-lodgy 290/1035/5111/5747
5749 5747 290/1035/5111/5747/5749 Navigatie Dacia Logan 90 A 1 navigatie-dacia-logan 290/1035/5111/5747
5750 5747 290/1035/5111/5747/5750 Navigatie Dacia Sandero 90 A 1 navigatie-dacia-sandero 290/1035/5111/5747
7196 7195 290/1035/5111/7195/7196 Navigatie Daihatsu Be Go 90 A 1 navigatie-daihatsu-be-go 290/1035/5111/7195
7200 7195 290/1035/5111/7195/7200 Navigatie Daihatsu Perodua Nautica 90 A 1 navigatie-daihatsu-perodua-nautica 290/1035/5111/7195
7199 7195 290/1035/5111/7195/7199 Navigatie Daihatsu Terios 90 A 1 navigatie-daihatsu-terios 290/1035/5111/7195
7209 7208 290/1035/5111/7208/7209 Navigatie Fiat Bravo 90 A 1 navigatie-fiat-bravo 290/1035/5111/7208
7182 5388 290/1035/5111/5388/7182 Navigatie Hyundai IX35 90 A 1 navigatie-hyundai-ix35 290/1035/5111/5388
7181 5388 290/1035/5111/5388/7181 Navigatie Hyundai Tucson 90 A 1 navigatie-hyundai-tucson 290/1035/5111/5388
7217 7216 290/1035/5111/7216/7217 Navigatie Land Rover Freelander 90 A 1 navigatie-land-rover-freelander 290/1035/5111/7216
7215 7214 290/1035/5111/7214/7215 Navigatie Mazda 3 90 A 1 navigatie-mazda-3 290/1035/5111/7214
7207 5377 290/1035/5111/5377/7207 Navigatie Mercedes Clasa CL 90 A 1 navigatie-mercedes-clasa-cl 290/1035/5111/5377
7206 5377 290/1035/5111/5377/7206 Navigatie Mercedes Clasa S 90 A 1 navigatie-mercedes-clasa-s 290/1035/5111/5377
7211 5390 290/1035/5111/5390/7211 Navigatie Opel Insignia 90 A 1 navigatie-opel-insignia 290/1035/5111/5390
7210 5390 290/1035/5111/5390/7210 Navigatie Opel Vauxhall 90 A 1 navigatie-opel-vauxhall 290/1035/5111/5390
5406 5390 290/1035/5111/5390/5406 Navigatie Opel Vectra 90 A 1 navigatie-opel-vectra 290/1035/5111/5390
5754 5753 290/1035/5111/5753/5754 Navigatie Renault Captur 90 A 1 navigatie-renault-captur 290/1035/5111/5753
5755 5753 290/1035/5111/5753/5755 Navigatie Renault Symbol 90 A 1 navigatie-renault-symbol 290/1035/5111/5753
5149 5145 290/1035/5111/5145/5149 Navigatie Seat Alhambra 90 A 1 navigatie-seat-alhambra 290/1035/5111/5145
5146 5145 290/1035/5111/5145/5146 Navigatie Seat Altea 90 A 1 navigatie-seat-altea 290/1035/5111/5145
7213 5145 290/1035/5111/5145/7213 Navigatie Seat Ibiza 90 A 1 navigatie-seat-ibiza 290/1035/5111/5145
5148 5145 290/1035/5111/5145/5148 Navigatie Seat Leon 90 A 1 navigatie-seat-leon 290/1035/5111/5145
5147 5145 290/1035/5111/5145/5147 Navigatie Seat Toledo 90 A 1 navigatie-seat-toledo 290/1035/5111/5145
5139 5135 290/1035/5111/5135/5139 Navigatie Skoda Fabia 90 A 1 navigatie-skoda-fabia 290/1035/5111/5135
5136 5135 290/1035/5111/5135/5136 Navigatie Skoda Octavia 1 90 A 1 navigatie-skoda-octavia-1 290/1035/5111/5135
5137 5135 290/1035/5111/5135/5137 Navigatie Skoda Octavia 2 90 A 1 navigatie-skoda-octavia-2 290/1035/5111/5135
5138 5135 290/1035/5111/5135/5138 Navigatie Skoda Octavia 3 90 A 1 navigatie-skoda-octavia-3 290/1035/5111/5135
5141 5135 290/1035/5111/5135/5141 Navigatie Skoda Praktik 90 A 1 navigatie-skoda-praktik 290/1035/5111/5135
5140 5135 290/1035/5111/5135/5140 Navigatie Skoda Rapid 90 A 1 navigatie-skoda-rapid 290/1035/5111/5135
5142 5135 290/1035/5111/5135/5142 Navigatie Skoda Roomster 90 A 1 navigatie-skoda-roomster 290/1035/5111/5135
5144 5135 290/1035/5111/5135/5144 Navigatie Skoda Superb 2 90 A 1 navigatie-skoda-superb-2 290/1035/5111/5135
5143 5135 290/1035/5111/5135/5143 Navigatie Skoda Yeti 90 A 1 navigatie-skoda-yeti 290/1035/5111/5135
7184 7183 290/1035/5111/7183/7184 Navigatie Smart Fortwo 90 A 1 navigatie-smart-fortwo 290/1035/5111/7183
7191 7190 290/1035/5111/7190/7191 Navigatie Subaru Forester 90 A 1 navigatie-subaru-forester 290/1035/5111/7190
7192 7190 290/1035/5111/7190/7192 Navigatie Subaru Impreza 90 A 1 navigatie-subaru-impreza 290/1035/5111/7190
7198 7185 290/1035/5111/7185/7198 Navigatie Toyota Altis 90 A 1 navigatie-toyota-altis 290/1035/5111/7185
7197 7185 290/1035/5111/7185/7197 Navigatie Toyota Avensis 90 A 1 navigatie-toyota-avensis 290/1035/5111/7185
7194 7185 290/1035/5111/7185/7194 Navigatie Toyota Celica 90 A 1 navigatie-toyota-celica 290/1035/5111/7185
7186 7185 290/1035/5111/7185/7186 Navigatie Toyota Corolla 90 A 1 navigatie-toyota-corolla 290/1035/5111/7185
7189 7185 290/1035/5111/7185/7189 Navigatie Toyota Hilux 90 A 1 navigatie-toyota-hilux 290/1035/5111/7185
7193 7185 290/1035/5111/7185/7193 Navigatie Toyota Land Cruiser 90 A 1 navigatie-toyota-land-cruiser 290/1035/5111/7185
7187 7185 290/1035/5111/7185/7187 Navigatie Toyota RAV4 90 A 1 navigatie-toyota-rav4 290/1035/5111/7185
7188 7185 290/1035/5111/7185/7188 Navigatie Toyota Yaris 90 A 1 navigatie-toyota-yaris 290/1035/5111/7185
5122 5112 290/1035/5111/5112/5122 Navigatie Vw Amarok 90 A 1 navigatie-vw-amarok 290/1035/5111/5112
5130 5112 290/1035/5111/5112/5130 Navigatie Vw Beetle 90 A 1 navigatie-vw-beetle 290/1035/5111/5112
5134 5112 290/1035/5111/5112/5134 Navigatie Vw Bora 90 A 1 navigatie-vw-bora 290/1035/5111/5112
5118 5112 290/1035/5111/5112/5118 Navigatie Vw Caddy 90 A 1 navigatie-vw-caddy 290/1035/5111/5112
5132 5112 290/1035/5111/5112/5132 Navigatie Vw Caravelle 90 A 1 navigatie-vw-caravelle 290/1035/5111/5112
5120 5112 290/1035/5111/5112/5120 Navigatie Vw Eos 90 A 1 navigatie-vw-eos 290/1035/5111/5112
5115 5112 290/1035/5111/5112/5115 Navigatie Vw Golf 5 90 A 1 navigatie-vw-golf-5 290/1035/5111/5112
5116 5112 290/1035/5111/5112/5116 Navigatie Vw Golf 6 90 A 1 navigatie-vw-golf-6 290/1035/5111/5112
5133 5112 290/1035/5111/5112/5133 Navigatie Vw Golf Plus 90 A 1 navigatie-vw-golf-plus 290/1035/5111/5112
5124 5112 290/1035/5111/5112/5124 Navigatie Vw Jetta 90 A 1 navigatie-vw-jetta 290/1035/5111/5112
5126 5112 290/1035/5111/5112/5126 Navigatie Vw Magotan 90 A 1 navigatie-vw-magotan 290/1035/5111/5112
5131 5112 290/1035/5111/5112/5131 Navigatie Vw Multivan 90 A 1 navigatie-vw-multivan 290/1035/5111/5112
5366 5112 290/1035/5111/5112/5366 Navigatie Vw Passat 90 A 1 navigatie-vw-passat 290/1035/5111/5112
5113 5112 290/1035/5111/5112/5113 Navigatie Vw Passat B6 90 A 1 navigatie-vw-passat-b6 290/1035/5111/5112
5114 5112 290/1035/5111/5112/5114 Navigatie Vw Passat B7 90 A 1 navigatie-vw-passat-b7 290/1035/5111/5112
5127 5112 290/1035/5111/5112/5127 Navigatie Vw Passat Cc 90 A 1 navigatie-vw-passat-cc 290/1035/5111/5112
5117 5112 290/1035/5111/5112/5117 Navigatie Vw Polo 90 A 1 navigatie-vw-polo 290/1035/5111/5112
5125 5112 290/1035/5111/5112/5125 Navigatie Vw Sagitar 90 A 1 navigatie-vw-sagitar 290/1035/5111/5112
5121 5112 290/1035/5111/5112/5121 Navigatie Vw Scirocco 90 A 1 navigatie-vw-scirocco 290/1035/5111/5112
5123 5112 290/1035/5111/5112/5123 Navigatie Vw Sharan 90 A 1 navigatie-vw-sharan 290/1035/5111/5112
5128 5112 290/1035/5111/5112/5128 Navigatie Vw Tiguan 90 A 1 navigatie-vw-tiguan 290/1035/5111/5112
5119 5112 290/1035/5111/5112/5119 Navigatie Vw Touran 90 A 1 navigatie-vw-touran 290/1035/5111/5112
5129 5112 290/1035/5111/5112/5129 Navigatie Vw Transporter 90 A 1 navigatie-vw-transporter 290/1035/5111/5112
7201 5111 290/1035/5111/7201 Navigatii Alfa Romeo 90 A 1 navigatii-alfa-romeo 290/1035/5111
5375 5111 290/1035/5111/5375 Navigatii Audi 90 A 1 navigatii-audi 290/1035/5111
5384 5111 290/1035/5111/5384 Navigatii BMW 90 A 1 navigatii-bmw 290/1035/5111
5747 5111 290/1035/5111/5747 Navigatii Dacia 90 A 1 navigatii-dacia 290/1035/5111
7195 5111 290/1035/5111/7195 Navigatii Daihatsu 90 A 1 navigatii-daihatsu 290/1035/5111
7208 5111 290/1035/5111/7208 Navigatii Fiat 90 A 1 navigatii-fiat 290/1035/5111
5371 5111 290/1035/5111/5371 Navigatii Ford 90 A 1 navigatii-ford 290/1035/5111
23465 5111 290/1035/5111/23465 Navigatii Honda 90 A 1 navigatii-honda 290/1035/5111
5388 5111 290/1035/5111/5388 Navigatii Hyundai 90 A 1 navigatii-hyundai 290/1035/5111
7216 5111 290/1035/5111/7216 Navigatii Land Rover 90 A 1 navigatii-land-rover 290/1035/5111
7214 5111 290/1035/5111/7214 Navigatii Mazda 90 A 1 navigatii-mazda 290/1035/5111
5377 5111 290/1035/5111/5377 Navigatii Mercedes 90 A 1 navigatii-mercedes 290/1035/5111
23463 5111 290/1035/5111/23463 Navigatii Nissan 90 A 1 navigatii-nissan 290/1035/5111
5390 5111 290/1035/5111/5390 Navigatii Opel 90 A 1 navigatii-opel 290/1035/5111
23464 5111 290/1035/5111/23464 Navigatii Peugeot 90 A 1 navigatii-peugeot 290/1035/5111
23462 5111 290/1035/5111/23462 Navigatii Porsche 90 A 1 navigatii-porsche 290/1035/5111
5753 5111 290/1035/5111/5753 Navigatii Renault 90 A 1 navigatii-renault 290/1035/5111
5145 5111 290/1035/5111/5145 Navigatii Seat 90 A 1 navigatii-seat 290/1035/5111
5135 5111 290/1035/5111/5135 Navigatii Skoda 90 A 1 navigatii-skoda 290/1035/5111
7183 5111 290/1035/5111/7183 Navigatii Smart 90 A 1 navigatii-smart 290/1035/5111
7190 5111 290/1035/5111/7190 Navigatii Subaru 90 A 1 navigatii-subaru 290/1035/5111
7185 5111 290/1035/5111/7185 Navigatii Toyota 90 A 1 navigatii-toyota 290/1035/5111
5112 5111 290/1035/5111/5112 Navigatii VW 90 A 1 navigatii-vw 290/1035/5111
21171 19445 290/1035/19445/21171 papuci Electrici 90 A 1 papuci-electrici-ro 290/1035/19445
1088 1035 290/1035/1088 Playere Auto 90 A 1 playere-auto 290/1035
23263 1035 290/1035/23263 Prelungitoare 90 A 1 prelungitoare-ro-3 290/1035
20928 1035 290/1035/20928 proiectoare Auto 90 A 1 proiectoare-auto-ro-2 290/1035
20929 20928 290/1035/20928/20929 proiectoare Cu Leduri Drl 90 A 1 proiectoare-cu-leduri-drl-ro-2 290/1035/20928
21583 20928 290/1035/20928/21583 proiectoare Turisme Universale 90 A 1 proiectoare-turisme-universale-ro 290/1035/20928
20925 20924 290/1035/19541/20924/20925 radio Auto Mp3 Player 90 A 1 radio-auto-mp3-player 290/1035/19541/20924
2643 2642 290/1035/2642/2643 Redresoare Auto 90 A 1 redresoare-auto 290/1035/2642
7122 1035 290/1035/7122 Redresoare Auto 90 A 1 redresoare-auto-ro 290/1035
2642 1035 290/1035/2642 Redresoare Auto si Roboti de Pornire 90 A 1 redresoare-auto-si-roboti-de-pornire 290/1035
19827 19541 290/1035/19541/19827 senzori De Parcare 90 A 1 senzori-de-parcare-ro 290/1035/19541
2382 1266 290/1035/1266/2382 Senzori Parcare 90 A 1 senzori-parcare 290/1035/1266
2616 1035 290/1035/2616 Siguranta si Confort 90 A 1 siguranta-si-confort 290/1035
19568 19445 290/1035/19445/19568 sigurante Auto 90 A 1 sigurante-auto 290/1035/19445
20924 19541 290/1035/19541/20924 sistem Audio 90 A 1 sistem-audio-ro 290/1035/19541
20930 19541 290/1035/19541/20930 sistem Inchidere Centralizata 90 A 1 sistem-inchidere-centralizata-ro 290/1035/19541
20961 19541 290/1035/19541/20961 sistem Multimedia Auto 90 A 1 sistem-multimedia-auto-ro 290/1035/19541
21089 19541 290/1035/19541/21089 sistem Navigatie Gps 90 A 1 sistem-navigatie-gps 290/1035/19541
1264 1035 290/1035/1264 Sisteme GPS 90 A 1 sisteme-gps 290/1035
21115 19541 290/1035/19541/21115 sisteme Localizare Gps 90 A 1 sisteme-localizare-gps-ro 290/1035/19541
1114 1035 290/1035/1114 Statii CB Auto 90 A 1 statii-cb-auto 290/1035
1279 1114 290/1035/1114/1279 Statii Radio CB 90 A 1 statii-radio-cb 290/1035/1114
6794 1114 290/1035/1114/6794 Statii Radio Walkie Talkie 90 A 1 statii-radio-walkie-talkie 290/1035/1114
1205 1090 290/1035/1090/1205 Subwoofere Auto 90 A 1 subwoofere-auto 290/1035/1090
23277 1035 290/1035/23277 Tehnica Audio Home 90 A 1 tehnica-audio-home 290/1035
19756 1035 290/1035/19756 tempomat- Sistem Cruise Control 90 A 1 tempomat-sistem-cruise-control-ro 290/1035
1207 1205 290/1035/1090/1205/1207 Tuburi Bass 12 Inch 90 A 1 tuburi-bass-12-inch 290/1035/1090/1205
6795 1035 290/1035/6795 Umidificatoare Auto 90 A 1 umidificatoare-auto 290/1035
2686 1035 290/1035/2686 Xenoane 90 A 1 xenoane 290/1035
2790 1035 290/1035/2790 Camere Video Auto 110 A 1 camere-video-auto 290/1035