#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTE5ODh8fG1kZl9pZD09MF4xNTkyMXx8c3BhcmVfaWQ9PTEwMTQyMQ%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 = "15921" AND ( (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "221-1517R-U" AND av.ProductID IN (62)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "221-1514L-A" AND av.ProductID IN (62)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "221-1514R-A" AND av.ProductID IN (62)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "221-1517L-U" AND av.ProductID IN (62)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H691I08A" AND av.ProductID IN (62)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H690I08A" AND av.ProductID IN (62)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H691I08" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN9224014OE" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN9224013" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN9224013OE" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN9224014" AND av.ProductID IN (62)) ) 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 = 4657 AND aa.DataSupplierArticleNumber = "221-1517R-U") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1514L-A") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1514R-A") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1517L-U") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H691I08A") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H690I08A") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H691I08") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224014OE") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224013OE") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224014") ) 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 = 4657 AND aa.DataSupplierArticleNumber = "221-1517R-U") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1514L-A") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1514R-A") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "221-1517L-U") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H691I08A") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H690I08A") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H691I08") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224014OE") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224013OE") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN9224014") ) AND aa.Language = "ru" Продажа автозапчастей типа Фонарь указателя поворота для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
LORO 221-1517R-U Фонарь указателя поворота
221-1514L-A Фонарь указателя поворота
221-1514R-A Фонарь указателя поворота
221-1517L-U Фонарь указателя поворота
NPS H691I08A Фонарь указателя поворота
H690I08A Фонарь указателя поворота
H691I08 Фонарь указателя поворота
PRASCO HN9224014OE Фонарь указателя поворота
HN9224013 Фонарь указателя поворота
HN9224013OE Фонарь указателя поворота
HN9224014 Фонарь указателя поворота
2026 CATCAR.INFO (v 2.0)