#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1OHx8bW9kZWxfaWQ9PTEyMDh8fG1kZl9pZD09MF4xNTQ3MXx8c3BhcmVfaWQ9PTEwMTY5OA%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 = "15471" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6185544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6164544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6187544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6165544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6127544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6188544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6184544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6128544" AND av.ProductID IN (50)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "6106218" AND av.ProductID IN (3861)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5402-04-1128522" AND av.ProductID IN (50)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5402-04-1112525P" AND av.ProductID IN (50)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5402-04-1191214P" AND av.ProductID IN (849)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5402-04-1115522P" AND av.ProductID IN (50)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5402-04-1127522" AND av.ProductID IN (50)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ADM171" AND av.ProductID IN (50)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ADP156" AND av.ProductID IN (50)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ADP157" AND av.ProductID IN (50)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ADM170" AND av.ProductID IN (50)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "27 05 37-2" AND av.ProductID IN (50)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "27 05 38-1" AND av.ProductID IN (50)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "27 05 38-2" AND av.ProductID IN (50)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "27 05 37-1" AND av.ProductID IN (50)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "16081031" AND av.ProductID IN (50)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "16081032" AND av.ProductID IN (50)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "2705M02" AND av.ProductID IN (50)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "2705M03" AND av.ProductID IN (50)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "2705M04" AND av.ProductID IN (50)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "2705M01" AND av.ProductID IN (50)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PMG2705M03" AND av.ProductID IN (50)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PMG2705M04" AND av.ProductID IN (50)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PMG2705M01" AND av.ProductID IN (50)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PMG2705M02" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "DS0057314" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "DS0057113" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "DS0057114" AND av.ProductID IN (50)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "DS0057313" AND av.ProductID IN (50)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "71132" AND av.ProductID IN (3861)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "52112" AND av.ProductID IN (50)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "52109" AND av.ProductID IN (50)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "52110" AND av.ProductID IN (50)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "52111" AND av.ProductID IN (50)) OR (av.SupplierID = 4582 AND av.DataSupplierArticleNumber = "E-0650" AND av.ProductID IN (50)) OR (av.SupplierID = 4582 AND av.DataSupplierArticleNumber = "E-0651" AND av.ProductID IN (50)) OR (av.SupplierID = 4582 AND av.DataSupplierArticleNumber = "E-0652" AND av.ProductID IN (50)) OR (av.SupplierID = 4582 AND av.DataSupplierArticleNumber = "E-0649" AND av.ProductID IN (50)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "324-0004" AND av.ProductID IN (50)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "324-0001" AND av.ProductID IN (50)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "324-0002" AND av.ProductID IN (50)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "324-0003" AND av.ProductID IN (50)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3305803" AND av.ProductID IN (50)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3305804" 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 = 362 AND aa.DataSupplierArticleNumber = "6185544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6164544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6187544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6165544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6127544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6188544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6184544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6128544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6106218") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1128522") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1112525P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1191214P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1115522P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1127522") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADM171") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADP156") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADP157") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADM170") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 37-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 38-1") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 38-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 37-1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "16081031") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "16081032") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M02") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M03") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M04") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M01") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M03") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M04") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M01") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M02") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057314") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057313") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "71132") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52112") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52109") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52110") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52111") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0650") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0651") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0652") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0649") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0004") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0001") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0002") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3305803") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3305804") ) 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 = 362 AND aa.DataSupplierArticleNumber = "6185544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6164544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6187544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6165544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6127544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6188544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6184544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6128544") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "6106218") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1128522") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1112525P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1191214P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1115522P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5402-04-1127522") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADM171") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADP156") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADP157") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ADM170") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 37-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 38-1") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 38-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "27 05 37-1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "16081031") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "16081032") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M02") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M03") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M04") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "2705M01") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M03") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M04") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M01") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PMG2705M02") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057314") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "DS0057313") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "71132") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52112") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52109") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52110") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "52111") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0650") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0651") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0652") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "E-0649") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0004") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0001") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0002") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "324-0003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3305803") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3305804") ) AND aa.Language = "ru" Продажа автозапчастей типа Зеркала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 6185544 Наружное зеркало
6164544 Наружное зеркало
6187544 Наружное зеркало
6165544 Наружное зеркало
6127544 Наружное зеркало
6188544 Наружное зеркало
6184544 Наружное зеркало
6128544 Наружное зеркало
6106218 Внутреннее зеркало
BLIC 5402-04-1128522 Наружное зеркало
5402-04-1112525P Наружное зеркало
5402-04-1191214P Внутреннее зеркало
5402-04-1115522P Наружное зеркало
5402-04-1127522 Наружное зеркало
ELTA AUTOMOTIVE ADM171 Наружное зеркало
ADP156 Наружное зеркало
ADP157 Наружное зеркало
ADM170 Наружное зеркало
JOHNS 27 05 37-2 Наружное зеркало
27 05 38-1 Наружное зеркало
27 05 38-2 Наружное зеркало
27 05 37-1 Наружное зеркало
KLOKKERHOLM 16081031 Наружное зеркало
16081032 Наружное зеркало
LORO 2705M02 Наружное зеркало
2705M03 Наружное зеркало
2705M04 Наружное зеркало
2705M01 Наружное зеркало
PATRON PMG2705M03 Наружное зеркало
PMG2705M04 Наружное зеркало
PMG2705M01 Наружное зеркало
PMG2705M02 Наружное зеркало
PRASCO DS0057314 Наружное зеркало
DS0057113 Наружное зеркало
DS0057114 Наружное зеркало
DS0057313 Наружное зеркало
SPILU 71132 Внутреннее зеркало
52112 Наружное зеркало
52109 Наружное зеркало
52110 Наружное зеркало
52111 Наружное зеркало
SPJ E-0650 Наружное зеркало
E-0651 Наружное зеркало
E-0652 Наружное зеркало
E-0649 Наружное зеркало
TYC 324-0004 Наружное зеркало
324-0001 Наружное зеркало
324-0002 Наружное зеркало
324-0003 Наружное зеркало
VAN WEZEL 3305803 Наружное зеркало
3305804 Наружное зеркало
2026 CATCAR.INFO (v 2.0)