#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU3MHx8bWRmX2lkPT0wXjc3M3x8c3BhcmVfaWQ9PTEwMDU3Nw%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 = "773" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "260093" AND av.ProductID IN (3229)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "260092" AND av.ProductID IN (3229)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "042434B" AND av.ProductID IN (3229)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BDL6141" AND av.ProductID IN (3229)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "180918" AND av.ProductID IN (3229)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TC2040" AND av.ProductID IN (3229)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "F0014M" AND av.ProductID IN (3229)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "F0043M" AND av.ProductID IN (3229)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FDL6141" AND av.ProductID IN (3229)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL903-H" AND av.ProductID IN (3229)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ7014" AND av.ProductID IN (3229)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "10901 03" AND av.ProductID IN (3229)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "24371" AND av.ProductID IN (3229)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "016 060 0221" AND av.ProductID IN (3229)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "ME-LS-0221" AND av.ProductID IN (3229)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0500716" AND av.ProductID IN (3229)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "G7-014" AND av.ProductID IN (3229)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QLS2509S" AND av.ProductID IN (3229)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "ME4003" AND av.ProductID IN (3229)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "97-00847" AND av.ProductID IN (3229)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "97-00899" AND av.ProductID IN (3229)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "915103" AND av.ProductID IN (3229)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "49091" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-02045-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-00659-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-01202-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "50-01990" AND av.ProductID IN (3229)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "50-01937" AND av.ProductID IN (3229)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783766" AND av.ProductID IN (3229)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783568" AND av.ProductID IN (3229)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTS145" AND av.ProductID IN (3229)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-7119" AND av.ProductID IN (3229)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "15075" AND av.ProductID IN (3229,3229)) ) 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 = 206 AND aa.DataSupplierArticleNumber = "260093") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "260092") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "042434B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL6141") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "180918") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TC2040") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0014M") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0043M") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL6141") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL903-H") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ7014") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10901 03") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "24371") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "016 060 0221") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "ME-LS-0221") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0500716") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G7-014") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QLS2509S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "ME4003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00847") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00899") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915103") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "49091") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-02045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-00659-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-01202-SX") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01990") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01937") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783766") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783568") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTS145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7119") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "15075") ) 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 = 206 AND aa.DataSupplierArticleNumber = "260093") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "260092") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "042434B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL6141") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "180918") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TC2040") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0014M") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0043M") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL6141") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL903-H") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ7014") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10901 03") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "24371") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "016 060 0221") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "ME-LS-0221") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0500716") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G7-014") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QLS2509S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "ME4003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00847") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00899") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915103") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "49091") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-02045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-00659-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-01202-SX") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01990") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01937") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783766") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783568") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTS145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7119") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "15075") ) AND aa.Language = "ru" Продажа автозапчастей типа Соединительная тяга для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 260093 Тяга / стойка, стабилизатор
260092 Тяга / стойка, стабилизатор
BENDIX 042434B Тяга / стойка, стабилизатор
BORG & BECK BDL6141 Тяга / стойка, стабилизатор
CAUTEX 180918 Тяга / стойка, стабилизатор
DELPHI TC2040 Тяга / стойка, стабилизатор
FARE SA F0014M Тяга / стойка, стабилизатор
F0043M Тяга / стойка, стабилизатор
FIRST LINE FDL6141 Тяга / стойка, стабилизатор
FLENNOR FL903-H Тяга / стойка, стабилизатор
FORTUNE LINE FZ7014 Тяга / стойка, стабилизатор
LEMFÖRDER 10901 03 Тяга / стойка, стабилизатор
MALÒ 24371 Тяга / стойка, стабилизатор
MEYLE 016 060 0221 Тяга / стойка, стабилизатор
MOOG ME-LS-0221 Тяга / стойка, стабилизатор
OCAP 0500716 Тяга / стойка, стабилизатор
OPTIMAL G7-014 Тяга / стойка, стабилизатор
QUINTON HAZELL QLS2509S Тяга / стойка, стабилизатор
RIW ME4003 Тяга / стойка, стабилизатор
RTS 97-00847 Тяга / стойка, стабилизатор
97-00899 Тяга / стойка, стабилизатор
RUVILLE 915103 Тяга / стойка, стабилизатор
SIDEM 49091 Тяга / стойка, стабилизатор
STELLOX 56-02045-SX Тяга / стойка, стабилизатор
56-00659-SX Тяга / стойка, стабилизатор
56-01202-SX Тяга / стойка, стабилизатор
TALOSA 50-01990 Тяга / стойка, стабилизатор
50-01937 Тяга / стойка, стабилизатор
TRICLO 783766 Тяга / стойка, стабилизатор
783568 Тяга / стойка, стабилизатор
TRW JTS145 Тяга / стойка, стабилизатор
VAICO V30-7119 Тяга / стойка, стабилизатор
VEMA 15075 Тяга / стойка, стабилизатор
2026 CATCAR.INFO (v 2.0)