#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTgwfHxtZGZfaWQ9PTBeNjM3fHxzcGFyZV9pZD09MTAwODI2&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 = "637" AND ( (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003813" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003853" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003973" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003733" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "55 05 95-96" AND av.ProductID IN (219)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1281200609" AND av.ProductID IN (219)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "444021" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8163421" AND av.ProductID IN (219)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719089800" AND av.ProductID IN (2454)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719089900" AND av.ProductID IN (2454)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127162" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5834" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5835" AND av.ProductID IN (219)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "ROP014" AND av.ProductID IN (219)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17184" AND av.ProductID IN (219)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17220" AND av.ProductID IN (219)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8339BK" AND av.ProductID IN (219)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8453BV" AND av.ProductID IN (219)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128295" AND av.ProductID IN (219)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128331" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0317" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "8339BK" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "8985BM" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20814-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20834-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20839-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 2413" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 2412" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0731" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0733" AND av.ProductID IN (219)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "51227" AND av.ProductID IN (219,219)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1060" AND av.ProductID IN (219)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1059" AND av.ProductID IN (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 = "2003813") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003853") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003973") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003733") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "55 05 95-96") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1281200609") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "444021") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8163421") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089800") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089900") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127162") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5835") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "ROP014") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17184") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17220") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8339BK") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8453BV") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128295") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128331") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0317") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8339BK") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8985BM") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20814-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20834-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20839-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2413") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2412") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0731") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0733") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51227") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1060") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1059") ) 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 = "2003813") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003853") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003973") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003733") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "55 05 95-96") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1281200609") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "444021") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8163421") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089800") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089900") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127162") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5835") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "ROP014") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17184") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17220") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8339BK") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8453BV") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128295") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128331") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0317") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8339BK") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8985BM") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20814-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20834-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20839-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2413") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2412") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0731") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0733") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51227") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1060") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1059") ) AND aa.Language = "ru" Продажа автозапчастей типа Газовые пружины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DOGA 2003813 Газовая пружина, крышка багажник
2003853 Газовая пружина, крышка багажник
2003973 Газовая пружина, крышка багажник
2003733 Газовая пружина, крышка багажник
JOHNS 55 05 95-96 Газовая пружина, крышка багажник
JP GROUP 1281200609 Газовая пружина, крышка багажник
KILEN 444021 Газовая пружина, крышка багажник
LESJÖFORS 8163421 Газовая пружина, крышка багажник
MAGNETI MARELLI 430719089800 Газовая пружина, заднее стекло
430719089900 Газовая пружина, заднее стекло
MALÒ 127162 Газовая пружина, крышка багажник
MONROE ML5834 Газовая пружина, крышка багажник
ML5835 Газовая пружина, крышка багажник
montcada ROP014 Газовая пружина, крышка багажник
OPTIMAL AG-17184 Газовая пружина, крышка багажник
AG-17220 Газовая пружина, крышка багажник
PATRON PGS8339BK Газовая пружина, крышка багажник
PGS8453BV Газовая пружина, крышка багажник
QUINTON HAZELL QTS128295 Газовая пружина, крышка багажник
QTS128331 Газовая пружина, крышка багажник
ROC GS0317 Газовая пружина, крышка багажник
STABILUS 8339BK Газовая пружина, крышка багажник
8985BM Газовая пружина, крышка багажник
STELLOX 11-20814-SX Газовая пружина, крышка багажник
11-20834-SX Газовая пружина, крышка багажник
11-20839-SX Газовая пружина, крышка багажник
TRISCAN 8710 2413 Газовая пружина, крышка багажник
8710 2412 Газовая пружина, крышка багажник
VAICO V40-0731 Газовая пружина, крышка багажник
V40-0733 Газовая пружина, крышка багажник
VEMA 51227 Газовая пружина, крышка багажник
ZEKKERT GF-1060 Газовая пружина, крышка багажник
GF-1059 Газовая пружина, крышка багажник
2026 CATCAR.INFO (v 2.0)