#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE2MzB8fG1kZl9pZD09MF4xMDY4Nnx8c3BhcmVfaWQ9PTEwMDE4MQ%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 = "10686" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-9557592P" AND av.ProductID IN (901)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6504-03-9557591P" AND av.ProductID IN (901)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1180650570" AND av.ProductID IN (901)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1180650580" AND av.ProductID IN (901)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1180450770" AND av.ProductID IN (901)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1180450780" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557002" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557602" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557595" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557562" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557531" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557596" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557593" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557532" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557001" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557601" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557594" AND av.ProductID IN (901)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "9557561" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870147" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870144" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870141" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870148" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870145" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870142" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870133" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870146" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870143" AND av.ProductID IN (901)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5870134" AND av.ProductID IN (901)) ) 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 = "6504-03-9557592P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-9557591P") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180650570") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180650580") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180450770") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180450780") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557002") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557602") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557595") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557562") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557531") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557596") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557593") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557532") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557001") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557601") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557594") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557561") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870147") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870144") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870141") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870148") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870145") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870142") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870133") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870146") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870143") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870134") ) 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 = "6504-03-9557592P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6504-03-9557591P") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180650570") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180650580") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180450770") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1180450780") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557002") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557602") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557595") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557562") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557531") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557596") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557593") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557532") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557001") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557601") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557594") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "9557561") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870147") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870144") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870141") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870148") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870145") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870142") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870133") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870146") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870143") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5870134") ) AND aa.Language = "ru" Продажа автозапчастей типа Боковина для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 6504-03-9557592P Боковина
6504-03-9557591P Боковина
JP GROUP 1180650570 Боковина
1180650580 Боковина
1180450770 Боковина
1180450780 Боковина
KLOKKERHOLM 9557002 Боковина
9557602 Боковина
9557595 Боковина
9557562 Боковина
9557531 Боковина
9557596 Боковина
9557593 Боковина
9557532 Боковина
9557001 Боковина
9557601 Боковина
9557594 Боковина
9557561 Боковина
VAN WEZEL 5870147 Боковина
5870144 Боковина
5870141 Боковина
5870148 Боковина
5870145 Боковина
5870142 Боковина
5870133 Боковина
5870146 Боковина
5870143 Боковина
5870134 Боковина
2026 CATCAR.INFO (v 2.0)