#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTg1fHxtZGZfaWQ9PTBeNzE2OHx8c3BhcmVfaWQ9PTEwMTcxMA%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 = "7168" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6505-04-5049387P" AND av.ProductID IN (1560)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-5049551P" AND av.ProductID IN (755)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6505-04-5049388P" AND av.ProductID IN (1560)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-5049541P" AND av.ProductID IN (1560)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-5049552P" AND av.ProductID IN (755)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6505-04-5049547P" AND av.ProductID IN (1560)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-5049542P" AND av.ProductID IN (1560)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6505-04-5049548P" AND av.ProductID IN (1560)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9316431" AND av.ProductID IN (755)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9316432" AND av.ProductID IN (755)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "5049542" AND av.ProductID IN (755)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "5049551" AND av.ProductID IN (755)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "5049552" AND av.ProductID IN (755)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "5049541" AND av.ProductID IN (755)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "168530136" AND av.ProductID IN (1184)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "168530047" AND av.ProductID IN (1184)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP0090552" AND av.ProductID IN (755)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3730346" AND av.ProductID IN (755)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3730347" AND av.ProductID IN (755)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3730348" AND av.ProductID IN (755)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3730345" AND av.ProductID IN (755)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049387P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049551P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049388P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049541P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049552P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049547P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049542P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049548P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9316431") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9316432") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049542") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049551") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049552") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049541") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "168530136") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "168530047") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0090552") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730346") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730347") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730348") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730345") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049387P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049551P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049388P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049541P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049552P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049547P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-5049542P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6505-04-5049548P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9316431") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9316432") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049542") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049551") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049552") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "5049541") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "168530136") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "168530047") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0090552") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730346") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730347") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730348") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3730345") ) AND aa.Language = "ru" Продажа автозапчастей типа Колесная ниша для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 6505-04-5049387P Обшивка, колесная ниша
6504-03-5049551P Колесная ниша
6505-04-5049388P Обшивка, колесная ниша
6504-03-5049541P Обшивка, колесная ниша
6504-03-5049552P Колесная ниша
6505-04-5049547P Обшивка, колесная ниша
6504-03-5049542P Обшивка, колесная ниша
6505-04-5049548P Обшивка, колесная ниша
DIEDERICHS 9316431 Колесная ниша
9316432 Колесная ниша
KLOKKERHOLM 5049542 Колесная ниша
5049551 Колесная ниша
5049552 Колесная ниша
5049541 Колесная ниша
METZGER 168530136 Крепление рессоры
168530047 Крепление рессоры
PRASCO OP0090552 Колесная ниша
VAN WEZEL 3730346 Колесная ниша
3730347 Колесная ниша
3730348 Колесная ниша
3730345 Колесная ниша
2026 CATCAR.INFO (v 2.0)