#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTk2ODV8fG1kZl9pZD09MF4xMDA1MTJ8fHNwYXJlX2lkPT0xMDAzOTc%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 = "100512" AND ( (av.SupplierID = 277 AND av.DataSupplierArticleNumber = "647251K" AND av.ProductID IN (567)) OR (av.SupplierID = 277 AND av.DataSupplierArticleNumber = "647251" AND av.ProductID IN (566)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "CS2300" AND av.ProductID IN (566)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "026.740" AND av.ProductID IN (757)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8444212" AND av.ProductID IN (757)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "C369" AND av.ProductID IN (566)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77668-01" AND av.ProductID IN (757)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5258" AND av.ProductID IN (757)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "302 251" AND av.ProductID IN (757)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35552-00" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1483810" AND av.ProductID IN (566)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086670" AND av.ProductID IN (757)) ) 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 = 277 AND aa.DataSupplierArticleNumber = "647251K") OR (aa.SupplierID = 277 AND aa.DataSupplierArticleNumber = "647251") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CS2300") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "026.740") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8444212") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "C369") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77668-01") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5258") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "302 251") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35552-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1483810") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086670") ) 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 = 277 AND aa.DataSupplierArticleNumber = "647251K") OR (aa.SupplierID = 277 AND aa.DataSupplierArticleNumber = "647251") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CS2300") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "026.740") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8444212") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "C369") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77668-01") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5258") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "302 251") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35552-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1483810") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086670") ) AND aa.Language = "ru" Продажа автозапчастей типа Распредвал для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AMC 647251K Комплект распредвала
647251 Распредвал
BGA CS2300 Распредвал
ELRING 026.740 Уплотняющее кольцо, распределительный вал
ELWIS ROYAL 8444212 Уплотняющее кольцо, распределительный вал
FAI AutoParts C369 Распредвал
GLASER P77668-01 Уплотняющее кольцо, распределительный вал
PAYEN NA5258 Уплотняющее кольцо, распределительный вал
TOPRAN 302 251 Уплотняющее кольцо, распределительный вал
VICTOR REINZ 81-35552-00 Уплотняющее кольцо, распределительный вал
WILMINK GROUP WG1483810 Распредвал
WG1086670 Уплотняющее кольцо, распределительный вал
2026 CATCAR.INFO (v 2.0)