#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTU2MDF8fG1kZl9pZD09MF4zMTc0M3x8c3BhcmVfaWQ9PTEwMjIzOQ%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 = "31743" AND ( (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "885091" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654294" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654449" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654602" AND av.ProductID IN (1390)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RT5053" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81496" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81011" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81218" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81389" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A07560" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A08148" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A05696" AND av.ProductID IN (1390)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BBA5078" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA3901" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA4047" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA3855" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "87914" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88208" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "20467" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9013" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9040" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9042" AND av.ProductID IN (1390)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "219243" AND av.ProductID IN (1390)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "219238" AND av.ProductID IN (1390)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10843" AND av.ProductID IN (1390)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13493" AND av.ProductID IN (1390)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10836" AND av.ProductID IN (1390)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "OP6011" AND av.ProductID IN (1390)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "OP6012" AND av.ProductID IN (1390)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "455140" AND av.ProductID IN (1390)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "455106" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 3579 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5376 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5410 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-361" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1070" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1027" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1036" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1053" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1013" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0149 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0179 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0062 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3597" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3289" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3444" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI14240" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI18900" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI20370" AND av.ProductID IN (1390)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1228908" AND av.ProductID IN (1390)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LOPA0056" AND av.ProductID IN (1390)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LOPA0120" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1048" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1103" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1126" AND av.ProductID IN (1390)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "14301" AND av.ProductID IN (1390)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "14302" AND av.ProductID IN (1390)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "14307" AND av.ProductID IN (1390)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "30-0101" AND av.ProductID IN (1390)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "06152" AND av.ProductID IN (1390)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "06009" AND av.ProductID IN (1390)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "06016" AND av.ProductID IN (1390)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "4910154" AND av.ProductID IN (1390)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "4910158" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1048" AND av.ProductID IN (1390)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P5006210" AND av.ProductID IN (1390)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P5014910" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2934" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3105" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3212" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2727" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56657" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "59945" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56656" AND av.ProductID IN (1390)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "455140" AND av.ProductID IN (1390)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "455106" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03307" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03302" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03308" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03305" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03306" AND av.ProductID IN (1390)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GA759.05" AND av.ProductID IN (1390)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T406152" AND av.ProductID IN (1390)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T406009" AND av.ProductID IN (1390)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T406016" AND av.ProductID IN (1390)) OR (av.SupplierID = 4896 AND av.DataSupplierArticleNumber = "KR6006" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 284001" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 284002" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 104012" AND av.ProductID IN (1390)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "431222" AND av.ProductID IN (1390)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "24-94261" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253641" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152068" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253724" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152094" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253753" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152096" AND av.ProductID IN (1390)) ) 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 = 4528 AND aa.DataSupplierArticleNumber = "885091") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654294") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654449") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654602") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT5053") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81496") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81011") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81218") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81389") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07560") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08148") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A05696") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBA5078") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3901") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4047") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3855") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "87914") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88208") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "20467") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9013") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9040") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9042") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219243") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219238") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10843") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13493") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10836") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "OP6011") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "OP6012") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455140") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455106") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 3579 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5376 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5410 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-361") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1070") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1027") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1036") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1053") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1013") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0149 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0179 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0062 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3597") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3289") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3444") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI14240") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI18900") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20370") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228908") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0056") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0120") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1048") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1103") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1126") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14301") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14302") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14307") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "30-0101") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06152") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06009") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06016") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4910154") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4910158") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1048") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5006210") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5014910") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2934") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3105") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3212") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2727") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56657") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59945") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56656") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455140") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455106") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03307") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03302") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03308") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03305") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03306") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA759.05") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406152") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406009") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406016") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "KR6006") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284002") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 104012") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "431222") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "24-94261") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253641") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152068") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253724") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152094") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253753") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152096") ) 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 = 4528 AND aa.DataSupplierArticleNumber = "885091") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654294") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654449") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654602") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT5053") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81496") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81011") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81218") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81389") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07560") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08148") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A05696") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBA5078") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3901") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4047") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3855") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "87914") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88208") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "20467") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9013") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9040") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9042") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219243") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219238") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10843") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13493") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10836") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "OP6011") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "OP6012") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455140") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455106") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 3579 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5376 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5410 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-361") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1070") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1027") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1036") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1053") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1013") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0149 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0179 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0062 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3597") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3289") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3444") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI14240") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI18900") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20370") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228908") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0056") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0120") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1048") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1103") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1126") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14301") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14302") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14307") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "30-0101") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06152") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06009") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06016") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4910154") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4910158") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1048") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5006210") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5014910") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2934") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3105") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3212") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2727") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56657") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59945") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56656") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455140") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455106") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03307") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03302") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03308") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03305") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03306") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA759.05") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406152") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406009") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406016") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "KR6006") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284002") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 104012") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "431222") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "24-94261") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253641") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152068") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253724") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152094") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253753") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152096") ) AND aa.Language = "ru" Продажа автозапчастей типа Механизм свободного хода генератора для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AD KÜHNER 885091 Механизм свободного хода генератора
AUTEX 654294 Механизм свободного хода генератора
654449 Механизм свободного хода генератора
654602 Механизм свободного хода генератора
AUTLOG RT5053 Механизм свободного хода генератора
AUTOKIT 03.81496 Механизм свободного хода генератора
03.81011 Механизм свободного хода генератора
03.81218 Механизм свободного хода генератора
03.81389 Механизм свободного хода генератора
AUTOTEAM A07560 Механизм свободного хода генератора
A08148 Механизм свободного хода генератора
A05696 Механизм свободного хода генератора
BORG & BECK BBA5078 Механизм свободного хода генератора
BREDA LORETT RLA3901 Механизм свободного хода генератора
RLA4047 Механизм свободного хода генератора
RLA3855 Механизм свободного хода генератора
CALIBER 87914 Механизм свободного хода генератора
88208 Механизм свободного хода генератора
20467 Механизм свободного хода генератора
CONTITECH AP9013 Механизм свободного хода генератора
AP9040 Механизм свободного хода генератора
AP9042 Механизм свободного хода генератора
ERA 219243 Механизм свободного хода генератора
219238 Механизм свободного хода генератора
FARE SA 10843 Механизм свободного хода генератора
13493 Механизм свободного хода генератора
10836 Механизм свободного хода генератора
FENOX OP6011 Механизм свободного хода генератора
OP6012 Механизм свободного хода генератора
FISPA 455140 Механизм свободного хода генератора
455106 Механизм свободного хода генератора
GEBE 3 3579 1 Механизм свободного хода генератора
3 5376 1 Механизм свободного хода генератора
3 5410 1 Механизм свободного хода генератора
HELLA 9XU 358 038-361 Механизм свободного хода генератора
IJS GROUP 30-1070 Механизм свободного хода генератора
30-1027 Механизм свободного хода генератора
30-1036 Механизм свободного хода генератора
30-1053 Механизм свободного хода генератора
30-1013 Механизм свободного хода генератора
INA 535 0149 10 Механизм свободного хода генератора
535 0179 10 Механизм свободного хода генератора
535 0062 10 Механизм свободного хода генератора
IPD 15-3597 Механизм свободного хода генератора
15-3289 Механизм свободного хода генератора
15-3444 Механизм свободного хода генератора
KM International FI14240 Механизм свободного хода генератора
FI18900 Механизм свободного хода генератора
FI20370 Механизм свободного хода генератора
KRAFT AUTOMOTIVE 1228908 Механизм свободного хода генератора
LUCAS ENGINE DRIVE LOPA0056 Механизм свободного хода генератора
LOPA0120 Механизм свободного хода генератора
LYNXauto PA-1048 Механизм свободного хода генератора
PA-1103 Механизм свободного хода генератора
PA-1126 Механизм свободного хода генератора
MAPCO 14301 Механизм свободного хода генератора
14302 Механизм свободного хода генератора
14307 Механизм свободного хода генератора
MAXGEAR 30-0101 Механизм свободного хода генератора
Metalcaucho 06152 Механизм свободного хода генератора
06009 Механизм свободного хода генератора
06016 Механизм свободного хода генератора
NK 4910154 Механизм свободного хода генератора
4910158 Механизм свободного хода генератора
OPTIMAL F5-1048 Механизм свободного хода генератора
PATRON P5006210 Механизм свободного хода генератора
P5014910 Механизм свободного хода генератора
REPKIT RKT2934 Механизм свободного хода генератора
RKT3105 Механизм свободного хода генератора
RKT3212 Механизм свободного хода генератора
RKT2727 Механизм свободного хода генератора
RUVILLE 56657 Механизм свободного хода генератора
59945 Механизм свободного хода генератора
56656 Механизм свободного хода генератора
SIDAT 455140 Механизм свободного хода генератора
455106 Механизм свободного хода генератора
SKF VKM 03307 Механизм свободного хода генератора
VKM 03302 Механизм свободного хода генератора
VKM 03308 Механизм свободного хода генератора
VKM 03305 Механизм свободного хода генератора
VKM 03306 Механизм свободного хода генератора
SNR GA759.05 Механизм свободного хода генератора
STC T406152 Механизм свободного хода генератора
T406009 Механизм свободного хода генератора
T406016 Механизм свободного хода генератора
TORQUE KR6006 Механизм свободного хода генератора
TRISCAN 8641 284001 Механизм свободного хода генератора
8641 284002 Механизм свободного хода генератора
8641 104012 Механизм свободного хода генератора
UNIGOM 431222 Механизм свободного хода генератора
WAI 24-94261 Механизм свободного хода генератора
WILMINK GROUP WG1253641 Механизм свободного хода генератора
WG1152068 Механизм свободного хода генератора
WG1253724 Механизм свободного хода генератора
WG1152094 Механизм свободного хода генератора
WG1253753 Механизм свободного хода генератора
WG1152096 Механизм свободного хода генератора
2026 CATCAR.INFO (v 2.0)