#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTgwMzN8fG1kZl9pZD09MF4xMTg5MHx8c3BhcmVfaWQ9PTEwMDM5OA%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 = "11890" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955212" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955216" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955213" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955214" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955211" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955215" AND av.ProductID IN (561)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "RA0900" AND av.ProductID IN (432)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "R973S" AND av.ProductID IN (432)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "31268" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0225 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0222 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0226 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0223 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0224 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0221 10" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4210" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4207" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4211" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4208" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4209" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4206" AND av.ProductID IN (561)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50006129" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235012" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235008" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235009" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235006" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235010" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235007" AND av.ProductID IN (561)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 93 1268" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428003" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250959" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1490846" AND av.ProductID IN (432,561,561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250956" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250960" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250957" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250961" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250958" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1017523" AND av.ProductID IN (561)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "955212") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955216") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955213") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955214") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955211") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955215") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RA0900") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "R973S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31268") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0225 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0222 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0226 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0223 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0224 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0221 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4210") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4207") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4211") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4208") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4209") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4206") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006129") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235012") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235008") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235009") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235006") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235007") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 93 1268") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250959") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1490846") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250956") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250957") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250958") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017523") ) 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 = 300 AND aa.DataSupplierArticleNumber = "955212") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955216") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955213") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955214") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955211") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955215") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RA0900") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "R973S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31268") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0225 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0222 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0226 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0223 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0224 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0221 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4210") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4207") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4211") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4208") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4209") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4206") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006129") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235012") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235008") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235009") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235006") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235007") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 93 1268") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250959") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1490846") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250956") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250957") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250958") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017523") ) AND aa.Language = "ru" Продажа автозапчастей типа Коромысло / балансир для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 955212 Балансир, управление двигателем
955216 Балансир, управление двигателем
955213 Балансир, управление двигателем
955214 Балансир, управление двигателем
955211 Балансир, управление двигателем
955215 Балансир, управление двигателем
BGA RA0900 Коромысло, управление двигателем
FAI AutoParts R973S Коромысло, управление двигателем
FEBI BILSTEIN 31268 Балансир, управление двигателем
INA 422 0225 10 Балансир, управление двигателем
422 0222 10 Балансир, управление двигателем
422 0226 10 Балансир, управление двигателем
422 0223 10 Балансир, управление двигателем
422 0224 10 Балансир, управление двигателем
422 0221 10 Балансир, управление двигателем
IPD 45-4210 Балансир, управление двигателем
45-4207 Балансир, управление двигателем
45-4211 Балансир, управление двигателем
45-4208 Балансир, управление двигателем
45-4209 Балансир, управление двигателем
45-4206 Балансир, управление двигателем
KOLBENSCHMIDT 50006129 Балансир, управление двигателем
RUVILLE 235012 Балансир, управление двигателем
235008 Балансир, управление двигателем
235009 Балансир, управление двигателем
235006 Балансир, управление двигателем
235010 Балансир, управление двигателем
235007 Балансир, управление двигателем
SWAG 20 93 1268 Балансир, управление двигателем
WILMINK GROUP WG1428003 Балансир, управление двигателем
WG1250959 Балансир, управление двигателем
WG1490846 Балансир, управление двигателем
WG1250956 Балансир, управление двигателем
WG1250960 Балансир, управление двигателем
WG1250957 Балансир, управление двигателем
WG1250961 Балансир, управление двигателем
WG1250958 Балансир, управление двигателем
WG1017523 Балансир, управление двигателем
2026 CATCAR.INFO (v 2.0)