#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTc1ODB8fG1kZl9pZD09MF4xMTM4OXx8c3BhcmVfaWQ9PTEwMDM0Mg%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 = "11389" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0200P" AND av.ProductID IN (1280)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0201P" AND av.ProductID IN (1280)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0165P" AND av.ProductID IN (1280)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0166P" AND av.ProductID IN (1280)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26235" AND av.ProductID IN (795)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220554" AND av.ProductID IN (1280)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220551" AND av.ProductID IN (1280)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220552" AND av.ProductID IN (1280)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220015" AND av.ProductID IN (795)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220553" AND av.ProductID IN (1280)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 92 6235" AND av.ProductID IN (795)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.61.006" AND av.ProductID IN (795)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V30-08-0314" AND av.ProductID IN (795)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0200P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0201P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0165P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0166P") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26235") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220554") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220551") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220552") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220015") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220553") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 6235") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.61.006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V30-08-0314") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0200P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0201P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0165P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0166P") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26235") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220554") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220551") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220552") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220015") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220553") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 6235") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.61.006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V30-08-0314") ) AND aa.Language = "ru" Продажа автозапчастей типа Система очистки фар для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 5902-06-0200P Распылитель воды для чистки, система очистки фар
5902-06-0201P Распылитель воды для чистки, система очистки фар
5902-06-0165P Распылитель воды для чистки, система очистки фар
5902-06-0166P Распылитель воды для чистки, система очистки фар
FEBI BILSTEIN 26235 Водяной насос, система очистки фар
METZGER 2220554 Распылитель воды для чистки, система очистки фар
2220551 Распылитель воды для чистки, система очистки фар
2220552 Распылитель воды для чистки, система очистки фар
2220015 Водяной насос, система очистки фар
2220553 Распылитель воды для чистки, система очистки фар
SWAG 10 92 6235 Водяной насос, система очистки фар
TRUCKTEC AUTOMOTIVE 02.61.006 Водяной насос, система очистки фар
VEMO V30-08-0314 Водяной насос, система очистки фар
2026 CATCAR.INFO (v 2.0)