SELECT DISTINCT
m.manufacturerName AS cross_brand,
ao.oemSearch,
ao.oemnumber,
ps_sub.id AS id
FROM (
VALUES
('D5144',351), ('32789',101), ('5403150PK',373), ('912024',85), ('06872',4664), ('PK190',4752), ('PSE6314',4558), ('1198116SX',4595), ('60932789',151), ('18921',317), ('33295',317), ('79760',4576), ('79800',4576), ('0011030188',4995), ('062646B',49), ('11267904',16), ('52068',208), ('52273',208), ('BSG75700005',4455), ('750953',405), ('750954',405), ('504176',6263), ('PK3005',6479), ('520143',4512), ('14115',4834), ('14400',4834), ('103714',101), ('SBB0015',6443), ('SBB0067',6443), ('540315',373), ('2019108',185), ('912028',85), ('PR7157',4600), ('PR7158',4600), ('723656',403), ('06873',4664), ('16146400004',144), ('DB44342',6495), ('693908',127), ('DCK510802',378), ('AK735444',129), ('36887',331), ('36932',331), ('50489',331), ('50490',331), ('R51046',4303), ('R51049',4303), ('R53246',4303), ('T406872',4667), ('T406873',4667), ('1127335SX',4595), ('60103714',151), ('700844',301), ('BC1984',4772), ('10665',6311), ('392761',4730), ('VE52068',4425), ('VE52273',4425), ('SM3001S',4894)
) 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;
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
