#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTkxMTh8fG1kZl9pZD09MF41NzM1N3x8c3BhcmVfaWQ9PTEwMDQ0MA%3D%3D&st=50 SELECT CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id, d.`Description` AS crit_designation, dv.`DisplayValue` AS crit_value, "" crit_unit, 2 criteria_art, "articletypes" as source FROM articlepassengercars av JOIN passengercarlinkageattributes_ru vla ON av.Idx = vla.Idx JOIN linkageattributedescriptions d ON vla.DescriptionIdx = d.Idx JOIN linkageattributedisplayvalues dv ON vla.DisplayValueIdx = dv.Idx WHERE av.VehicleID = "57357" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2901137" AND av.ProductID IN (289)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2902137" AND av.ProductID IN (289)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP22222" AND av.ProductID IN (289)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP22223" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "89410300802" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "89410221302" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "99411178302" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "89410226202" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "99411178402" AND av.ProductID IN (289)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "89410300702" AND av.ProductID IN (289)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1N0 009 954-321" AND av.ProductID IN (289)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1N0 009 954-011" AND av.ProductID IN (289)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1N0 009 954-021" AND av.ProductID IN (289)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1N0 009 954-311" AND av.ProductID IN (289)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "95 43 29" AND av.ProductID IN (289)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "95 43 30" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "95340282" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "95340281" AND av.ProductID IN (289)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "VW0384414" AND av.ProductID IN (289)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "VW0384413" AND av.ProductID IN (289)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "635064" AND av.ProductID IN (289)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "635063" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-0797-01-9" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-0798-00-21" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-0798-01-9" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-0797-00-21" AND av.ProductID IN (289)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "045096" AND av.ProductID IN (289)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "045097" AND av.ProductID IN (289)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5863995" AND av.ProductID IN (289)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5863996" AND av.ProductID IN (289)) ) UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes" as source FROM articleattributes aa WHERE ( (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2901137") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2902137") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP22222") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP22223") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410300802") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410221302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "99411178302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410226202") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "99411178402") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410300702") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-321") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-311") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 43 29") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 43 30") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95340282") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95340281") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "VW0384414") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "VW0384413") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "635064") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "635063") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0797-01-9") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0798-00-21") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0798-01-9") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0797-00-21") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "045096") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "045097") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5863995") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5863996") ) AND aa.Language = "ru" UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes_2018_2" as source FROM articleattributes_2018_2 aa WHERE ( (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2901137") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2902137") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP22222") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP22223") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410300802") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410221302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "99411178302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410226202") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "99411178402") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "89410300702") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-321") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1N0 009 954-311") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 43 29") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 43 30") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95340282") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95340281") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "VW0384414") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "VW0384413") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "635064") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "635063") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0797-01-9") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0798-00-21") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0798-01-9") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-0797-00-21") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "045096") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "045097") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5863995") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5863996") ) AND aa.Language = "ru" Продажа автозапчастей типа Противотуманная фара / вставка для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 2901137 Противотуманная фара
2902137 Противотуманная фара
BUGIAD BSP22222 Противотуманная фара
BSP22223 Противотуманная фара
DPA 89410300802 Противотуманная фара
89410221302 Противотуманная фара
99411178302 Противотуманная фара
89410226202 Противотуманная фара
99411178402 Противотуманная фара
89410300702 Противотуманная фара
HELLA 1N0 009 954-321 Противотуманная фара
1N0 009 954-011 Противотуманная фара
1N0 009 954-021 Противотуманная фара
1N0 009 954-311 Противотуманная фара
JOHNS 95 43 29 Противотуманная фара
95 43 30 Противотуманная фара
KLOKKERHOLM 95340282 Противотуманная фара
95340281 Противотуманная фара
PRASCO VW0384414 Противотуманная фара
VW0384413 Противотуманная фара
SPILU 635064 Противотуманная фара
635063 Противотуманная фара
TYC 19-0797-01-9 Противотуманная фара
19-0798-00-21 Противотуманная фара
19-0798-01-9 Противотуманная фара
19-0797-00-21 Противотуманная фара
VALEO 045096 Противотуманная фара
045097 Противотуманная фара
VAN WEZEL 5863995 Противотуманная фара
5863996 Противотуманная фара
2026 CATCAR.INFO (v 2.0)