#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTgwOTV8fG1kZl9pZD09MF4zMTM1MHx8c3BhcmVfaWQ9PTEwMDU4Ng%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 = "31350" AND ( (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461184" AND av.ProductID IN (1080)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461183" AND av.ProductID IN (1080)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1095W" AND av.ProductID IN (1080)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1378W" AND av.ProductID IN (1080)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS8730" AND av.ProductID IN (1080)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS8729" AND av.ProductID IN (1080)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10274" AND av.ProductID IN (1080)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32563" AND av.ProductID IN (1080)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38946" AND av.ProductID IN (1080)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39587" AND av.ProductID IN (1080)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1150102600" AND av.ProductID IN (1080)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800340" AND av.ProductID IN (1080)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800341" AND av.ProductID IN (1080)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4230008" AND av.ProductID IN (1080)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8710" AND av.ProductID IN (1080)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8709" AND av.ProductID IN (1080)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "38810" AND av.ProductID IN (1080)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "05354" AND av.ProductID IN (1080)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "837302" AND av.ProductID IN (1080)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "837303" AND av.ProductID IN (1080)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T405354" AND av.ProductID IN (1080)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 2563" AND av.ProductID IN (1080)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 8946" AND av.ProductID IN (1080)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9587" AND av.ProductID IN (1080)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.32.063" AND av.ProductID IN (1080)) ) 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 = 405 AND aa.DataSupplierArticleNumber = "461184") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461183") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1095W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1378W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS8730") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS8729") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32563") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38946") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39587") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150102600") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800340") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800341") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230008") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8710") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8709") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38810") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05354") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "837302") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "837303") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405354") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2563") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 8946") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9587") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.32.063") ) 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 = 405 AND aa.DataSupplierArticleNumber = "461184") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461183") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1095W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1378W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS8730") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS8729") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32563") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38946") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39587") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150102600") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800340") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800341") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230008") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8710") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8709") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38810") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05354") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "837302") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "837303") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405354") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2563") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 8946") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9587") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.32.063") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CAUTEX 461184 Втулка, балка моста
461183 Втулка, балка моста
DELPHI TD1095W Втулка, балка моста
TD1378W Втулка, балка моста
FAI AutoParts SS8730 Втулка, балка моста
SS8729 Втулка, балка моста
FARE SA 10274 Втулка, балка моста
FEBI BILSTEIN 32563 Втулка, балка моста
38946 Втулка, балка моста
39587 Втулка, балка моста
JP GROUP 1150102600 Втулка, балка моста
KAMOKA 8800340 Втулка, балка моста
8800341 Втулка, балка моста
KRAFT AUTOMOTIVE 4230008 Втулка, балка моста
LYNXauto C8710 Втулка, балка моста
C8709 Втулка, балка моста
MAPCO 38810 Втулка, балка моста
Metalcaucho 05354 Втулка, балка моста
SIDEM 837302 Втулка, балка моста
837303 Втулка, балка моста
STC T405354 Втулка, балка моста
SWAG 30 93 2563 Втулка, балка моста
30 93 8946 Втулка, балка моста
30 93 9587 Втулка, балка моста
TRUCKTEC AUTOMOTIVE 07.32.063 Втулка, балка моста
2026 CATCAR.INFO (v 2.0)