#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTM0NTJ8fG1kZl9pZD09MF4xMjYyMHx8c3BhcmVfaWQ9PTEwMDM1Mg%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 = "12620" AND ( (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "885082" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A04264" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "67361" AND av.ProductID IN (1390)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ALP2361" AND av.ProductID IN (1390)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "216167" AND av.ProductID IN (1529)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "216177" AND av.ProductID IN (1529)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "216188" AND av.ProductID IN (1529)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "215866" AND av.ProductID IN (1529)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "11SKV036" AND av.ProductID IN (1390)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "11649" AND av.ProductID IN (1390)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "DB0258" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI10660" AND av.ProductID IN (1390)) OR (av.SupplierID = 342 AND av.DataSupplierArticleNumber = "216188" AND av.ProductID IN (1529)) OR (av.SupplierID = 342 AND av.DataSupplierArticleNumber = "215866" AND av.ProductID IN (1529)) OR (av.SupplierID = 342 AND av.DataSupplierArticleNumber = "216167" AND av.ProductID IN (1529)) OR (av.SupplierID = 342 AND av.DataSupplierArticleNumber = "216177" AND av.ProductID IN (1529)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GA759.01" AND av.ProductID IN (1390)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "421245" AND av.ProductID IN (1108)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "588017" AND av.ProductID IN (1390)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "588015" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1792925" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1792923" AND av.ProductID IN (1390)) ) 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 = 4528 AND aa.DataSupplierArticleNumber = "885082") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A04264") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "67361") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ALP2361") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216167") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216177") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216188") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "215866") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "11SKV036") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "11649") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "DB0258") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI10660") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216188") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "215866") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216167") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216177") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA759.01") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "421245") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588017") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588015") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1792925") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1792923") ) 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 = 4528 AND aa.DataSupplierArticleNumber = "885082") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A04264") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "67361") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ALP2361") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216167") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216177") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "216188") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "215866") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "11SKV036") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "11649") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "DB0258") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI10660") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216188") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "215866") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216167") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "216177") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA759.01") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "421245") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588017") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588015") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1792925") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1792923") ) AND aa.Language = "ru" Продажа автозапчастей типа Составляющие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AD KÜHNER 885082 Механизм свободного хода генератора
AUTOTEAM A04264 Механизм свободного хода генератора
CALIBER 67361 Механизм свободного хода генератора
DAYCO ALP2361 Механизм свободного хода генератора
ERA 216167 Выпрямитель, генератор
216177 Выпрямитель, генератор
216188 Выпрямитель, генератор
215866 Выпрямитель, генератор
ESEN SKV 11SKV036 Механизм свободного хода генератора
FARE SA 11649 Механизм свободного хода генератора
HUTCHINSON DB0258 Механизм свободного хода генератора
KM International FI10660 Механизм свободного хода генератора
MESSMER 216188 Выпрямитель, генератор
215866 Выпрямитель, генератор
216167 Выпрямитель, генератор
216177 Выпрямитель, генератор
SNR GA759.01 Механизм свободного хода генератора
TRICLO 421245 Ременный шкив, генератор
VALEO 588017 Механизм свободного хода генератора
588015 Механизм свободного хода генератора
WILMINK GROUP WG1792925 Механизм свободного хода генератора
WG1792923 Механизм свободного хода генератора
2026 CATCAR.INFO (v 2.0)