#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ3NTR8fG1kZl9pZD09MF4xODcxOXx8c3BhcmVfaWQ9PTEwMDExMw%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 = "18719" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9983150" AND av.ProductID IN (188)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9983405" AND av.ProductID IN (188)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "99962200" AND av.ProductID IN (189)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "R10004" AND av.ProductID IN (188)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37404" AND av.ProductID IN (188)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1352202109" AND av.ProductID IN (188)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1352203209" AND av.ProductID IN (188)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "71792" AND av.ProductID IN (188)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "71792/2" AND av.ProductID IN (189)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "10112200" AND av.ProductID IN (189)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "MC3150" AND av.ProductID IN (188)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "MC3405" AND av.ProductID IN (188)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2240595" AND av.ProductID IN (188)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2241072" AND av.ProductID IN (188)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 639 0006" AND av.ProductID IN (188)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 739 0003" AND av.ProductID IN (188)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 032 0450" AND av.ProductID IN (188)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 032 0483" AND av.ProductID IN (188)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "SP3316" AND av.ProductID IN (188)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "SP3314" AND av.ProductID IN (188)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AF-2801" AND av.ProductID IN (188)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AF-2931" AND av.ProductID IN (188)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QCS6943" AND av.ProductID IN (188)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QCS5437" AND av.ProductID IN (188)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QCS5833" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 641" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "996 611" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "994 077" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 651" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 648" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 645" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 642" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "996 612" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "994 078" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 652" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "993 292" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 649" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 646" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 643" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "996 916" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "996 537" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "994 076" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 650" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 647" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "998 644" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "86836" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "55742" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "85202" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "19399" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "19175" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "19359" AND av.ProductID IN (188)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 93 7404" AND av.ProductID IN (188)) OR (av.SupplierID = 4896 AND av.DataSupplierArticleNumber = "TS5013" AND av.ProductID IN (188)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JCS266" AND av.ProductID IN (188)) ) 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 = 253 AND aa.DataSupplierArticleNumber = "9983150") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9983405") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99962200") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "R10004") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37404") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1352202109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1352203209") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "71792") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "71792/2") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "10112200") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC3150") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC3405") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2240595") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2241072") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 639 0006") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 739 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 032 0450") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 032 0483") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP3316") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP3314") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AF-2801") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AF-2931") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS6943") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS5437") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS5833") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 641") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 611") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 077") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 651") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 648") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 645") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 642") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 612") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 078") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 652") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "993 292") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 649") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 646") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 643") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 916") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 537") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 076") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 650") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 647") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 644") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "86836") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "55742") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "85202") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19399") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19175") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19359") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 7404") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "TS5013") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JCS266") ) 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 = 253 AND aa.DataSupplierArticleNumber = "9983150") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9983405") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99962200") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "R10004") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37404") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1352202109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1352203209") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "71792") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "71792/2") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "10112200") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC3150") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC3405") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2240595") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2241072") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 639 0006") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 739 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 032 0450") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 032 0483") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP3316") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP3314") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AF-2801") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AF-2931") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS6943") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS5437") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QCS5833") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 641") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 611") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 077") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 651") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 648") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 645") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 642") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 612") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 078") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 652") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "993 292") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 649") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 646") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 643") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 916") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "996 537") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 076") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 650") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 647") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "998 644") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "86836") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "55742") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "85202") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19399") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19175") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "19359") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 93 7404") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "TS5013") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JCS266") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS 9983150 Пружина ходовой части
9983405 Пружина ходовой части
99962200 Комплект ходовой части, пружины
EIBACH R10004 Пружина ходовой части
FEBI BILSTEIN 37404 Пружина ходовой части
JP GROUP 1352202109 Пружина ходовой части
1352203209 Пружина ходовой части
MAPCO 71792 Пружина ходовой части
71792/2 Комплект ходовой части, пружины
MAXTRAC 10112200 Комплект ходовой части, пружины
MC3150 Пружина ходовой части
MC3405 Пружина ходовой части
METZGER 2240595 Пружина ходовой части
2241072 Пружина ходовой части
MEYLE 014 639 0006 Пружина ходовой части
014 739 0003 Пружина ходовой части
014 032 0450 Пружина ходовой части
014 032 0483 Пружина ходовой части
MONROE SP3316 Пружина ходовой части
SP3314 Пружина ходовой части
OPTIMAL AF-2801 Пружина ходовой части
AF-2931 Пружина ходовой части
QUINTON HAZELL QCS6943 Пружина ходовой части
QCS5437 Пружина ходовой части
QCS5833 Пружина ходовой части
SACHS 998 641 Пружина ходовой части
996 611 Пружина ходовой части
994 077 Пружина ходовой части
998 651 Пружина ходовой части
998 648 Пружина ходовой части
998 645 Пружина ходовой части
998 642 Пружина ходовой части
996 612 Пружина ходовой части
994 078 Пружина ходовой части
998 652 Пружина ходовой части
993 292 Пружина ходовой части
998 649 Пружина ходовой части
998 646 Пружина ходовой части
998 643 Пружина ходовой части
996 916 Пружина ходовой части
996 537 Пружина ходовой части
994 076 Пружина ходовой части
998 650 Пружина ходовой части
998 647 Пружина ходовой части
998 644 Пружина ходовой части
SPIDAN 86836 Пружина ходовой части
55742 Пружина ходовой части
85202 Пружина ходовой части
SUPLEX 19399 Пружина ходовой части
19175 Пружина ходовой части
19359 Пружина ходовой части
SWAG 10 93 7404 Пружина ходовой части
TORQUE TS5013 Пружина ходовой части
TRW JCS266 Пружина ходовой части
2026 CATCAR.INFO (v 2.0)