#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTM5MDh8fG1kZl9pZD09MV43OTY3fHxzcGFyZV9pZD09MjAxMDUy&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "7967" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08215" AND av.ProductID IN (247)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "11544 01" AND av.ProductID IN (247)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "034 024 0007" AND av.ProductID IN (247)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "034 024 0014" AND av.ProductID IN (247)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "010.660-00A" AND av.ProductID IN (247)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "010.663-00A" AND av.ProductID IN (247)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "010.563-00A" AND av.ProductID IN (247)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1203493" AND av.ProductID IN (247)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1203497" AND av.ProductID IN (247)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1203226" AND av.ProductID IN (247)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1203498" AND av.ProductID IN (247)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1203331" AND av.ProductID IN (247)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "08.300.1320.070" AND av.ProductID IN (247,247)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "08.300.1320.040" AND av.ProductID IN (247,247)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "08.300.1320.060" AND av.ProductID IN (247,247)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "08.300.1320.080" AND av.ProductID IN (247,247)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-02811-SX" AND av.ProductID IN (247)) ) 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 = "08215") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11544 01") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 024 0007") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 024 0014") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.660-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.663-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.563-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203493") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203497") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203226") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203498") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203331") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.070") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.040") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.060") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.080") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-02811-SX") ) 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 = "08215") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11544 01") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 024 0007") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 024 0014") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.660-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.663-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "010.563-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203493") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203497") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203226") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203498") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1203331") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.070") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.040") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.060") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.300.1320.080") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-02811-SX") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска двигателя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 08215 Подвеска, двигатель
LEMFÖRDER 11544 01 Подвеска, двигатель
MEYLE 034 024 0007 Подвеска, двигатель
034 024 0014 Подвеска, двигатель
PE Automotive 010.660-00A Подвеска, двигатель
010.663-00A Подвеска, двигатель
010.563-00A Подвеска, двигатель
S-TR STR-1203493 Подвеска, двигатель
STR-1203497 Подвеска, двигатель
STR-1203226 Подвеска, двигатель
STR-1203498 Подвеска, двигатель
STR-1203331 Подвеска, двигатель
ST-TEMPLIN 08.300.1320.070 Подвеска, двигатель
08.300.1320.040 Подвеска, двигатель
08.300.1320.060 Подвеска, двигатель
08.300.1320.080 Подвеска, двигатель
STELLOX 81-02811-SX Подвеска, двигатель
2026 CATCAR.INFO (v 2.0)