#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTE1Nzh8fG1kZl9pZD09MF45MDExfHxzcGFyZV9pZD09MTAwNTY3&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 = "9011" AND ( (av.SupplierID = 483 AND av.DataSupplierArticleNumber = "1748" AND av.ProductID IN (5025)) OR (av.SupplierID = 483 AND av.DataSupplierArticleNumber = "2570" AND av.ProductID IN (5025)) OR (av.SupplierID = 483 AND av.DataSupplierArticleNumber = "5113" AND av.ProductID IN (5025)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462807" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462801" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8403138" AND av.ProductID IN (1191)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462843" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462802" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8403146" AND av.ProductID IN (1191)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8400878" AND av.ProductID IN (1191)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462844" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8462806" AND av.ProductID IN (1194)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8431155" AND av.ProductID IN (1192)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8403112" AND av.ProductID IN (1191)) ) 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 = 483 AND aa.DataSupplierArticleNumber = "1748") OR (aa.SupplierID = 483 AND aa.DataSupplierArticleNumber = "2570") OR (aa.SupplierID = 483 AND aa.DataSupplierArticleNumber = "5113") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462807") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462801") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403138") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462843") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462802") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8400878") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462844") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462806") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8431155") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403112") ) 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 = 483 AND aa.DataSupplierArticleNumber = "1748") OR (aa.SupplierID = 483 AND aa.DataSupplierArticleNumber = "2570") OR (aa.SupplierID = 483 AND aa.DataSupplierArticleNumber = "5113") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462807") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462801") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403138") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462843") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462802") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8400878") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462844") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8462806") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8431155") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8403112") ) AND aa.Language = "ru" Продажа автозапчастей типа Оконные стекла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ClimAir 1748 Аэродефлектор
2570 Аэродефлектор
5113 Аэродефлектор
DIEDERICHS 8462807 Боковое окно
8462801 Боковое окно
8403138 Ветровое стекло
8462843 Боковое окно
8462802 Боковое окно
8403146 Ветровое стекло
8400878 Ветровое стекло
8462844 Боковое окно
8462806 Боковое окно
8431155 Заднее стекло
8403112 Ветровое стекло
2026 CATCAR.INFO (v 2.0)