#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTI5MHx8bWRmX2lkPT0wXjIyfHxzcGFyZV9pZD09MTAwNjAz&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 = "22" AND ( (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "BW-E-88211" AND av.ProductID IN (51)) OR (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "BW-A-53212" AND av.ProductID IN (914)) OR (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "BW-E-35656" AND av.ProductID IN (51)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "240014" AND av.ProductID IN (51)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "240016" AND av.ProductID IN (51)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "230027" AND av.ProductID IN (914)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "20BM0031" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "20BM0021" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "17BM0002" AND av.ProductID IN (914,914)) OR (av.SupplierID = 4995 AND av.DataSupplierArticleNumber = "001-10-19190" AND av.ProductID IN (914)) OR (av.SupplierID = 4995 AND av.DataSupplierArticleNumber = "001-10-19193" AND av.ProductID IN (51)) OR (av.SupplierID = 4995 AND av.DataSupplierArticleNumber = "001-10-20409" AND av.ProductID IN (51)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "040621B" AND av.ProductID IN (914)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "040859B" AND av.ProductID IN (51)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "040860B" AND av.ProductID IN (51)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "TD2037" AND av.ProductID IN (914)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "AX2039" AND av.ProductID IN (51)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "AX2038" AND av.ProductID IN (51)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTR4160" AND av.ProductID IN (914)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CTR3132" AND av.ProductID IN (914)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TA1288" AND av.ProductID IN (51)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TA1075" AND av.ProductID IN (914)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TA1289" AND av.ProductID IN (51)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D130074" AND av.ProductID IN (914)) OR (av.SupplierID = 471 AND av.DataSupplierArticleNumber = "A1-1935" AND av.ProductID IN (914)) OR (av.SupplierID = 4519 AND av.DataSupplierArticleNumber = "DE1120" AND av.ProductID IN (914)) OR (av.SupplierID = 4519 AND av.DataSupplierArticleNumber = "DR1068" AND av.ProductID IN (51)) OR (av.SupplierID = 4519 AND av.DataSupplierArticleNumber = "DR1069" AND av.ProductID IN (51)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS2051" AND av.ProductID IN (51)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS2052" AND av.ProductID IN (51)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS339" AND av.ProductID IN (914)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "RD327" AND av.ProductID IN (914)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "RD334" AND av.ProductID IN (914)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "RD335" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08574" AND av.ProductID IN (914)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTR4160" AND av.ProductID IN (914)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL952-C" AND av.ProductID IN (51)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL116-B" AND av.ProductID IN (914)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL953-C" AND av.ProductID IN (51)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "1207004" AND av.ProductID IN (51)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "1207010" AND av.ProductID IN (51)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "1201004" AND av.ProductID IN (914)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ2063" AND av.ProductID IN (51)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ1227" AND av.ProductID IN (914)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "954" AND av.ProductID IN (51)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "955" AND av.ProductID IN (51)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "953" AND av.ProductID IN (914)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP201115" AND av.ProductID IN (914,914)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP101133" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP101132" AND av.ProductID IN (51,51)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1444600500" AND av.ProductID IN (914)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1444600509" AND av.ProductID IN (914)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1444500509" AND av.ProductID IN (51)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9921331" AND av.ProductID IN (51)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9921330" AND av.ProductID IN (914)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 1162" AND av.ProductID IN (914,914)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4302535" AND av.ProductID IN (51)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4312500" AND av.ProductID IN (914)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "10586 01" AND av.ProductID IN (51)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "10584 01" AND av.ProductID IN (914)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "21428 01" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C4002LR" AND av.ProductID IN (914)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C2108LR" AND av.ProductID IN (51)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C2109R" AND av.ProductID IN (51)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "49781/1" AND av.ProductID IN (51)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "19660" AND av.ProductID IN (914)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "10584-PCS-MS" AND av.ProductID IN (914)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "10584-SET-MS" AND av.ProductID IN (914,914)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "69-0096" AND av.ProductID IN (914)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "54012108" AND av.ProductID IN (914)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "316 030 4305" AND av.ProductID IN (51)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "316 020 4302" AND av.ProductID IN (914)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "316 030 4303" AND av.ProductID IN (51)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L1162" AND av.ProductID IN (914)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "BM-AX-4305" AND av.ProductID IN (51)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "BM-AX-4303" AND av.ProductID IN (51)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "BM-ES-4302" AND av.ProductID IN (914)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5031532" AND av.ProductID IN (51)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5031533" AND av.ProductID IN (51)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5031505" AND av.ProductID IN (914)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0182037" AND av.ProductID IN (914)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0602039" AND av.ProductID IN (51)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "G2-064" AND av.ProductID IN (51)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "G1-227" AND av.ProductID IN (914)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "G2-063" AND av.ProductID IN (51)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PS2095L" AND av.ProductID IN (51)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PS2095R" AND av.ProductID IN (51)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PS1063" AND av.ProductID IN (914)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2303-0008" AND av.ProductID IN (51)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2302-0033" AND av.ProductID IN (914)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR5012S" AND av.ProductID IN (51)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR2046S" AND av.ProductID IN (914)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR2421S" AND av.ProductID IN (51)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "BW3815" AND av.ProductID IN (51)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "BW2004" AND av.ProductID IN (914)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "BW3821" AND av.ProductID IN (51)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "91-09512" AND av.ProductID IN (914)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "92-09513" AND av.ProductID IN (51)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "92-09514" AND av.ProductID IN (51)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "915003" AND av.ProductID IN (51)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "915001" AND av.ProductID IN (914)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "915002" AND av.ProductID IN (51)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065031533" AND av.ProductID IN (51)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065031505" AND av.ProductID IN (914)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065031532" AND av.ProductID IN (51)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "21330" AND av.ProductID IN (914)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "21331" AND av.ProductID IN (51)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "21332" AND av.ProductID IN (51)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00649-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00192-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "55-01234-SX" AND av.ProductID IN (51)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00649A-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00192A-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-98001-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "51-00286-SX" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "55-01195-SX" AND av.ProductID IN (51)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 71 0010" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "44-02230" AND av.ProductID IN (51)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "42-02226" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "44-02229" AND av.ProductID IN (51)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "500 430" AND av.ProductID IN (914)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 1162" AND av.ProductID IN (914)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "08.37.007" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTE150" AND av.ProductID IN (914)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JAR219" AND av.ProductID IN (51)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JAR220" AND av.ProductID IN (51)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-7141" AND av.ProductID IN (51)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-0367" AND av.ProductID IN (914)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "22320" AND av.ProductID IN (51,51)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "16772" AND av.ProductID IN (914,914)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "22321" AND av.ProductID IN (51,51)) ) 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 = "BW-E-88211") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "BW-A-53212") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "BW-E-35656") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240014") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240016") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "230027") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20BM0031") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20BM0021") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "17BM0002") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-19190") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-19193") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-20409") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040621B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040859B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040860B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "TD2037") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX2039") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX2038") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR4160") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTR3132") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1288") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1075") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1289") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D130074") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A1-1935") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DE1120") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1068") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1069") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS2051") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS2052") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS339") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD327") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD334") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD335") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08574") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTR4160") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL952-C") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL116-B") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL953-C") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1207004") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1207010") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1201004") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ2063") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ1227") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "954") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "955") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "953") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201115") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP101133") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP101132") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444600500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444600509") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444500509") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9921331") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9921330") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 1162") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4302535") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4312500") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10586 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10584 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21428 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4002LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2108LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2109R") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "49781/1") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "19660") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "10584-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "10584-SET-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "69-0096") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "54012108") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 030 4305") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 020 4302") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 030 4303") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L1162") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-AX-4305") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-AX-4303") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-ES-4302") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031532") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031533") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031505") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0182037") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602039") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G2-064") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G1-227") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G2-063") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2095L") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2095R") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS1063") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2303-0008") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2302-0033") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR5012S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR2046S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR2421S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW3815") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW2004") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW3821") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-09512") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-09513") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-09514") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915003") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915001") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915002") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031533") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031505") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031532") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21330") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21331") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21332") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00649-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00192-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-01234-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00649A-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00192A-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-98001-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00286-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-01195-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 71 0010") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02230") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-02226") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02229") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "500 430") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 1162") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "08.37.007") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE150") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JAR219") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JAR220") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-7141") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-0367") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "22320") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "16772") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "22321") ) 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 = "BW-E-88211") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "BW-A-53212") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "BW-E-35656") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240014") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240016") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "230027") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20BM0031") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20BM0021") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "17BM0002") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-19190") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-19193") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-20409") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040621B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040859B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040860B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "TD2037") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX2039") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX2038") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTR4160") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTR3132") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1288") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1075") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA1289") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D130074") OR (aa.SupplierID = 471 AND aa.DataSupplierArticleNumber = "A1-1935") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DE1120") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1068") OR (aa.SupplierID = 4519 AND aa.DataSupplierArticleNumber = "DR1069") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS2051") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS2052") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS339") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD327") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD334") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "RD335") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08574") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTR4160") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL952-C") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL116-B") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL953-C") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1207004") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1207010") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "1201004") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ2063") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ1227") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "954") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "955") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "953") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201115") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP101133") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP101132") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444600500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444600509") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1444500509") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9921331") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9921330") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 1162") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4302535") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4312500") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10586 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10584 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21428 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4002LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2108LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2109R") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "49781/1") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "19660") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "10584-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "10584-SET-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "69-0096") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "54012108") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 030 4305") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 020 4302") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "316 030 4303") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L1162") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-AX-4305") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-AX-4303") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-ES-4302") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031532") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031533") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5031505") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0182037") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602039") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G2-064") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G1-227") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G2-063") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2095L") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2095R") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS1063") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2303-0008") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2302-0033") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR5012S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR2046S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR2421S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW3815") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW2004") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "BW3821") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-09512") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-09513") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-09514") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915003") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915001") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915002") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031533") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031505") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065031532") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21330") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21331") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "21332") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00649-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00192-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-01234-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00649A-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00192A-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-98001-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "51-00286-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-01195-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 71 0010") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02230") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-02226") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-02229") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "500 430") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 1162") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "08.37.007") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTE150") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JAR219") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JAR220") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-7141") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-0367") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "22320") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "16772") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "22321") ) AND aa.Language = "ru" Продажа автозапчастей типа Отдельные элементы рулевой тяги для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
4u BW-E-88211 Осевой шарнир, рулевая тяга
BW-A-53212 Наконечник поперечной рулевой тяги
BW-E-35656 Осевой шарнир, рулевая тяга
A.B.S. 240014 Осевой шарнир, рулевая тяга
240016 Осевой шарнир, рулевая тяга
230027 Наконечник поперечной рулевой тяги
AS METAL 20BM0031 Осевой шарнир, рулевая тяга
20BM0021 Осевой шарнир, рулевая тяга
17BM0002 Наконечник поперечной рулевой тяги
BBR Automotive 001-10-19190 Наконечник поперечной рулевой тяги
001-10-19193 Осевой шарнир, рулевая тяга
001-10-20409 Осевой шарнир, рулевая тяга
BENDIX 040621B Наконечник поперечной рулевой тяги
040859B Осевой шарнир, рулевая тяга
040860B Осевой шарнир, рулевая тяга
BIRTH TD2037 Наконечник поперечной рулевой тяги
AX2039 Осевой шарнир, рулевая тяга
AX2038 Осевой шарнир, рулевая тяга
BORG & BECK BTR4160 Наконечник поперечной рулевой тяги
COMLINE CTR3132 Наконечник поперечной рулевой тяги
DELPHI TA1288 Осевой шарнир, рулевая тяга
TA1075 Наконечник поперечной рулевой тяги
TA1289 Осевой шарнир, рулевая тяга
DENCKERMANN D130074 Наконечник поперечной рулевой тяги
DITAS A1-1935 Наконечник поперечной рулевой тяги
DJ PARTS DE1120 Наконечник поперечной рулевой тяги
DR1068 Осевой шарнир, рулевая тяга
DR1069 Осевой шарнир, рулевая тяга
FAI AutoParts SS2051 Осевой шарнир, рулевая тяга
SS2052 Осевой шарнир, рулевая тяга
SS339 Наконечник поперечной рулевой тяги
FARE SA RD327 Наконечник поперечной рулевой тяги
RD334 Наконечник поперечной рулевой тяги
RD335 Наконечник поперечной рулевой тяги
FEBI BILSTEIN 08574 Наконечник поперечной рулевой тяги
FIRST LINE FTR4160 Наконечник поперечной рулевой тяги
FLENNOR FL952-C Осевой шарнир, рулевая тяга
FL116-B Наконечник поперечной рулевой тяги
FL953-C Осевой шарнир, рулевая тяга
FORMPART 1207004 Осевой шарнир, рулевая тяга
1207010 Осевой шарнир, рулевая тяга
1201004 Наконечник поперечной рулевой тяги
FORTUNE LINE FZ2063 Осевой шарнир, рулевая тяга
FZ1227 Наконечник поперечной рулевой тяги
FRAP 954 Осевой шарнир, рулевая тяга
955 Осевой шарнир, рулевая тяга
953 Наконечник поперечной рулевой тяги
G.U.D. GSP201115 Наконечник поперечной рулевой тяги
GSP101133 Осевой шарнир, рулевая тяга
GSP101132 Осевой шарнир, рулевая тяга
JP GROUP 1444600500 Наконечник поперечной рулевой тяги
1444600509 Наконечник поперечной рулевой тяги
1444500509 Осевой шарнир, рулевая тяга
KAMOKA 9921331 Осевой шарнир, рулевая тяга
9921330 Наконечник поперечной рулевой тяги
KAWE 8500 1162 Наконечник поперечной рулевой тяги
KRAFT AUTOMOTIVE 4302535 Осевой шарнир, рулевая тяга
4312500 Наконечник поперечной рулевой тяги
LEMFÖRDER 10586 01 Осевой шарнир, рулевая тяга
10584 01 Наконечник поперечной рулевой тяги
21428 01 Осевой шарнир, рулевая тяга
LYNXauto C4002LR Наконечник поперечной рулевой тяги
C2108LR Осевой шарнир, рулевая тяга
C2109R Осевой шарнир, рулевая тяга
MAPCO 49781/1 Осевой шарнир, рулевая тяга
19660 Наконечник поперечной рулевой тяги
MASTER-SPORT 10584-PCS-MS Наконечник поперечной рулевой тяги
10584-SET-MS Наконечник поперечной рулевой тяги
MAXGEAR 69-0096 Наконечник поперечной рулевой тяги
METZGER 54012108 Наконечник поперечной рулевой тяги
MEYLE 316 030 4305 Осевой шарнир, рулевая тяга
316 020 4302 Наконечник поперечной рулевой тяги
316 030 4303 Осевой шарнир, рулевая тяга
MONROE L1162 Наконечник поперечной рулевой тяги
MOOG BM-AX-4305 Осевой шарнир, рулевая тяга
BM-AX-4303 Осевой шарнир, рулевая тяга
BM-ES-4302 Наконечник поперечной рулевой тяги
NK 5031532 Осевой шарнир, рулевая тяга
5031533 Осевой шарнир, рулевая тяга
5031505 Наконечник поперечной рулевой тяги
OCAP 0182037 Наконечник поперечной рулевой тяги
0602039 Осевой шарнир, рулевая тяга
OPTIMAL G2-064 Осевой шарнир, рулевая тяга
G1-227 Наконечник поперечной рулевой тяги
G2-063 Осевой шарнир, рулевая тяга
PATRON PS2095L Осевой шарнир, рулевая тяга
PS2095R Осевой шарнир, рулевая тяга
PS1063 Наконечник поперечной рулевой тяги
PROFIT 2303-0008 Осевой шарнир, рулевая тяга
2302-0033 Наконечник поперечной рулевой тяги
QUINTON HAZELL QR5012S Осевой шарнир, рулевая тяга
QR2046S Наконечник поперечной рулевой тяги
QR2421S Осевой шарнир, рулевая тяга
RIW BW3815 Осевой шарнир, рулевая тяга
BW2004 Наконечник поперечной рулевой тяги
BW3821 Осевой шарнир, рулевая тяга
RTS 91-09512 Наконечник поперечной рулевой тяги
92-09513 Осевой шарнир, рулевая тяга
92-09514 Осевой шарнир, рулевая тяга
RUVILLE 915003 Осевой шарнир, рулевая тяга
915001 Наконечник поперечной рулевой тяги
915002 Осевой шарнир, рулевая тяга
sbs 19065031533 Осевой шарнир, рулевая тяга
19065031505 Наконечник поперечной рулевой тяги
19065031532 Осевой шарнир, рулевая тяга
SIDEM 21330 Наконечник поперечной рулевой тяги
21331 Осевой шарнир, рулевая тяга
21332 Осевой шарнир, рулевая тяга
STELLOX 51-00649-SX Наконечник поперечной рулевой тяги
51-00192-SX Наконечник поперечной рулевой тяги
55-01234-SX Осевой шарнир, рулевая тяга
51-00649A-SX Наконечник поперечной рулевой тяги
51-00192A-SX Наконечник поперечной рулевой тяги
51-98001-SX Наконечник поперечной рулевой тяги
51-00286-SX Наконечник поперечной рулевой тяги
55-01195-SX Осевой шарнир, рулевая тяга
SWAG 20 71 0010 Наконечник поперечной рулевой тяги
TALOSA 44-02230 Осевой шарнир, рулевая тяга
42-02226 Наконечник поперечной рулевой тяги
44-02229 Осевой шарнир, рулевая тяга
TOPRAN 500 430 Наконечник поперечной рулевой тяги
TRISCAN 8500 1162 Наконечник поперечной рулевой тяги
TRUCKTEC AUTOMOTIVE 08.37.007 Наконечник поперечной рулевой тяги
TRW JTE150 Наконечник поперечной рулевой тяги
JAR219 Осевой шарнир, рулевая тяга
JAR220 Осевой шарнир, рулевая тяга
VAICO V20-7141 Осевой шарнир, рулевая тяга
V20-0367 Наконечник поперечной рулевой тяги
VEMA 22320 Осевой шарнир, рулевая тяга
16772 Наконечник поперечной рулевой тяги
22321 Осевой шарнир, рулевая тяга
2026 CATCAR.INFO (v 2.0)