#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTUwMDR8fG1kZl9pZD09MF4xNzM2M3x8c3BhcmVfaWQ9PTEwMDEzNQ%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 = "17363" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "88708" AND av.ProductID IN (794)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "88109" AND av.ProductID IN (794)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-850-001" AND av.ProductID IN (794)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-850-002" AND av.ProductID IN (794)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "954616" AND av.ProductID IN (794)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "954623" AND av.ProductID IN (794)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "954603" AND av.ProductID IN (794)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "465038" AND av.ProductID IN (794)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "15SKV015" AND av.ProductID IN (794)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "15SKV005" AND av.ProductID IN (794)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "9719" AND av.ProductID IN (794)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "9721" AND av.ProductID IN (794)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26259" AND av.ProductID IN (794)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09088" AND av.ProductID IN (794)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09089" AND av.ProductID IN (794)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "5.5123" AND av.ProductID IN (794)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "5.5125" AND av.ProductID IN (794)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "5.5003" AND av.ProductID IN (794)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8TW 006 848-021" AND av.ProductID IN (794)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "65451044" AND av.ProductID IN (794)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "65451038" AND av.ProductID IN (794)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7500123" AND av.ProductID IN (794)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7500125" AND av.ProductID IN (794)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1198501100" AND av.ProductID IN (794)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1398500400" AND av.ProductID IN (794)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1198500500" AND av.ProductID IN (794)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1198500600" AND av.ProductID IN (794)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "90807" AND av.ProductID IN (794)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "90808" AND av.ProductID IN (794)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "45-0015" AND av.ProductID IN (794)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "45-0026" AND av.ProductID IN (794)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "20123" AND av.ProductID IN (794)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "20125" AND av.ProductID IN (794)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "02059" AND av.ProductID IN (794)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "02062" AND av.ProductID IN (794)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220008" AND av.ProductID IN (794)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 955 0006" AND av.ProductID IN (794)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "00875" AND av.ProductID IN (794)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P19-0009" AND av.ProductID IN (794)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "102463" AND av.ProductID IN (794)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "118004" AND av.ProductID IN (794)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "5.5123" AND av.ProductID IN (794)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "5.5125" AND av.ProductID IN (794)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "5.5003" AND av.ProductID IN (794)) OR (av.SupplierID = 4582 AND av.DataSupplierArticleNumber = "SP-028" AND av.ProductID IN (794)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T402059" AND av.ProductID IN (794)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T402062" AND av.ProductID IN (794)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 9088" AND av.ProductID IN (794)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 92 6259" AND av.ProductID IN (794)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 90 9089" AND av.ProductID IN (794)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 819" AND av.ProductID IN (794)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 818" AND av.ProductID IN (794)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "190365" AND av.ProductID IN (794)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "190373" AND av.ProductID IN (794)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TSP025" AND av.ProductID IN (794)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8870 10108" AND av.ProductID IN (794)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.61.009" AND av.ProductID IN (794)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.61.022" AND av.ProductID IN (794)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.61.003" AND av.ProductID IN (794)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "246-082-008-025Z" AND av.ProductID IN (794)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "246-083-002-022Z" AND av.ProductID IN (794)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-08-0203" AND av.ProductID IN (794)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "88708") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "88109") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-850-001") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-850-002") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954616") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954623") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954603") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "465038") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "15SKV015") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "15SKV005") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9719") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9721") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26259") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09088") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09089") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5123") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5125") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5003") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8TW 006 848-021") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "65451044") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "65451038") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500123") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500125") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198501100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1398500400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500600") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90807") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90808") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0015") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0026") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20123") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20125") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02059") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02062") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220008") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 955 0006") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "00875") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P19-0009") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "102463") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "118004") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5123") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5125") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5003") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "SP-028") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402059") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402062") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 9088") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 6259") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 90 9089") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 819") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 818") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190365") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190373") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TSP025") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8870 10108") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.61.009") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.61.022") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.61.003") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-082-008-025Z") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-083-002-022Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-08-0203") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "88708") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "88109") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-850-001") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-850-002") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954616") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954623") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954603") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "465038") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "15SKV015") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "15SKV005") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9719") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9721") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26259") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09088") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09089") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5123") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5125") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5003") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8TW 006 848-021") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "65451044") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "65451038") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500123") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500125") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198501100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1398500400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500600") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90807") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90808") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0015") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0026") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20123") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20125") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02059") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02062") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220008") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 955 0006") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "00875") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P19-0009") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "102463") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "118004") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5123") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5125") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5003") OR (aa.SupplierID = 4582 AND aa.DataSupplierArticleNumber = "SP-028") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402059") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402062") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 9088") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 6259") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 90 9089") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 819") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 818") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190365") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190373") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TSP025") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8870 10108") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.61.009") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.61.022") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.61.003") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-082-008-025Z") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-083-002-022Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-08-0203") ) AND aa.Language = "ru" Продажа автозапчастей типа Водяной насос омывателя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 88708 Водяной насос, система очистки окон
88109 Водяной насос, система очистки окон
BSG BSG 90-850-001 Водяной насос, система очистки окон
BSG 90-850-002 Водяной насос, система очистки окон
CAUTEX 954616 Водяной насос, система очистки окон
954623 Водяной насос, система очистки окон
954603 Водяной насос, система очистки окон
ERA 465038 Водяной насос, система очистки окон
ESEN SKV 15SKV015 Водяной насос, система очистки окон
15SKV005 Водяной насос, система очистки окон
FARE SA 9719 Водяной насос, система очистки окон
9721 Водяной насос, система очистки окон
FEBI BILSTEIN 26259 Водяной насос, система очистки окон
09088 Водяной насос, система очистки окон
09089 Водяной насос, система очистки окон
FISPA 5.5123 Водяной насос, система очистки окон
5.5125 Водяной насос, система очистки окон
5.5003 Водяной насос, система очистки окон
HELLA 8TW 006 848-021 Водяной насос, система очистки окон
HERTH+BUSS ELPARTS 65451044 Водяной насос, система очистки окон
65451038 Водяной насос, система очистки окон
HOFFER 7500123 Водяной насос, система очистки окон
7500125 Водяной насос, система очистки окон
JP GROUP 1198501100 Водяной насос, система очистки окон
1398500400 Водяной насос, система очистки окон
1198500500 Водяной насос, система очистки окон
1198500600 Водяной насос, система очистки окон
MAPCO 90807 Водяной насос, система очистки окон
90808 Водяной насос, система очистки окон
MAXGEAR 45-0015 Водяной насос, система очистки окон
45-0026 Водяной насос, система очистки окон
MEAT & DORIA 20123 Водяной насос, система очистки окон
20125 Водяной насос, система очистки окон
Metalcaucho 02059 Водяной насос, система очистки окон
02062 Водяной насос, система очистки окон
METZGER 2220008 Водяной насос, система очистки окон
MEYLE 100 955 0006 Водяной насос, система очистки окон
OSSCA 00875 Водяной насос, система очистки окон
PATRON P19-0009 Водяной насос, система очистки окон
SEIM 102463 Водяной насос, система очистки окон
118004 Водяной насос, система очистки окон
SIDAT 5.5123 Водяной насос, система очистки окон
5.5125 Водяной насос, система очистки окон
5.5003 Водяной насос, система очистки окон
SPJ SP-028 Водяной насос, система очистки окон
STC T402059 Водяной насос, система очистки окон
T402062 Водяной насос, система очистки окон
SWAG 99 90 9088 Водяной насос, система очистки окон
10 92 6259 Водяной насос, система очистки окон
30 90 9089 Водяной насос, система очистки окон
TOPRAN 107 819 Водяной насос, система очистки окон
107 818 Водяной насос, система очистки окон
TRICLO 190365 Водяной насос, система очистки окон
190373 Водяной насос, система очистки окон
TRICO TSP025 Водяной насос, система очистки окон
TRISCAN 8870 10108 Водяной насос, система очистки окон
TRUCKTEC AUTOMOTIVE 07.61.009 Водяной насос, система очистки окон
07.61.022 Водяной насос, система очистки окон
02.61.003 Водяной насос, система очистки окон
VDO 246-082-008-025Z Водяной насос, система очистки окон
246-083-002-022Z Водяной насос, система очистки окон
VEMO V10-08-0203 Водяной насос, система очистки окон
2026 CATCAR.INFO (v 2.0)