#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTU0MjV8fG1kZl9pZD09MF4xOTI2MXx8c3BhcmVfaWQ9PTEwMDE5OQ%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 = "19261" AND ( (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2203" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2201L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1324" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2203L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2202" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1324L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "PUM1134" AND av.ProductID IN (12)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1310" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2202L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2201" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "PUM1200" AND av.ProductID IN (12)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1310L" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 001" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 153" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 002" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 121" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 807" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 151" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 777" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 122" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 001 979" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 152" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 001 811" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 123" AND av.ProductID IN (12)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSB77101RS" AND av.ProductID IN (286)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSP77300GS" AND av.ProductID IN (12)) OR (av.SupplierID = 4882 AND av.DataSupplierArticleNumber = "IDRO008N" AND av.ProductID IN (12)) OR (av.SupplierID = 4882 AND av.DataSupplierArticleNumber = "IDRO134N" AND av.ProductID IN (12)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521136" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521381" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "719520356" AND av.ProductID IN (12)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521382" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521383" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1381" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1382" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "19-0356" AND av.ProductID IN (12)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1383" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1136" AND av.ProductID IN (286)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SP85187" AND av.ProductID IN (12)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SR22154" AND av.ProductID IN (286)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SP85188" AND av.ProductID IN (12)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SR23037" AND av.ProductID IN (286)) OR (av.SupplierID = 316 AND av.DataSupplierArticleNumber = "PEI002" AND av.ProductID IN (12)) OR (av.SupplierID = 316 AND av.DataSupplierArticleNumber = "PEI031" AND av.ProductID IN (12)) OR (av.SupplierID = 4496 AND av.DataSupplierArticleNumber = "56.0014" AND av.ProductID IN (12)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "EP5010" AND av.ProductID IN (12)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "SGA133L" AND av.ProductID IN (286)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "SGA162L" AND av.ProductID IN (286)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "EP5009" AND av.ProductID IN (12)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "04.55.1400" AND av.ProductID IN (12)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "01.62.7802" AND av.ProductID IN (286)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "01.62.7830" AND av.ProductID IN (286)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "29859" AND av.ProductID IN (286)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "29990" AND av.ProductID IN (417)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0602138-K" AND av.ProductID IN (3080)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0602139-K" AND av.ProductID IN (3080)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1570" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1567" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRPA737" AND av.ProductID IN (12)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1568" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1569" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR1706L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR2140L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSP1638" AND av.ProductID IN (12)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR731L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR1705L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSP1639" AND av.ProductID IN (12)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR776L" AND av.ProductID IN (286)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7076080" AND av.ProductID IN (12)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7176033" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "51662" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "54459" AND av.ProductID IN (12)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "51633" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "54458" AND av.ProductID IN (12)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8510 24416" AND av.ProductID IN (286)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8515 24626" AND av.ProductID IN (12)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8510 24417" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRP866" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JER142" AND av.ProductID IN (12)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRP867" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JER107" AND av.ProductID IN (12)) OR (av.SupplierID = 155 AND av.DataSupplierArticleNumber = "30-79029" AND av.ProductID IN (286)) OR (av.SupplierID = 155 AND av.DataSupplierArticleNumber = "30-79030" AND av.ProductID IN (286)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "BEGM94" AND av.ProductID IN (12)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "GM65" AND av.ProductID IN (286)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "BEGM93" AND av.ProductID IN (12)) ) 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 = 4534 AND aa.DataSupplierArticleNumber = "TS2203") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2203L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1134") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1200") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310L") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 001") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 153") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 002") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 121") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 807") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 151") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 777") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 001 979") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 152") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 811") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 123") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSB77101RS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP77300GS") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO008N") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO134N") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521136") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521381") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "719520356") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521382") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1381") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1382") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "19-0356") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1136") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85187") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR22154") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85188") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR23037") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI002") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI031") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "56.0014") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5010") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA133L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA162L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5009") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "04.55.1400") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7802") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7830") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29859") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29990") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602138-K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602139-K") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1570") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1567") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRPA737") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1568") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1569") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1706L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR2140L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1638") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR731L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1705L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1639") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR776L") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7076080") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7176033") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51662") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54459") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51633") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54458") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24416") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8515 24626") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24417") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP866") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER142") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP867") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER107") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79029") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79030") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM94") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "GM65") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM93") ) 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 = 4534 AND aa.DataSupplierArticleNumber = "TS2203") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2203L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1134") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1200") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310L") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 001") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 153") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 002") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 121") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 807") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 151") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 777") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 001 979") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 152") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 811") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 123") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSB77101RS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP77300GS") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO008N") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO134N") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521136") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521381") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "719520356") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521382") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1381") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1382") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "19-0356") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1136") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85187") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR22154") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85188") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR23037") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI002") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI031") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "56.0014") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5010") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA133L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA162L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5009") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "04.55.1400") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7802") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7830") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29859") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29990") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602138-K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602139-K") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1570") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1567") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRPA737") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1568") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1569") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1706L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR2140L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1638") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR731L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1705L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1639") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR776L") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7076080") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7176033") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51662") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54459") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51633") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54458") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24416") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8515 24626") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24417") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP866") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER142") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP867") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER107") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79029") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79030") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM94") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "GM65") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM93") ) AND aa.Language = "ru" Продажа автозапчастей типа Рулевой механизм / насос для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AMK TS2203 Рулевой механизм
TS2201L Рулевой механизм
TS1324 Рулевой механизм
TS2203L Рулевой механизм
TS2202 Рулевой механизм
TS1324L Рулевой механизм
PUM1134 Гидравлический насос, рулевое управление
TS1310 Рулевой механизм
TS2202L Рулевой механизм
TS2201 Рулевой механизм
PUM1200 Гидравлический насос, рулевое управление
TS1310L Рулевой механизм
BOSCH K S01 000 001 Рулевой механизм
K S00 000 153 Гидравлический насос, рулевое управление
K S01 000 002 Рулевой механизм
K S01 000 121 Гидравлический насос, рулевое управление
K S00 000 807 Рулевой механизм
K S00 000 151 Гидравлический насос, рулевое управление
K S01 000 777 Рулевой механизм
K S01 000 122 Гидравлический насос, рулевое управление
K S00 001 979 Рулевой механизм
K S00 000 152 Гидравлический насос, рулевое управление
K S01 001 811 Рулевой механизм
K S01 000 123 Гидравлический насос, рулевое управление
CASCO CSB77101RS Рулевой механизм
CSP77300GS Гидравлический насос, рулевое управление
DIPASPORT IDRO008N Гидравлический насос, рулевое управление
IDRO134N Гидравлический насос, рулевое управление
DRI 711521136 Рулевой механизм
711521381 Рулевой механизм
719520356 Гидравлический насос, рулевое управление
711521382 Рулевой механизм
711521383 Рулевой механизм
ELSTOCK 11-1381 Рулевой механизм
11-1382 Рулевой механизм
19-0356 Гидравлический насос, рулевое управление
11-1383 Рулевой механизм
11-1136 Рулевой механизм
ERA Benelux SP85187 Гидравлический насос, рулевое управление
SR22154 Рулевой механизм
SP85188 Гидравлический насос, рулевое управление
SR23037 Рулевой механизм
GENERAL RICAMBI PEI002 Гидравлический насос, рулевое управление
PEI031 Гидравлический насос, рулевое управление
LAUBER 56.0014 Гидравлический насос, рулевое управление
LENCO EP5010 Гидравлический насос, рулевое управление
SGA133L Рулевой механизм
SGA162L Рулевой механизм
EP5009 Гидравлический насос, рулевое управление
LIZARTE 04.55.1400 Гидравлический насос, рулевое управление
01.62.7802 Рулевой механизм
01.62.7830 Рулевой механизм
MAPCO 29859 Рулевой механизм
29990 Гидрофильтр, рулевое управление
OCAP 0602138-K Ремкомплект, рулевой механизм
0602139-K Ремкомплект, рулевой механизм
QUINTON HAZELL QSRP1570 Рулевой механизм
QSRP1567 Рулевой механизм
QSRPA737 Гидравлический насос, рулевое управление
QSRP1568 Рулевой механизм
QSRP1569 Рулевой механизм
REMY DSR1706L Рулевой механизм
DSR2140L Рулевой механизм
DSP1638 Гидравлический насос, рулевое управление
DSR731L Рулевой механизм
DSR1705L Рулевой механизм
DSP1639 Гидравлический насос, рулевое управление
DSR776L Рулевой механизм
SASIC 7076080 Гидравлический насос, рулевое управление
7176033 Рулевой механизм
SPIDAN 51662 Рулевой механизм
54459 Гидравлический насос, рулевое управление
51633 Рулевой механизм
54458 Гидравлический насос, рулевое управление
TRISCAN 8510 24416 Рулевой механизм
8515 24626 Гидравлический насос, рулевое управление
8510 24417 Рулевой механизм
TRW JRP866 Рулевой механизм
JER142 Гидравлический насос, рулевое управление
JRP867 Рулевой механизм
JER107 Гидравлический насос, рулевое управление
URW 30-79029 Рулевой механизм
30-79030 Рулевой механизм
WAT BEGM94 Гидравлический насос, рулевое управление
GM65 Рулевой механизм
BEGM93 Гидравлический насос, рулевое управление
2026 CATCAR.INFO (v 2.0)