#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwMTR8fG1kZl9pZD09MF4xNzQxMnx8c3BhcmVfaWQ9PTEwMDc3NQ%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 = "17412" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38872" AND av.ProductID IN (4926)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38869" AND av.ProductID IN (4926)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46395" AND av.ProductID IN (4918)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38870" AND av.ProductID IN (4926)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36332" AND av.ProductID IN (4743)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38871" AND av.ProductID IN (4926)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0899042" AND av.ProductID IN (4743)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 930 0002" AND av.ProductID IN (4743)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 8871" AND av.ProductID IN (4926)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 6332" AND av.ProductID IN (4743)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 8872" AND av.ProductID IN (4926)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 8869" AND av.ProductID IN (4926)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 6395" AND av.ProductID IN (4918)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 8870" AND av.ProductID IN (4926)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "408 073" AND av.ProductID IN (4743)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.42.284" AND av.ProductID IN (4743)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1427531" AND av.ProductID IN (4918)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "38872") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38869") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46395") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38870") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36332") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38871") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0899042") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 930 0002") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8871") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 6332") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8872") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8869") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 6395") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8870") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "408 073") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.42.284") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1427531") ) 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 = 101 AND aa.DataSupplierArticleNumber = "38872") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38869") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46395") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38870") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36332") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38871") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0899042") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 930 0002") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8871") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 6332") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8872") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8869") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 6395") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 8870") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "408 073") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.42.284") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1427531") ) AND aa.Language = "ru" Продажа автозапчастей типа Корпус/составные части для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 38872 Подушка, автоматическая коробка передач
38869 Подушка, автоматическая коробка передач
46395 Резьбовая пробка, картер коробки передач
38870 Подушка, автоматическая коробка передач
36332 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
38871 Подушка, автоматическая коробка передач
METZGER 0899042 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
MEYLE 014 930 0002 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
SWAG 10 93 8871 Подушка, автоматическая коробка передач
10 93 6332 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
10 93 8872 Подушка, автоматическая коробка передач
10 93 8869 Подушка, автоматическая коробка передач
10 94 6395 Резьбовая пробка, картер коробки передач
10 93 8870 Подушка, автоматическая коробка передач
TOPRAN 408 073 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
TRUCKTEC AUTOMOTIVE 02.42.284 Штекерный корпус, автоматическ. коробка передач - ус-во упр.
WILMINK GROUP WG1427531 Резьбовая пробка, картер коробки передач
2026 CATCAR.INFO (v 2.0)