#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTUzODF8fG1kZl9pZD09MF4xODQyMHx8c3BhcmVfaWQ9PTEwMTY1NA%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 = "18420" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6803-00-0031280P" AND av.ProductID IN (531)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18197" AND av.ProductID IN (1365)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026001" AND av.ProductID IN (531,531,531)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026019" AND av.ProductID IN (740)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026000" AND av.ProductID IN (531)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026010" AND av.ProductID IN (1353)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026011" AND av.ProductID IN (1353)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1026018" AND av.ProductID IN (740)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "13 19 33" AND av.ProductID IN (1353)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1181300500" AND av.ProductID IN (1353)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "0031281A1" AND av.ProductID IN (531)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "003-15-100" AND av.ProductID IN (531)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0341900" AND av.ProductID IN (1353)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0343100" AND av.ProductID IN (531)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0341910" AND av.ProductID IN (1353)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0343130" AND av.ProductID IN (531)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-4486" AND av.ProductID IN (1353)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0318702" AND av.ProductID IN (1353,1353,1353)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0318660" AND av.ProductID IN (531)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0318701" AND av.ProductID IN (1353)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0318670" AND av.ProductID IN (531)) ) 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 = "6803-00-0031280P") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18197") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026019") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026000") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026010") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026011") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026018") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 19 33") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1181300500") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "0031281A1") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "003-15-100") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0341900") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0343100") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0341910") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0343130") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-4486") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318702") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318660") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318701") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318670") ) 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 = "6803-00-0031280P") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18197") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026019") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026000") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026010") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026011") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1026018") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 19 33") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1181300500") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "0031281A1") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "003-15-100") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0341900") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0343100") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0341910") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0343130") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-4486") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318702") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318660") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318701") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0318670") ) AND aa.Language = "ru" Продажа автозапчастей типа Капот двигателя/ составляющие/ изоляция для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 6803-00-0031280P Капот двигателя
Borsehung B18197 Замок капота
DIEDERICHS 1026001 Капот двигателя
1026019 Шарнир, капот
1026000 Капот двигателя
1026010 Изоляция моторного отделения
1026011 Изоляция моторного отделения
1026018 Шарнир, капот
JOHNS 13 19 33 Изоляция моторного отделения
JP GROUP 1181300500 Изоляция моторного отделения
KLOKKERHOLM 0031281A1 Капот двигателя
LORO 003-15-100 Капот двигателя
PRASCO AD0341900 Изоляция моторного отделения
AD0343100 Капот двигателя
AD0341910 Изоляция моторного отделения
AD0343130 Капот двигателя
VAICO V10-4486 Изоляция моторного отделения
VAN WEZEL 0318702 Изоляция моторного отделения
0318660 Капот двигателя
0318701 Изоляция моторного отделения
0318670 Капот двигателя
2026 CATCAR.INFO (v 2.0)