#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ5MDN8fG1kZl9pZD09MF4yNDYzNnx8c3BhcmVfaWQ9PTEwMDU2Ng%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 = "24636" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "6832225" AND av.ProductID IN (50)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "6832024" AND av.ProductID IN (50)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "6832025" AND av.ProductID IN (50)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "6832224" AND av.ProductID IN (50)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H770I19" AND av.ProductID IN (50)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H771I19" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0187314" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0187103" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0187104" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0167203" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0187313" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "HN0167204" AND av.ProductID IN (50)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "8224803" AND av.ProductID IN (50)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "8224804" 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 = 253 AND aa.DataSupplierArticleNumber = "6832225") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832024") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832025") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832224") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H770I19") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H771I19") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187314") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187103") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187104") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0167203") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187313") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0167204") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "8224803") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "8224804") ) 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 = 253 AND aa.DataSupplierArticleNumber = "6832225") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832024") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832025") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "6832224") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H770I19") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H771I19") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187314") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187103") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187104") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0167203") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0187313") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "HN0167204") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "8224803") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "8224804") ) AND aa.Language = "ru" Продажа автозапчастей типа Зеркала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS 6832225 Наружное зеркало
6832024 Наружное зеркало
6832025 Наружное зеркало
6832224 Наружное зеркало
NPS H770I19 Наружное зеркало
H771I19 Наружное зеркало
PRASCO HN0187314 Наружное зеркало
HN0187103 Наружное зеркало
HN0187104 Наружное зеркало
HN0167203 Наружное зеркало
HN0187313 Наружное зеркало
HN0167204 Наружное зеркало
VAN WEZEL 8224803 Наружное зеркало
8224804 Наружное зеркало
2026 CATCAR.INFO (v 2.0)