SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('TH449583',215), ('TH449586',215), ('TH449589',215), ('78226',4005), ('TH01489',6665), ('352317101130',4723), ('QTH114K',57), ('9000392',260), ('52908',6558), ('TER131',317), ('TER213',317), ('TER256',317), ('751783N',80), ('XT449583',4975), ('XT449586',4975), ('XT449589',4975), ('32677',4576), ('PTH1060',4337), ('PTH1061',4337), ('PTH2507',4337), ('PTH4586',4337), ('PTH8376',4337), ('300183',128), ('300242',128), ('300334',128), ('CT5045',478), ('CT5429K',478), ('CT5439K',478), ('CT5508',478), ('CT5527',478), ('CT5546',478), ('CT5572',478), ('BBT007',475), ('BBT138',475), ('BBT143',475), ('302983',6444), ('302986',6444), ('302989',6444), ('756903',405), ('756904',405), ('756905',405), ('CTH2458',4334), ('DT1165V',42), ('DT1221V',42), ('TRM077N',4882), ('TRM094N',4882), ('1218025',355), ('161054',211), ('161055',211), ('1880226',4005), ('1880246',4005), ('1880247',4005), ('350111',234), ('350111A',234), ('350126',234), ('78246',4005), ('78247',4005), ('5202883',240), ('5202887',240), ('09328',101), ('09336',101), ('FTK007',407), ('FTK138',407), ('FTK143',407), ('TH01483',6665), ('8MT354773891',4734), ('8MT354774021',4734), ('8MT354774031',4734), ('75007',269), ('75022',269), ('75035',269), ('75214',269), ('75628',269), ('TH0230002',296), ('15449583Z',387), ('15449589Z',387), ('580226',4006), ('580246',4006), ('580247',4006), ('352034582000',4723), ('352034586000',4723), ('352034588000',4723), ('352317001080',4723), ('352317001130',4723), ('352317101080',4723), ('TX17486',287), ('TX9882',287), ('TX9889',287), ('28100',133), ('6001544059PCSMS',358), ('670016',403), ('EPS1880226',4773), ('EPS1880246',4773), ('EPS1880247',4773), ('30303',4664), ('30304',4664), ('30305',4664), ('4006224',94), ('0282890000',144), ('VTS119',4564), ('VTS126',4564), ('VTS265',4564), ('23788',388), ('34582K',388), ('34586K',388), ('34588K',388), ('VT24782',320), ('VT24787',320), ('VT24789',320), ('2457765',4380), ('03227',4683), ('12620',4683), ('21635',4683), ('QTH144',57), ('QTH205',57), ('QTH486',57), ('9000314',260), ('9000322',260), ('T430303',4667), ('T430304',4667), ('T430305',4667), ('2340113SX',4595), ('2340157SX',4595), ('2340198SX',4595), ('2340265SX',4595), ('199031',6691), ('199035',6691), ('60909328',151), ('60909336',151), ('862013082',108), ('862013088',108), ('862013091',108), ('86201582',108), ('86201588',108), ('86201591',108), ('86203188',108), ('86203191',108), ('819922',21), ('819923',21), ('819924',21), ('D3724782',4836), ('D3724787',4836), ('V46991357',183), ('V46991359',183), ('WG1091501',4832), ('WG1091502',4832), ('WG1091503',4832), ('WG1218023',4832), ('WG1218024',4832), ('WG1426535',4832), ('WG1430713',4832), ('WG1430715',4832), ('WG1492835',4832), ('WG2113201',4832), ('WG2113238',4832), ('TX17486',382), ('TX9889',382), ('CT5555K',478), ('CT5534',478), ('819919',21), ('819917',21), ('819920',21), ('TH449386',215), ('TH432489',215), ('TH449389',215) ) AS search_list(search_art, search_sup) INNER JOIN article a ON a.articleSearch = search_list.search_art AND a.supplierId = search_list.search_sup LEFT JOIN article_oem ao ON ao.articleNumber = a.articleNumber AND ao.supplierId = a.supplierId LEFT JOIN manufacturer m ON m.manufacturerId = ao.manufacturerId LEFT JOIN products.brands b ON b.title = m.manufacturerName LEFT JOIN products.products p ON p.article = ao.oemSearch AND p.brand_id = b.id LEFT JOIN LATERAL ( SELECT ps_sub.id FROM products.products_suppliers ps_sub WHERE ps_sub.product_id = p.id AND ps_sub.supplier_id IN (223) ) ps_sub ON true; Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Renault (пасажирский) -> Renault SUPER 5 (B/C40_) ->Renault 1.4 Turbo (C405), 04.1985- 08.1990, , 120 ->Термостат / прокладка

VERNET

TH129088J

Термостат HYUNDAI ACCENT (12кл) / GETZ (1.3) / KIA SPORTAGE (NB7 Diesel)

О производителе
Информация о товаре К каким автомобилям подходит
800.00 ₽

В наличии 1 шт.

Купить

HYUNDAI/KIA/MOBIS

2550022600

Термостат HYUNDAI ACCENT (12кл) / GETZ (1.3) / KIA SPORTAGE (NB7 Diesel)

О производителе
Информация о товаре К каким автомобилям подходит
1 700.00 ₽

В наличии 1 шт.

Купить