#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwMTR8fG1kZl9pZD09MF41OTQyNnx8c3BhcmVfaWQ9PTEwMTk5Mw%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 = "59426" AND ( (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501939" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501623" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502496" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502034" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501626" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502482" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501823" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502495" AND av.ProductID IN (3225)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "21829" AND av.ProductID IN (3225)) OR (av.SupplierID = 4449 AND av.DataSupplierArticleNumber = "201530103040" AND av.ProductID IN (3225)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 92 1829" AND av.ProductID IN (3225)) ) 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 = 4881 AND aa.DataSupplierArticleNumber = "501939") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501623") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502496") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502034") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501626") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502482") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501823") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502495") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21829") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201530103040") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 1829") ) 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 = 4881 AND aa.DataSupplierArticleNumber = "501939") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501623") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502496") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502034") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501626") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502482") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501823") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502495") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21829") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201530103040") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 1829") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DYNAMAX 501939 Масло ступенчатой коробки передач
501623 Масло ступенчатой коробки передач
502496 Масло ступенчатой коробки передач
502034 Масло ступенчатой коробки передач
501626 Масло ступенчатой коробки передач
502482 Масло ступенчатой коробки передач
501823 Масло ступенчатой коробки передач
502495 Масло ступенчатой коробки передач
FEBI BILSTEIN 21829 Масло ступенчатой коробки передач
MOBIL 201530103040 Масло ступенчатой коробки передач
SWAG 10 92 1829 Масло ступенчатой коробки передач
2026 CATCAR.INFO (v 2.0)