#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2OXx8bW9kZWxfaWQ9PTU0MTJ8fG1kZl9pZD09MF4xODU2N3x8c3BhcmVfaWQ9PTEwMDgyNg%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 = "18567" AND ( (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2020253" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2034953" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2002203" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29257" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29258" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "65 14 95-95" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "65 14 03-91" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "354005" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "454030" AND av.ProductID IN (219)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "65222802" AND av.ProductID IN (514)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "65227120" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8177822" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8077805" AND av.ProductID IN (514)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "101-00-283" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719094100" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719092300" AND av.ProductID IN (219)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719085500" AND av.ProductID IN (514)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127484" AND av.ProductID IN (219)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "91935" AND av.ProductID IN (219)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "91931" AND av.ProductID IN (514)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2110495" AND av.ProductID IN (514)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5852" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5790" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RSA001" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS1173" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0836" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "015356" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "712224" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "013177" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "57 92 9257" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "57 92 9258" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 65104" AND av.ProductID IN (514)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 65210" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V50-0038" AND av.ProductID IN (514)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "51386" AND av.ProductID IN (219,219)) ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2020253") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2034953") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002203") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29257") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29258") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 95-95") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "354005") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "454030") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65222802") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65227120") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8177822") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8077805") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-283") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719094100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719092300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719085500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127484") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91935") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91931") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2110495") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5852") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5790") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RSA001") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1173") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0836") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "015356") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "712224") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "013177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9257") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9258") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65210") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V50-0038") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51386") ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2020253") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2034953") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002203") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29257") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29258") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 95-95") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "354005") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "454030") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65222802") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65227120") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8177822") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8077805") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-283") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719094100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719092300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719085500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127484") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91935") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91931") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2110495") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5852") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5790") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RSA001") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1173") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0836") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "015356") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "712224") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "013177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9257") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9258") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65210") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V50-0038") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51386") ) AND aa.Language = "ru" Продажа автозапчастей типа Газовые пружины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DOGA 2020253 Газовая пружина, капот
2034953 Газовая пружина, крышка багажник
2002203 Газовая пружина, капот
FEBI BILSTEIN 29257 Газовая пружина, капот
29258 Газовая пружина, крышка багажник
JOHNS 65 14 95-95 Газовая пружина, крышка багажник
65 14 03-91 Газовая пружина, капот
KILEN 354005 Газовая пружина, капот
454030 Газовая пружина, крышка багажник
KLOKKERHOLM 65222802 Газовая пружина, капот
65227120 Газовая пружина, крышка багажник
LESJÖFORS 8177822 Газовая пружина, крышка багажник
8077805 Газовая пружина, капот
LORO 101-00-283 Газовая пружина, капот
MAGNETI MARELLI 430719094100 Газовая пружина, капот
430719092300 Газовая пружина, крышка багажник
430719085500 Газовая пружина, капот
MALÒ 127484 Газовая пружина, крышка багажник
MAPCO 91935 Газовая пружина, крышка багажник
91931 Газовая пружина, капот
METZGER 2110495 Газовая пружина, капот
MONROE ML5852 Газовая пружина, крышка багажник
ML5790 Газовая пружина, капот
montcada RSA001 Газовая пружина, крышка багажник
ROC GS1173 Газовая пружина, крышка багажник
GS0836 Газовая пружина, капот
STABILUS 015356 Газовая пружина, крышка багажник
712224 Газовая пружина, капот
013177 Газовая пружина, капот
SWAG 57 92 9257 Газовая пружина, капот
57 92 9258 Газовая пружина, крышка багажник
TRISCAN 8710 65104 Газовая пружина, капот
8710 65210 Газовая пружина, крышка багажник
VAICO V50-0038 Газовая пружина, капот
VEMA 51386 Газовая пружина, крышка багажник
2026 CATCAR.INFO (v 2.0)