SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM ( VALUES ('FT95250', 4938), ('FT95250Z', 4938), ('FT95251', 4938), ('FT95251Z', 4938), ('FT95310', 4938), ('FT95296', 4938), ('FT95357', 4938), ('FT95408', 4938), ('FT95409', 4938), ('EZCFT015', 6355), ('EZCFT016', 6355), ('EZCFT013', 6355), ('P350017', 4558), ('P350039', 4558), ('PMG0534M01', 4558), ('PMG0535M01', 4558), ('PMG0535M02', 4558), ('PMG0535M04', 4558), ('81263', 4598), ('0534M01', 4657), ('0534M02', 4657), ('0535M01', 4657), ('0535M02', 4657), ('55946', 6558), ('56461', 6558), ('57220', 6558), ('57221', 6558), ('57222', 6558), ('5402049221921P', 4555), ('5402049252913P', 4555), ('5402049255911P', 4555), ('6003000107P', 4555), ('6003000285P', 4555), ('6004000038P', 4555), ('6004000043P', 4555), ('6802002092451P', 4555), ('SALE6003000107P', 4555), ('769558', 405), ('769559', 405), ('3481025', 253), ('3483018', 253), ('3483019', 253), ('1281003', 355), ('1281004', 355), ('1281018', 355), ('1281019', 355), ('1281028', 355), ('1281165', 355), ('1283030', 355), ('96SKV748', 4969), ('96SKV749', 4969), ('96SKV750', 4969), ('96SKV754', 4969), ('FT88183', 4938), ('FT88184', 4938), ('FT95252', 4938), ('FT95252Z', 4938), ('FT95358', 4938), ('FT95512', 4938), ('174734', 101), ('2092451', 78), ('2092452', 78), ('8223030', 4546), ('350315026970', 4723), ('350315027010', 4723), ('43072', 4664), ('43073', 4664), ('2310059', 94), ('2310060', 94), ('2310061', 94), ('2310114', 94), ('2312028', 94), ('2312115', 94), ('2312156', 94), ('EZCFT017', 6355), ('EZCFT018', 6355), ('11866', 4683), ('11873', 4683), ('11918', 4683), ('P350016', 4558), ('PMG0534M02', 4558), ('TYC3050026', 4652), ('FT9193703', 340), ('FT9193704', 340), ('T443072', 4667), ('T443073', 4667), ('2553501', 6691), ('2553503', 6691), ('2553504', 6691), ('7993501', 6691), ('33102370', 151), ('131885', 4970), ('3050026', 61), ('V241000', 183), ('V241129', 183), ('1747801', 36), ('1747803', 36), ('1747804', 36), ('CI9503703', 340), ('PG9503703', 340), ('CI9503704', 340), ('PG9503704', 340) ) 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 products.products_suppliers ps ON p.id = ps.product_id AND ps.supplier_id IN (223) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat DUCATO Фургон (230_) ->Fiat 2.8 TDI, 10.1997- 04.2002, , 122 ->Крышки/капоты/двери/люк крыши/складная крыша