#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1Mzd8fG1kZl9pZD09MV43MDczfHxzcGFyZV9pZD09MjAwODg5&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 = "7073" AND ( (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "17IV2050" AND av.ProductID IN (914,914)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32469" AND av.ProductID IN (914)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32253" AND av.ProductID IN (284)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32470" AND av.ProductID IN (914)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32135" AND av.ProductID IN (914)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32255" AND av.ProductID IN (284)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR32136" AND av.ProductID IN (914)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "NK1010" AND av.ProductID IN (914)) OR (av.SupplierID = 471 AND av.DataSupplierArticleNumber = "A1-2453" AND av.ProductID IN (284)) OR (av.SupplierID = 471 AND av.DataSupplierArticleNumber = "A3-3741" AND av.ProductID IN (914)) OR (av.SupplierID = 471 AND av.DataSupplierArticleNumber = "A3-3197" AND av.ProductID IN (914)) OR (av.SupplierID = 471 AND av.DataSupplierArticleNumber = "A3-3198" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "12974" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "12975" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "28676" AND av.ProductID IN (284)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "31982" AND av.ProductID IN (284)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "1405" AND av.ProductID IN (914)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "20889 01" AND av.ProductID IN (284)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "21014 01" AND av.ProductID IN (284)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "CV-ES-2774" AND av.ProductID IN (914)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "MN-DL-7781" AND av.ProductID IN (284)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "CV-ES-2533" AND av.ProductID IN (914)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.053-00A" AND av.ProductID IN (284)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.090-00A" AND av.ProductID IN (914)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.091-00A" AND av.ProductID IN (914)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.038-00A" AND av.ProductID IN (914)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.051-00A" AND av.ProductID IN (284)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "032.047-00A" AND av.ProductID IN (914)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2134374" AND av.ProductID IN (284)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2134379" AND av.ProductID IN (284)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-10204" AND av.ProductID IN (284)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-20211" AND av.ProductID IN (914)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "020.077" AND av.ProductID IN (914)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "8637" AND av.ProductID IN (914)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "10134" AND av.ProductID IN (284)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "8638" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-34029-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-34030-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-35051-SX" AND av.ProductID IN (284)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 71 0037" AND av.ProductID IN (914)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 71 0042" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTE2703" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTR2703" AND av.ProductID IN (284)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTE3001" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTR3010" AND av.ProductID IN (284)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTE3002" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTE2702" AND av.ProductID IN (914)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-7641" 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 = 4829 AND aa.DataSupplierArticleNumber = "17IV2050") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32469") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32253") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32470") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32135") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32255") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32136") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NK1010") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A1-2453") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3741") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3197") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3198") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "12974") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "12975") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28676") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31982") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "1405") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "20889 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21014 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "CV-ES-2774") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-DL-7781") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "CV-ES-2533") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.053-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.090-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.091-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.038-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.051-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.047-00A") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2134374") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2134379") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-10204") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-20211") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.077") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "8637") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10134") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "8638") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-34029-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-34030-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-35051-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 71 0037") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 71 0042") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE2703") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTR2703") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE3001") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTR3010") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE3002") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE2702") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7641") ) 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 = 4829 AND aa.DataSupplierArticleNumber = "17IV2050") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32469") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32253") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32470") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32135") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32255") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR32136") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NK1010") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A1-2453") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3741") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3197") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A3-3198") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "12974") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "12975") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28676") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31982") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "1405") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "20889 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21014 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "CV-ES-2774") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-DL-7781") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "CV-ES-2533") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.053-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.090-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.091-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.038-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.051-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "032.047-00A") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2134374") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2134379") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-10204") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-20211") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.077") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "8637") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10134") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "8638") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-34029-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-34030-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-35051-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 71 0037") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 71 0042") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE2703") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTR2703") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE3001") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTR3010") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE3002") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE2702") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7641") ) AND aa.Language = "ru" Продажа автозапчастей типа Поперечная рулевая тяга / шарнир для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AS METAL 17IV2050 Наконечник поперечной рулевой тяги
BORG & BECK BTR32469 Наконечник поперечной рулевой тяги
BTR32253 Поперечная рулевая тяга
BTR32470 Наконечник поперечной рулевой тяги
BTR32135 Наконечник поперечной рулевой тяги
BTR32255 Поперечная рулевая тяга
BTR32136 Наконечник поперечной рулевой тяги
DELPHI NK1010 Наконечник поперечной рулевой тяги
DITAS A1-2453 Поперечная рулевая тяга
A3-3741 Наконечник поперечной рулевой тяги
A3-3197 Наконечник поперечной рулевой тяги
A3-3198 Наконечник поперечной рулевой тяги
FEBI BILSTEIN 12974 Наконечник поперечной рулевой тяги
12975 Наконечник поперечной рулевой тяги
28676 Поперечная рулевая тяга
31982 Поперечная рулевая тяга
FRAP 1405 Наконечник поперечной рулевой тяги
LEMFÖRDER 20889 01 Поперечная рулевая тяга
21014 01 Поперечная рулевая тяга
MOOG CV-ES-2774 Наконечник поперечной рулевой тяги
MN-DL-7781 Поперечная рулевая тяга
CV-ES-2533 Наконечник поперечной рулевой тяги
PE Automotive 032.053-00A Поперечная рулевая тяга
032.090-00A Наконечник поперечной рулевой тяги
032.091-00A Наконечник поперечной рулевой тяги
032.038-00A Наконечник поперечной рулевой тяги
032.051-00A Поперечная рулевая тяга
032.047-00A Наконечник поперечной рулевой тяги
ROTA 2134374 Поперечная рулевая тяга
2134379 Поперечная рулевая тяга
S-TR STR-10204 Поперечная рулевая тяга
STR-20211 Наконечник поперечной рулевой тяги
SAMPA 020.077 Наконечник поперечной рулевой тяги
SEM LASTIK 8637 Наконечник поперечной рулевой тяги
10134 Поперечная рулевая тяга
8638 Наконечник поперечной рулевой тяги
STELLOX 84-34029-SX Наконечник поперечной рулевой тяги
84-34030-SX Наконечник поперечной рулевой тяги
84-35051-SX Поперечная рулевая тяга
SWAG 10 71 0037 Наконечник поперечной рулевой тяги
10 71 0042 Наконечник поперечной рулевой тяги
TRW JTE2703 Наконечник поперечной рулевой тяги
JTR2703 Поперечная рулевая тяга
JTE3001 Наконечник поперечной рулевой тяги
JTR3010 Поперечная рулевая тяга
JTE3002 Наконечник поперечной рулевой тяги
JTE2702 Наконечник поперечной рулевой тяги
VAICO V30-7641 Наконечник поперечной рулевой тяги
2026 CATCAR.INFO (v 2.0)