#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OXx8bW9kZWxfaWQ9PTEzMDZ8fG1kZl9pZD09MF4xOTY5NXx8c3BhcmVfaWQ9PTEwMDYwMw%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 = "19695" AND ( (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "DW-A-33994" AND av.ProductID IN (914)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "230057" AND av.ProductID IN (914)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "20DW0500" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "17DW0500" AND av.ProductID IN (914,914)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "103-0W-D51" AND av.ProductID IN (51)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "111-0W-D55" AND av.ProductID IN (914)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "1452-6090" AND av.ProductID IN (51)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "1452-7090" AND av.ProductID IN (51)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "1446-5090" AND av.ProductID IN (914)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "FT1347" AND av.ProductID IN (914)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR4865" AND av.ProductID IN (914)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CTR3177" AND av.ProductID IN (914)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TA1769" AND av.ProductID IN (914)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D130100" AND av.ProductID IN (914)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D180058" AND av.ProductID IN (51)) OR (av.SupplierID = 4519 AND av.DataSupplierArticleNumber = "DR1135" AND av.ProductID IN (51)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1130030051" AND av.ProductID IN (914)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS1041" AND av.ProductID IN (914)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "RD269" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "30915" AND av.ProductID IN (914)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTR4865" AND av.ProductID IN (914)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "3202001" AND av.ProductID IN (914)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "3207007" AND av.ProductID IN (51)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "2057" AND av.ProductID IN (914)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "2058" AND av.ProductID IN (51)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP201080" AND av.ProductID IN (914,914)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4840916" AND av.ProductID IN (51)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4820905" AND av.ProductID IN (914)) OR (av.SupplierID = 459 AND av.DataSupplierArticleNumber = "ITR-10081" AND av.ProductID IN (914)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "TI-D55" AND av.ProductID IN (914)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "RD-D51" AND av.ProductID IN (51)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "103D51" AND av.ProductID IN (51)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "111D55" AND av.ProductID IN (914)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "3244400100" AND av.ProductID IN (51)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9989032" AND av.ProductID IN (914)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "STR-1008" AND av.ProductID IN (51)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "STE-1007" AND av.ProductID IN (914)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "19517" AND av.ProductID IN (914)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "11805-PCS-MS" AND av.ProductID IN (914)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "69-0358" AND av.ProductID IN (51)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTR-8D55" AND av.ProductID IN (914)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MRE-8D51" AND av.ProductID IN (51)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "33-16 030 0002" AND av.ProductID IN (51)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "29-16 020 0000" AND av.ProductID IN (914)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "33-16 020 0006" AND av.ProductID IN (914)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "DE-DS-0127" AND av.ProductID IN (51)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "DE-ES-0126" AND av.ProductID IN (914)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J4820905" AND av.ProductID IN (914)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4820915" AND av.ProductID IN (914)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J4840906" AND av.ProductID IN (51)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J4840907" AND av.ProductID IN (51)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5035001" AND av.ProductID IN (914)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR5262S" AND av.ProductID IN (51)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR9346S" AND av.ProductID IN (914)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "DW2001" AND av.ProductID IN (914)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "92-03134" AND av.ProductID IN (51)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "91-03101" AND av.ProductID IN (914)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "919010" AND av.ProductID IN (51)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "919005" AND av.ProductID IN (914)) OR (av.SupplierID = 4547 AND av.DataSupplierArticleNumber = "431-00-8300" AND av.ProductID IN (914)) OR (av.SupplierID = 4547 AND av.DataSupplierArticleNumber = "430-00-8321" AND av.ProductID IN (51)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065035001" AND av.ProductID IN (914)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "89031" AND av.ProductID IN (914)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "89019" AND av.ProductID IN (51)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-98001-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00539-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "55-02088-SX" AND av.ProductID IN (51)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-01241-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "89 93 0915" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "44-02454" AND av.ProductID IN (51)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "42-04105" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "44-04106" AND av.ProductID IN (51)) OR (av.SupplierID = 4468 AND av.DataSupplierArticleNumber = "I30009YMT" AND av.ProductID IN (51)) OR (av.SupplierID = 4468 AND av.DataSupplierArticleNumber = "I10007YMT" AND av.ProductID IN (914)) ) 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 = 4987 AND aa.DataSupplierArticleNumber = "DW-A-33994") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "230057") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20DW0500") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "17DW0500") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "103-0W-D51") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0W-D55") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1452-6090") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1452-7090") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1446-5090") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1347") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR4865") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTR3177") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1769") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D130100") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D180058") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1135") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1130030051") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1041") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD269") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30915") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTR4865") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3202001") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3207007") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "2057") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "2058") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201080") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4840916") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4820905") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "ITR-10081") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-D55") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "RD-D51") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "103D51") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111D55") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3244400100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9989032") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STR-1008") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-1007") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "19517") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "11805-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "69-0358") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8D55") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MRE-8D51") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "33-16 030 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "29-16 020 0000") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "33-16 020 0006") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DE-DS-0127") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DE-ES-0126") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4820905") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4820915") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4840906") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4840907") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5035001") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR5262S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR9346S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "DW2001") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-03134") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-03101") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "919010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "919005") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "431-00-8300") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "430-00-8321") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065035001") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "89031") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "89019") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-98001-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00539-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-02088-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-01241-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "89 93 0915") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02454") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-04105") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-04106") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I30009YMT") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I10007YMT") ) 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 = 4987 AND aa.DataSupplierArticleNumber = "DW-A-33994") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "230057") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20DW0500") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "17DW0500") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "103-0W-D51") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0W-D55") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1452-6090") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1452-7090") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1446-5090") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1347") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR4865") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTR3177") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1769") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D130100") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D180058") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1135") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1130030051") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1041") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD269") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30915") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTR4865") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3202001") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3207007") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "2057") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "2058") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201080") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4840916") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4820905") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "ITR-10081") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-D55") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "RD-D51") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "103D51") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111D55") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3244400100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9989032") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STR-1008") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-1007") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "19517") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "11805-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "69-0358") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8D55") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MRE-8D51") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "33-16 030 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "29-16 020 0000") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "33-16 020 0006") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DE-DS-0127") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DE-ES-0126") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4820905") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4820915") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4840906") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4840907") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5035001") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR5262S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR9346S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "DW2001") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-03134") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-03101") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "919010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "919005") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "431-00-8300") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "430-00-8321") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065035001") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "89031") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "89019") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-98001-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00539-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-02088-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-01241-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "89 93 0915") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02454") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-04105") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-04106") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I30009YMT") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I10007YMT") ) AND aa.Language = "ru" Продажа автозапчастей типа Отдельные элементы рулевой тяги для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
4u DW-A-33994 Наконечник поперечной рулевой тяги
A.B.S. 230057 Наконечник поперечной рулевой тяги
AS METAL 20DW0500 Осевой шарнир, рулевая тяга
17DW0500 Наконечник поперечной рулевой тяги
ASHIKA 103-0W-D51 Осевой шарнир, рулевая тяга
111-0W-D55 Наконечник поперечной рулевой тяги
ASHUKI 1452-6090 Осевой шарнир, рулевая тяга
1452-7090 Осевой шарнир, рулевая тяга
1446-5090 Наконечник поперечной рулевой тяги
AUTLOG FT1347 Наконечник поперечной рулевой тяги
BORG & BECK BTR4865 Наконечник поперечной рулевой тяги
COMLINE CTR3177 Наконечник поперечной рулевой тяги
DELPHI TA1769 Наконечник поперечной рулевой тяги
DENCKERMANN D130100 Наконечник поперечной рулевой тяги
D180058 Осевой шарнир, рулевая тяга
DJ PARTS DR1135 Осевой шарнир, рулевая тяга
DODA 1130030051 Наконечник поперечной рулевой тяги
FAI AutoParts SS1041 Наконечник поперечной рулевой тяги
FARE SA RD269 Наконечник поперечной рулевой тяги
FEBI BILSTEIN 30915 Наконечник поперечной рулевой тяги
FIRST LINE FTR4865 Наконечник поперечной рулевой тяги
FORMPART 3202001 Наконечник поперечной рулевой тяги
3207007 Осевой шарнир, рулевая тяга
FRAP 2057 Наконечник поперечной рулевой тяги
2058 Осевой шарнир, рулевая тяга
G.U.D. GSP201080 Наконечник поперечной рулевой тяги
HERTH+BUSS JAKOPARTS J4840916 Осевой шарнир, рулевая тяга
J4820905 Наконечник поперечной рулевой тяги
IPS Parts ITR-10081 Наконечник поперечной рулевой тяги
JAPANPARTS TI-D55 Наконечник поперечной рулевой тяги
RD-D51 Осевой шарнир, рулевая тяга
JAPKO 103D51 Осевой шарнир, рулевая тяга
111D55 Наконечник поперечной рулевой тяги
JP GROUP 3244400100 Осевой шарнир, рулевая тяга
KAMOKA 9989032 Наконечник поперечной рулевой тяги
KAVO PARTS STR-1008 Осевой шарнир, рулевая тяга
STE-1007 Наконечник поперечной рулевой тяги
MAPCO 19517 Наконечник поперечной рулевой тяги
MASTER-SPORT 11805-PCS-MS Наконечник поперечной рулевой тяги
MAXGEAR 69-0358 Осевой шарнир, рулевая тяга
MDR MTR-8D55 Наконечник поперечной рулевой тяги
MRE-8D51 Осевой шарнир, рулевая тяга
MEYLE 33-16 030 0002 Осевой шарнир, рулевая тяга
29-16 020 0000 Наконечник поперечной рулевой тяги
33-16 020 0006 Наконечник поперечной рулевой тяги
MOOG DE-DS-0127 Осевой шарнир, рулевая тяга
DE-ES-0126 Наконечник поперечной рулевой тяги
NIPPARTS J4820905 Наконечник поперечной рулевой тяги
N4820915 Наконечник поперечной рулевой тяги
J4840906 Осевой шарнир, рулевая тяга
J4840907 Осевой шарнир, рулевая тяга
NK 5035001 Наконечник поперечной рулевой тяги
QUINTON HAZELL QR5262S Осевой шарнир, рулевая тяга
QR9346S Наконечник поперечной рулевой тяги
RIW DW2001 Наконечник поперечной рулевой тяги
RTS 92-03134 Осевой шарнир, рулевая тяга
91-03101 Наконечник поперечной рулевой тяги
RUVILLE 919010 Осевой шарнир, рулевая тяга
919005 Наконечник поперечной рулевой тяги
SAKURA 431-00-8300 Наконечник поперечной рулевой тяги
430-00-8321 Осевой шарнир, рулевая тяга
sbs 19065035001 Наконечник поперечной рулевой тяги
SIDEM 89031 Наконечник поперечной рулевой тяги
89019 Осевой шарнир, рулевая тяга
STELLOX 51-98001-SX Наконечник поперечной рулевой тяги
51-00539-SX Наконечник поперечной рулевой тяги
55-02088-SX Осевой шарнир, рулевая тяга
51-01241-SX Наконечник поперечной рулевой тяги
SWAG 89 93 0915 Наконечник поперечной рулевой тяги
TALOSA 44-02454 Осевой шарнир, рулевая тяга
42-04105 Наконечник поперечной рулевой тяги
44-04106 Осевой шарнир, рулевая тяга
YAMATO I30009YMT Осевой шарнир, рулевая тяга
I10007YMT Наконечник поперечной рулевой тяги
2026 CATCAR.INFO (v 2.0)