SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('1409100069',144), ('032455',126), ('ESTZSA09043',6372), ('ESTZSA09069',6372), ('10100302',4657), ('10100303',4657), ('127463',317), ('127785',317), ('ZSA09043',257), ('ZSA09069',257), ('A2420',4604), ('2037783',4585), ('2038833',4585), ('29433',101), ('ZS09043',156), ('ZS09069',156), ('ZSJ09043',481), ('ZSJ09069',481), ('13720391',138), ('13729593',138), ('GH0523314',4032), ('GS28399',4032), ('JB300450',4032), ('JB325550',4032), ('871029128',286), ('871029291',286), ('312022',176), ('412038',176), ('8500090',4546), ('8004222',175), ('8104238',175), ('430719080600',4723), ('430719104500',4723), ('91791',133), ('91877',133), ('121823',403), ('122238',403), ('2110458',94), ('ML5740',4752), ('ML5930',4752), ('AEAU033',6355), ('AEAU034',6355), ('AG40193',129), ('AG40195',129), ('AG50238',129), ('AG50281',129), ('26310',4683), ('GS0963',401), ('GS0965',401), ('024409',126), ('30929433',151), ('871029128',108), ('871029291',108), ('V104100',183), ('V104101',183), ('51664',4425), ('300350',6003), ('300353',6003), ('320350',6003), ('320353',6003) ) 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
Главная -> Каталог -> Audi (пасажирский) -> Audi TT Roadster (8J9) ->Audi 2.0 TTS quattro, 05.2008- 06.2014, , 272 ->Упругие элементы