#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTEzfHxtZGZfaWQ9PTBeMTMzNHx8c3BhcmVfaWQ9PTEwMDU2Ng%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 = "1334" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6102-01-0007P" AND av.ProductID IN (1914)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6102-01-0009P" AND av.ProductID IN (1914)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6102-01-0006P" AND av.ProductID IN (1914)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "13 15 38-1" AND av.ProductID IN (50)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "13 15 37-1" AND av.ProductID IN (50)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1189102370" AND av.ProductID IN (50)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1189102380" AND av.ProductID IN (50)) ) 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 = "6102-01-0007P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6102-01-0009P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6102-01-0006P") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 15 38-1") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 15 37-1") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189102370") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189102380") ) 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 = "6102-01-0007P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6102-01-0009P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6102-01-0006P") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 15 38-1") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 15 37-1") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189102370") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189102380") ) AND aa.Language = "ru" Продажа автозапчастей типа Зеркала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 6102-01-0007P Зеркальное стекло, наружное зеркало
6102-01-0009P Зеркальное стекло, наружное зеркало
6102-01-0006P Зеркальное стекло, наружное зеркало
JOHNS 13 15 38-1 Наружное зеркало
13 15 37-1 Наружное зеркало
JP GROUP 1189102370 Наружное зеркало
1189102380 Наружное зеркало
2026 CATCAR.INFO (v 2.0)