SELECT DISTINCT
m.manufacturerName AS cross_brand,
ao.manufacturerId,
ao.oemSearch,
ao.oemnumber,
ps.id AS supplier_product_id,
ps.supplier_id AS real_supplier_id
FROM article a
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 ps.product_id = p.id
AND ps.supplier_id IN (224,226,223,225,227)
WHERE (a.articleSearch='107342' AND a.supplierId=101) OR ( a.articleSearch IN ('EG959HD508', 'EG218HD320') AND a.supplierId=81) OR (a.articleSearch='H6003Z' AND a.supplierId=4) OR ( a.articleSearch IN ('54457', '58358', '58376SET', '70316SET') AND a.supplierId=6558) OR (a.articleSearch='TR084' AND a.supplierId=180) OR (a.articleSearch='FTA060' AND a.supplierId=257) OR ( a.articleSearch IN ('FMVW00121', 'FMVW00122') AND a.supplierId=4972) OR (a.articleSearch='210047010' AND a.supplierId=323) OR (a.articleSearch='TA1319K' AND a.supplierId=4280) OR (a.articleSearch='0011018057' AND a.supplierId=4995) OR (a.articleSearch='ADV182164' AND a.supplierId=350) OR (a.articleSearch='A220026' AND a.supplierId=186) OR (a.articleSearch='AC01003' AND a.supplierId=4396) OR (a.articleSearch='DIP124N' AND a.supplierId=4882) OR (a.articleSearch='DP1110140001' AND a.supplierId=4948) OR (a.articleSearch='843510' AND a.supplierId=10) OR ( a.articleSearch IN ('56083AS', '56089AS') AND a.supplierId=441) OR (a.articleSearch='SHB70223' AND a.supplierId=6309) OR ( a.articleSearch IN ('21024', '21091') AND a.supplierId=341) OR (a.articleSearch='FT060' AND a.supplierId=156) OR (a.articleSearch='FTJ060' AND a.supplierId=481) OR (a.articleSearch='1131900800' AND a.supplierId=268) OR ( a.articleSearch IN ('JT471', 'JT625') AND a.supplierId=4378) OR (a.articleSearch='F601401' AND a.supplierId=185) OR ( a.articleSearch IN ('HX132D', 'HX139D') AND a.supplierId=287) OR (a.articleSearch='LT1095' AND a.supplierId=4600) OR (a.articleSearch='69003' AND a.supplierId=133) OR (a.articleSearch='MFT9014' AND a.supplierId=6270) OR (a.articleSearch='MTF3VW19' AND a.supplierId=4773) OR ( a.articleSearch IN ('21024', '21091') AND a.supplierId=244) OR ( a.articleSearch IN ('8020005', '8028030') AND a.supplierId=94) OR (a.articleSearch='21697' AND a.supplierId=4683) OR ( a.articleSearch IN ('PF5030', 'PF5093') AND a.supplierId=4558) OR ( a.articleSearch IN ('P120013', 'P120103') AND a.supplierId=6339) OR (a.articleSearch='416F0003' AND a.supplierId=6358) OR (a.articleSearch='SG1080' AND a.supplierId=225) OR ( a.articleSearch IN ('56083AS', '56089AS') AND a.supplierId=27) OR (a.articleSearch='2050744SX' AND a.supplierId=4595) OR (a.articleSearch='30107342' AND a.supplierId=151) OR ( a.articleSearch IN ('1051060012', '1051061012', '1051062012') AND a.supplierId=4342) OR (a.articleSearch='AT111' AND a.supplierId=4011) OR ( a.articleSearch IN ('117123', '628111') AND a.supplierId=301) OR ( a.articleSearch IN ('V100440', 'V1004401', 'V103025', 'V103025XXL', 'V104722', 'V1047221', 'V104991', 'V104991XXL') AND a.supplierId=183) OR (a.articleSearch='13050755401' AND a.supplierId=4346) OR ( a.articleSearch IN ('21024', '21091') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1429239', 'WG1804936', 'WG1804937', 'WG1938585', 'WG2099275') AND a.supplierId=4832) OR (a.articleSearch='OF4430G' AND a.supplierId=4894) OR ( a.articleSearch IN ('5961303275', '5961306996') AND a.supplierId=68)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
