#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE0ODJ8fG1kZl9pZD09MF43OTc0fHxzcGFyZV9pZD09MTAwNjcz&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 = "7974" AND ( (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-995-014" AND av.ProductID IN (920)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37968" AND av.ProductID IN (920)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1189802100" AND av.ProductID IN (920)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1188000300" AND av.ProductID IN (3455)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1189800200" AND av.ProductID IN (920)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1188000900" AND av.ProductID IN (3455)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1189800700" AND av.ProductID IN (920)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "27-0090" AND av.ProductID IN (920)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "27-0091" AND av.ProductID IN (920)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 7968" AND av.ProductID IN (920)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "109 519" AND av.ProductID IN (3455)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "102 673" AND av.ProductID IN (920)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "102 921" AND av.ProductID IN (920)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 558" AND av.ProductID IN (3455)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 635" AND av.ProductID IN (920)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.53.017" AND av.ProductID IN (920)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.53.018" AND av.ProductID IN (920)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.53.019" AND av.ProductID IN (920)) ) 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 = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-995-014") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37968") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189802100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1188000300") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189800200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1188000900") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189800700") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "27-0090") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "27-0091") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7968") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 519") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "102 673") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "102 921") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 558") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 635") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.017") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.018") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.019") ) 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 = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-995-014") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37968") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189802100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1188000300") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189800200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1188000900") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1189800700") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "27-0090") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "27-0091") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7968") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 519") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "102 673") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "102 921") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 558") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 635") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.017") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.018") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.53.019") ) AND aa.Language = "ru" Продажа автозапчастей типа Сидения для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BSG BSG 90-995-014 Регулировочный элемент, регулировка сидения
FEBI BILSTEIN 37968 Регулировочный элемент, регулировка сидения
JP GROUP 1189802100 Регулировочный элемент, регулировка сидения
1188000300 Поворотная ручка, регулировка спинки сидения
1189800200 Регулировочный элемент, регулировка сидения
1188000900 Поворотная ручка, регулировка спинки сидения
1189800700 Регулировочный элемент, регулировка сидения
MAXGEAR 27-0090 Регулировочный элемент, регулировка сидения
27-0091 Регулировочный элемент, регулировка сидения
SWAG 30 93 7968 Регулировочный элемент, регулировка сидения
TOPRAN 109 519 Поворотная ручка, регулировка спинки сидения
102 673 Регулировочный элемент, регулировка сидения
102 921 Регулировочный элемент, регулировка сидения
103 558 Поворотная ручка, регулировка спинки сидения
103 635 Регулировочный элемент, регулировка сидения
TRUCKTEC AUTOMOTIVE 07.53.017 Регулировочный элемент, регулировка сидения
07.53.018 Регулировочный элемент, регулировка сидения
07.53.019 Регулировочный элемент, регулировка сидения
2026 CATCAR.INFO (v 2.0)