#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3OXx8bW9kZWxfaWQ9PTM3Mjg2fHxtZGZfaWQ9PTBeODcxNnx8c3BhcmVfaWQ9PTEwMDE5Nw%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 = "8716" AND ( (av.SupplierID = 4010 AND av.DataSupplierArticleNumber = "SS-2720" AND av.ProductID IN (284)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADT387141" AND av.ProductID IN (284)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BDL7039" AND av.ProductID IN (284)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "43175" AND av.ProductID IN (284)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FDL7039" AND av.ProductID IN (284)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PS2132" AND av.ProductID IN (284)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "81 94 3175" AND av.ProductID IN (284)) ) 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 = 4010 AND aa.DataSupplierArticleNumber = "SS-2720") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADT387141") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL7039") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "43175") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL7039") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2132") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "81 94 3175") ) 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 = 4010 AND aa.DataSupplierArticleNumber = "SS-2720") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADT387141") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL7039") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "43175") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL7039") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PS2132") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "81 94 3175") ) AND aa.Language = "ru" Продажа автозапчастей типа Рулевая тяга для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
555 SS-2720 Поперечная рулевая тяга
BLUE PRINT ADT387141 Поперечная рулевая тяга
BORG & BECK BDL7039 Поперечная рулевая тяга
FEBI BILSTEIN 43175 Поперечная рулевая тяга
FIRST LINE FDL7039 Поперечная рулевая тяга
PATRON PS2132 Поперечная рулевая тяга
SWAG 81 94 3175 Поперечная рулевая тяга
2026 CATCAR.INFO (v 2.0)