#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OHx8bW9kZWxfaWQ9PTk2OTd8fG1kZl9pZD09MF4xMTAzM3x8c3BhcmVfaWQ9PTEwMDYwMw%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 = "11033" AND ( (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "HY-A-11396" AND av.ProductID IN (914)) OR (av.SupplierID = 4987 AND av.DataSupplierArticleNumber = "HY-A-11395" AND av.ProductID IN (914)) OR (av.SupplierID = 4010 AND av.DataSupplierArticleNumber = "SEK-8591L" AND av.ProductID IN (914)) OR (av.SupplierID = 4010 AND av.DataSupplierArticleNumber = "SEK-8591R" AND av.ProductID IN (914)) OR (av.SupplierID = 4010 AND av.DataSupplierArticleNumber = "SRK-8590" AND av.ProductID IN (51)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "240637" AND av.ProductID IN (51)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "231006" AND av.ProductID IN (914)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "231007" AND av.ProductID IN (914)) OR (av.SupplierID = 4829 AND av.DataSupplierArticleNumber = "20KI2010" AND av.ProductID IN (51)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "103-0K-K18" AND av.ProductID IN (51)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "111-0K-K14L" AND av.ProductID IN (914)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "111-0K-K14R" AND av.ProductID IN (914)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1310416L" AND av.ProductID IN (914)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1310417R" AND av.ProductID IN (914)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1370190LR" AND av.ProductID IN (51)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "AX0165" AND av.ProductID IN (51)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADG087194" AND av.ProductID IN (914)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADG087195" AND av.ProductID IN (914)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADG087199" AND av.ProductID IN (51)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 40-310-065" AND av.ProductID IN (914)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 40-310-124" AND av.ProductID IN (51)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 40-310-064" AND av.ProductID IN (914)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TA3204" AND av.ProductID IN (51)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS9189" AND av.ProductID IN (51)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "1222-SB" AND av.ProductID IN (51)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "2222-RIO" AND av.ProductID IN (51)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48060" AND av.ProductID IN (914)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48064" AND av.ProductID IN (51)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48059" AND av.ProductID IN (914)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "SP40087" AND av.ProductID IN (51)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "4902032" AND av.ProductID IN (914)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "4902033" AND av.ProductID IN (914)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "3707035" AND av.ProductID IN (51)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "4488" AND av.ProductID IN (914)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "4489" AND av.ProductID IN (51)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "4487" AND av.ProductID IN (914)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP201384" AND av.ProductID IN (914,914)) OR (av.SupplierID = 4844 AND av.DataSupplierArticleNumber = "GSP201385" AND av.ProductID IN (914,914)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4840323" AND av.ProductID IN (51)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4820325" AND av.ProductID IN (914)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4830325" AND av.ProductID IN (914)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "TI-K14L" AND av.ProductID IN (914)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "TI-K14R" AND av.ProductID IN (914)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "RD-K18" AND av.ProductID IN (51)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "103K18" AND av.ProductID IN (51)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "111K14L" AND av.ProductID IN (914)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "111K14R" AND av.ProductID IN (914)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9981218" AND av.ProductID IN (51)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9981336" AND av.ProductID IN (914)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "9981337" AND av.ProductID IN (914)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "STE-4046" AND av.ProductID IN (914)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "STE-4045" AND av.ProductID IN (914)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "STR-3033" AND av.ProductID IN (51)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 43130" AND av.ProductID IN (914)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 43225" AND av.ProductID IN (51)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 43129" AND av.ProductID IN (914)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "36737 01" AND av.ProductID IN (51)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C2349LR" AND av.ProductID IN (51)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C4326L" AND av.ProductID IN (914)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C4326R" AND av.ProductID IN (914)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "54544" AND av.ProductID IN (914)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "52379" AND av.ProductID IN (51)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "54543" AND av.ProductID IN (914)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MRE-8K18" AND av.ProductID IN (51)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTR-8K14L" AND av.ProductID IN (914)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTR-8K14R" AND av.ProductID IN (914)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "28-16 031 0022" AND av.ProductID IN (51)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L43130" AND av.ProductID IN (914)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L43225" AND av.ProductID IN (51)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L43129" AND av.ProductID IN (914)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "HY-ES-13701" AND av.ProductID IN (914)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "KI-AX-13985" AND av.ProductID IN (51)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "HY-ES-13702" AND av.ProductID IN (914)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4830537" AND av.ProductID IN (914)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4840538" AND av.ProductID IN (51)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4820537" AND av.ProductID IN (914)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5033459" AND av.ProductID IN (914)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5033460" AND av.ProductID IN (914)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5033458" AND av.ProductID IN (51)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0285494" AND av.ProductID IN (914)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0295494" AND av.ProductID IN (914)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0605494" AND av.ProductID IN (51)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR3973S" AND av.ProductID IN (914)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR3975S" AND av.ProductID IN (51)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QR3974S" AND av.ProductID IN (914)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "HY3032" AND av.ProductID IN (51)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "91-08863-2" AND av.ProductID IN (914)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "91-08863-1" AND av.ProductID IN (914)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "92-08851" AND av.ProductID IN (51)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7676104" AND av.ProductID IN (914)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7776101" AND av.ProductID IN (51)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7676105" AND av.ProductID IN (914)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7776114" AND av.ProductID IN (51)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065033458" AND av.ProductID IN (51)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065033459" AND av.ProductID IN (914)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19065033460" AND av.ProductID IN (914)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "81337" AND av.ProductID IN (914)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "81218" AND av.ProductID IN (51)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "81336" AND av.ProductID IN (914)) OR (av.SupplierID = 4348 AND av.DataSupplierArticleNumber = "SM-TEK042" AND av.ProductID IN (914)) OR (av.SupplierID = 4348 AND av.DataSupplierArticleNumber = "SM-TEK043" AND av.ProductID IN (914)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "55-00265-SX" AND av.ProductID IN (51)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "90 94 8064" AND av.ProductID IN (51)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "90 94 8059" AND av.ProductID IN (914)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "90 94 8060" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "42-07835" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "42-07834" AND av.ProductID IN (914)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "44-07832" AND av.ProductID IN (51)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "821 367" AND av.ProductID IN (51)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 43129" AND av.ProductID IN (914)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 43225" AND av.ProductID IN (51)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 43130" AND av.ProductID IN (914)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V52-0282" AND av.ProductID IN (914)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V52-0281" AND av.ProductID IN (914)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V52-0289" AND av.ProductID IN (51)) OR (av.SupplierID = 4468 AND av.DataSupplierArticleNumber = "I30320YMT" AND av.ProductID IN (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 = "HY-A-11396") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "HY-A-11395") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SEK-8591L") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SEK-8591R") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SRK-8590") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240637") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "231006") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "231007") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20KI2010") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "103-0K-K18") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0K-K14L") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0K-K14R") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1310416L") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1310417R") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1370190LR") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX0165") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087194") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087195") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087199") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-124") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-064") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA3204") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS9189") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1222-SB") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "2222-RIO") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48060") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48064") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48059") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "SP40087") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "4902032") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "4902033") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3707035") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4488") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4489") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4487") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201384") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201385") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4840323") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4820325") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4830325") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-K14L") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-K14R") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "RD-K18") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "103K18") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111K14L") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111K14R") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981218") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981336") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981337") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-4046") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-4045") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STR-3033") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43130") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43225") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43129") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "36737 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2349LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4326L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4326R") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "54544") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "52379") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "54543") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MRE-8K18") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8K14L") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8K14R") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "28-16 031 0022") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43130") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43225") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43129") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "HY-ES-13701") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "KI-AX-13985") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "HY-ES-13702") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4830537") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4840538") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4820537") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033459") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033460") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033458") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0285494") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0295494") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0605494") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3973S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3975S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3974S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "HY3032") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-08863-2") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-08863-1") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-08851") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7676104") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7776101") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7676105") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7776114") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033458") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033459") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033460") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81337") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81218") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81336") OR (aa.SupplierID = 4348 AND aa.DataSupplierArticleNumber = "SM-TEK042") OR (aa.SupplierID = 4348 AND aa.DataSupplierArticleNumber = "SM-TEK043") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-00265-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8064") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8059") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8060") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-07835") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-07834") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-07832") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "821 367") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43129") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43225") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43130") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0282") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0281") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0289") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I30320YMT") ) 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 = "HY-A-11396") OR (aa.SupplierID = 4987 AND aa.DataSupplierArticleNumber = "HY-A-11395") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SEK-8591L") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SEK-8591R") OR (aa.SupplierID = 4010 AND aa.DataSupplierArticleNumber = "SRK-8590") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "240637") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "231006") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "231007") OR (aa.SupplierID = 4829 AND aa.DataSupplierArticleNumber = "20KI2010") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "103-0K-K18") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0K-K14L") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "111-0K-K14R") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1310416L") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1310417R") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1370190LR") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "AX0165") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087194") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087195") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG087199") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-124") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-310-064") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TA3204") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS9189") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1222-SB") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "2222-RIO") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48060") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48064") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48059") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "SP40087") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "4902032") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "4902033") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "3707035") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4488") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4489") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "4487") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201384") OR (aa.SupplierID = 4844 AND aa.DataSupplierArticleNumber = "GSP201385") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4840323") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4820325") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4830325") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-K14L") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TI-K14R") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "RD-K18") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "103K18") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111K14L") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "111K14R") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981218") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981336") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "9981337") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-4046") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STE-4045") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "STR-3033") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43130") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43225") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 43129") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "36737 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C2349LR") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4326L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C4326R") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "54544") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "52379") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "54543") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MRE-8K18") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8K14L") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTR-8K14R") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "28-16 031 0022") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43130") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43225") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L43129") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "HY-ES-13701") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "KI-AX-13985") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "HY-ES-13702") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4830537") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4840538") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4820537") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033459") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033460") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5033458") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0285494") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0295494") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0605494") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3973S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3975S") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QR3974S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "HY3032") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-08863-2") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "91-08863-1") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "92-08851") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7676104") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7776101") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7676105") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7776114") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033458") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033459") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19065033460") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81337") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81218") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "81336") OR (aa.SupplierID = 4348 AND aa.DataSupplierArticleNumber = "SM-TEK042") OR (aa.SupplierID = 4348 AND aa.DataSupplierArticleNumber = "SM-TEK043") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "55-00265-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8064") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8059") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 94 8060") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-07835") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "42-07834") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "44-07832") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "821 367") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43129") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43225") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 43130") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0282") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0281") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0289") OR (aa.SupplierID = 4468 AND aa.DataSupplierArticleNumber = "I30320YMT") ) AND aa.Language = "ru" Продажа автозапчастей типа Отдельные элементы рулевой тяги для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
4u HY-A-11396 Наконечник поперечной рулевой тяги
HY-A-11395 Наконечник поперечной рулевой тяги
555 SEK-8591L Наконечник поперечной рулевой тяги
SEK-8591R Наконечник поперечной рулевой тяги
SRK-8590 Осевой шарнир, рулевая тяга
A.B.S. 240637 Осевой шарнир, рулевая тяга
231006 Наконечник поперечной рулевой тяги
231007 Наконечник поперечной рулевой тяги
AS METAL 20KI2010 Осевой шарнир, рулевая тяга
ASHIKA 103-0K-K18 Осевой шарнир, рулевая тяга
111-0K-K14L Наконечник поперечной рулевой тяги
111-0K-K14R Наконечник поперечной рулевой тяги
AYWIPARTS AW1310416L Наконечник поперечной рулевой тяги
AW1310417R Наконечник поперечной рулевой тяги
AW1370190LR Осевой шарнир, рулевая тяга
BIRTH AX0165 Осевой шарнир, рулевая тяга
BLUE PRINT ADG087194 Наконечник поперечной рулевой тяги
ADG087195 Наконечник поперечной рулевой тяги
ADG087199 Осевой шарнир, рулевая тяга
BSG BSG 40-310-065 Наконечник поперечной рулевой тяги
BSG 40-310-124 Осевой шарнир, рулевая тяга
BSG 40-310-064 Наконечник поперечной рулевой тяги
DELPHI TA3204 Осевой шарнир, рулевая тяга
FAI AutoParts SS9189 Осевой шарнир, рулевая тяга
FEBEST 1222-SB Осевой шарнир, рулевая тяга
2222-RIO Осевой шарнир, рулевая тяга
FEBI BILSTEIN 48060 Наконечник поперечной рулевой тяги
48064 Осевой шарнир, рулевая тяга
48059 Наконечник поперечной рулевой тяги
FENOX SP40087 Осевой шарнир, рулевая тяга
FORMPART 4902032 Наконечник поперечной рулевой тяги
4902033 Наконечник поперечной рулевой тяги
3707035 Осевой шарнир, рулевая тяга
FRAP 4488 Наконечник поперечной рулевой тяги
4489 Осевой шарнир, рулевая тяга
4487 Наконечник поперечной рулевой тяги
G.U.D. GSP201384 Наконечник поперечной рулевой тяги
GSP201385 Наконечник поперечной рулевой тяги
HERTH+BUSS JAKOPARTS J4840323 Осевой шарнир, рулевая тяга
J4820325 Наконечник поперечной рулевой тяги
J4830325 Наконечник поперечной рулевой тяги
JAPANPARTS TI-K14L Наконечник поперечной рулевой тяги
TI-K14R Наконечник поперечной рулевой тяги
RD-K18 Осевой шарнир, рулевая тяга
JAPKO 103K18 Осевой шарнир, рулевая тяга
111K14L Наконечник поперечной рулевой тяги
111K14R Наконечник поперечной рулевой тяги
KAMOKA 9981218 Осевой шарнир, рулевая тяга
9981336 Наконечник поперечной рулевой тяги
9981337 Наконечник поперечной рулевой тяги
KAVO PARTS STE-4046 Наконечник поперечной рулевой тяги
STE-4045 Наконечник поперечной рулевой тяги
STR-3033 Осевой шарнир, рулевая тяга
KAWE 8500 43130 Наконечник поперечной рулевой тяги
8500 43225 Осевой шарнир, рулевая тяга
8500 43129 Наконечник поперечной рулевой тяги
LEMFÖRDER 36737 01 Осевой шарнир, рулевая тяга
LYNXauto C2349LR Осевой шарнир, рулевая тяга
C4326L Наконечник поперечной рулевой тяги
C4326R Наконечник поперечной рулевой тяги
MAPCO 54544 Наконечник поперечной рулевой тяги
52379 Осевой шарнир, рулевая тяга
54543 Наконечник поперечной рулевой тяги
MDR MRE-8K18 Осевой шарнир, рулевая тяга
MTR-8K14L Наконечник поперечной рулевой тяги
MTR-8K14R Наконечник поперечной рулевой тяги
MEYLE 28-16 031 0022 Осевой шарнир, рулевая тяга
MONROE L43130 Наконечник поперечной рулевой тяги
L43225 Осевой шарнир, рулевая тяга
L43129 Наконечник поперечной рулевой тяги
MOOG HY-ES-13701 Наконечник поперечной рулевой тяги
KI-AX-13985 Осевой шарнир, рулевая тяга
HY-ES-13702 Наконечник поперечной рулевой тяги
NIPPARTS N4830537 Наконечник поперечной рулевой тяги
N4840538 Осевой шарнир, рулевая тяга
N4820537 Наконечник поперечной рулевой тяги
NK 5033459 Наконечник поперечной рулевой тяги
5033460 Наконечник поперечной рулевой тяги
5033458 Осевой шарнир, рулевая тяга
OCAP 0285494 Наконечник поперечной рулевой тяги
0295494 Наконечник поперечной рулевой тяги
0605494 Осевой шарнир, рулевая тяга
QUINTON HAZELL QR3973S Наконечник поперечной рулевой тяги
QR3975S Осевой шарнир, рулевая тяга
QR3974S Наконечник поперечной рулевой тяги
RIW HY3032 Осевой шарнир, рулевая тяга
RTS 91-08863-2 Наконечник поперечной рулевой тяги
91-08863-1 Наконечник поперечной рулевой тяги
92-08851 Осевой шарнир, рулевая тяга
SASIC 7676104 Наконечник поперечной рулевой тяги
7776101 Осевой шарнир, рулевая тяга
7676105 Наконечник поперечной рулевой тяги
7776114 Осевой шарнир, рулевая тяга
sbs 19065033458 Осевой шарнир, рулевая тяга
19065033459 Наконечник поперечной рулевой тяги
19065033460 Наконечник поперечной рулевой тяги
SIDEM 81337 Наконечник поперечной рулевой тяги
81218 Осевой шарнир, рулевая тяга
81336 Наконечник поперечной рулевой тяги
SpeedMate SM-TEK042 Наконечник поперечной рулевой тяги
SM-TEK043 Наконечник поперечной рулевой тяги
STELLOX 55-00265-SX Осевой шарнир, рулевая тяга
SWAG 90 94 8064 Осевой шарнир, рулевая тяга
90 94 8059 Наконечник поперечной рулевой тяги
90 94 8060 Наконечник поперечной рулевой тяги
TALOSA 42-07835 Наконечник поперечной рулевой тяги
42-07834 Наконечник поперечной рулевой тяги
44-07832 Осевой шарнир, рулевая тяга
TOPRAN 821 367 Осевой шарнир, рулевая тяга
TRISCAN 8500 43129 Наконечник поперечной рулевой тяги
8500 43225 Осевой шарнир, рулевая тяга
8500 43130 Наконечник поперечной рулевой тяги
VAICO V52-0282 Наконечник поперечной рулевой тяги
V52-0281 Наконечник поперечной рулевой тяги
V52-0289 Осевой шарнир, рулевая тяга
YAMATO I30320YMT Осевой шарнир, рулевая тяга
2026 CATCAR.INFO (v 2.0)