#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTE4OTF8fG1kZl9pZD09MF4xNTY2Mnx8c3BhcmVfaWQ9PTEwMTc3Nw%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 = "15662" AND ( (av.SupplierID = 4576 AND av.DataSupplierArticleNumber = "56363" AND av.ProductID IN (514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100040910" AND av.ProductID IN (514,514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100016110" AND av.ProductID IN (514,514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100040610" AND av.ProductID IN (514,514)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B14187" AND av.ProductID IN (514)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "GS10249" AND av.ProductID IN (514)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9102400" AND av.ProductID IN (514)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1010260003" AND av.ProductID IN (514)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1010260020" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2002993" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2000233" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27693" AND av.ProductID IN (514)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "A908019" AND av.ProductID IN (514)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "13 18 03-91" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "312014" AND av.ProductID IN (514)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00142800" AND av.ProductID IN (514)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "8500047" AND av.ProductID IN (514)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8004214" AND av.ProductID IN (514)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8004212" AND av.ProductID IN (514)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "101-00-006" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719026500" AND av.ProductID IN (514)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127266" AND av.ProductID IN (514)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "20968" AND av.ProductID IN (514)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "12-0039" AND av.ProductID IN (514)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "140 161 0062" AND av.ProductID IN (514)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5678" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RAU022" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RVW021" AND av.ProductID IN (514)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17089" AND av.ProductID IN (514)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS9968GI" AND av.ProductID IN (514)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8945NP" AND av.ProductID IN (514)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128347" AND av.ProductID IN (514)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0673" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "9968GI" AND av.ProductID IN (514)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-10232-SX" AND av.ProductID IN (514)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-40159-SX" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 7693" AND av.ProductID IN (514)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 054" AND av.ProductID IN (514)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 29107" AND av.ProductID IN (514)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1947" AND av.ProductID IN (514)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1064" AND av.ProductID IN (514)) ) 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 = 4576 AND aa.DataSupplierArticleNumber = "56363") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040910") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100016110") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040610") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B14187") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "GS10249") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9102400") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260003") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260020") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002993") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2000233") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27693") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "A908019") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 18 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "312014") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00142800") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "8500047") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004214") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004212") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-006") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719026500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127266") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "20968") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "12-0039") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "140 161 0062") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5678") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RAU022") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RVW021") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17089") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS9968GI") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8945NP") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128347") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0673") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "9968GI") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-10232-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-40159-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7693") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 054") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 29107") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1947") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1064") ) 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 = 4576 AND aa.DataSupplierArticleNumber = "56363") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040910") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100016110") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040610") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B14187") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "GS10249") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9102400") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260003") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260020") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002993") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2000233") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27693") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "A908019") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 18 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "312014") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00142800") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "8500047") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004214") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004212") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-006") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719026500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127266") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "20968") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "12-0039") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "140 161 0062") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5678") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RAU022") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RVW021") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17089") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS9968GI") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8945NP") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128347") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0673") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "9968GI") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-10232-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-40159-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7693") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 054") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 29107") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1947") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1064") ) AND aa.Language = "ru" Продажа автозапчастей типа Газовые пружины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASAM 56363 Газовая пружина, капот
AUTOMEGA 100040910 Газовая пружина, капот
100016110 Газовая пружина, капот
100040610 Газовая пружина, капот
Borsehung B14187 Газовая пружина, капот
DELPHI GS10249 Газовая пружина, капот
DIEDERICHS 9102400 Газовая пружина, капот
DODA 1010260003 Газовая пружина, капот
1010260020 Газовая пружина, капот
DOGA 2002993 Газовая пружина, капот
2000233 Газовая пружина, капот
FEBI BILSTEIN 27693 Газовая пружина, капот
FENOX A908019 Газовая пружина, капот
JOHNS 13 18 03-91 Газовая пружина, капот
KILEN 312014 Газовая пружина, капот
KLOKKERHOLM 00142800 Газовая пружина, капот
KRAFT AUTOMOTIVE 8500047 Газовая пружина, капот
LESJÖFORS 8004214 Газовая пружина, капот
8004212 Газовая пружина, капот
LORO 101-00-006 Газовая пружина, капот
MAGNETI MARELLI 430719026500 Газовая пружина, капот
MALÒ 127266 Газовая пружина, капот
MAPCO 20968 Газовая пружина, капот
MAXGEAR 12-0039 Газовая пружина, капот
MEYLE 140 161 0062 Газовая пружина, капот
MONROE ML5678 Газовая пружина, капот
montcada RAU022 Газовая пружина, капот
RVW021 Газовая пружина, капот
OPTIMAL AG-17089 Газовая пружина, капот
PATRON PGS9968GI Газовая пружина, капот
PGS8945NP Газовая пружина, капот
QUINTON HAZELL QTS128347 Газовая пружина, капот
ROC GS0673 Газовая пружина, капот
STABILUS 9968GI Газовая пружина, капот
STELLOX 11-10232-SX Газовая пружина, капот
11-40159-SX Газовая пружина, капот
SWAG 30 92 7693 Газовая пружина, капот
TOPRAN 112 054 Газовая пружина, капот
TRISCAN 8710 29107 Газовая пружина, капот
VAICO V10-1947 Газовая пружина, капот
ZEKKERT GF-1064 Газовая пружина, капот
2026 CATCAR.INFO (v 2.0)