#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTMxfHxtZGZfaWQ9PTBeMTE0MHx8c3BhcmVfaWQ9PTEwMjQwNg%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 = "1140" AND ( (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "9895500910" AND av.ProductID IN (3174)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "9895501010" AND av.ProductID IN (3174)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160381" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160352" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090567A1" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170391" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160382" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160361" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090610" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090555" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170392" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170361A1" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160362" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160351" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090560" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170362A1" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154014" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134004" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154113" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134139" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154114" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154013" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134003" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320902" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5812914" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322904" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320903" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322905" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320904" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320901" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322906" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322903" 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 = 268 AND aa.DataSupplierArticleNumber = "9895500910") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "9895501010") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160381") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160352") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090567A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170391") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160382") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160361") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090610") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090555") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170392") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170361A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160362") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160351") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090560") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170362A1") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154014") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134004") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134139") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320902") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5812914") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320903") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322905") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320901") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322906") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322903") ) 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 = 268 AND aa.DataSupplierArticleNumber = "9895500910") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "9895501010") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160381") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160352") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090567A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170391") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160382") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160361") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090610") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090555") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170392") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170361A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160362") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160351") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090560") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170362A1") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154014") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134004") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134139") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320902") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5812914") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320903") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322905") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320901") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322906") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322903") ) AND aa.Language = "ru" Продажа автозапчастей типа Боковой фонарь указателя поворота для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
JP GROUP 9895500910 Комплект проблесковых ламп
9895501010 Комплект проблесковых ламп
KLOKKERHOLM 00160381 Фонарь указателя поворота
00160352 Фонарь указателя поворота
00090567A1 Фонарь указателя поворота
00170391 Фонарь указателя поворота
00160382 Фонарь указателя поворота
00160361 Фонарь указателя поворота
00090610 Фонарь указателя поворота
00090555 Фонарь указателя поворота
00170392 Фонарь указателя поворота
00170361A1 Фонарь указателя поворота
00160362 Фонарь указателя поворота
00160351 Фонарь указателя поворота
00090560 Фонарь указателя поворота
00170362A1 Фонарь указателя поворота
PRASCO AD0154014 Фонарь указателя поворота
AD0134004 Фонарь указателя поворота
AD0154113 Фонарь указателя поворота
AD0134139 Фонарь указателя поворота
AD0154114 Фонарь указателя поворота
AD0154013 Фонарь указателя поворота
AD0134003 Фонарь указателя поворота
VAN WEZEL 0320902 Фонарь указателя поворота
5812914 Фонарь указателя поворота
0322904 Фонарь указателя поворота
0320903 Фонарь указателя поворота
0322905 Фонарь указателя поворота
0320904 Фонарь указателя поворота
0320901 Фонарь указателя поворота
0322906 Фонарь указателя поворота
0322903 Фонарь указателя поворота
2026 CATCAR.INFO (v 2.0)