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='20674' AND a.supplierId=47) OR (a.articleSearch='XE7203' AND a.supplierId=4975) OR (a.articleSearch='IC18110' AND a.supplierId=194) OR (a.articleSearch='ZSE215' AND a.supplierId=6444) OR (a.articleSearch='115004' AND a.supplierId=452) OR ( a.articleSearch IN ('CBE5536', 'CBE5536C') AND a.supplierId=4334) OR (a.articleSearch='GN1063512B1' AND a.supplierId=89) OR (a.articleSearch='E100060' AND a.supplierId=186) OR ( a.articleSearch IN ('EE5112', 'QL1032', 'XIG5137') AND a.supplierId=4344) OR ( a.articleSearch IN ('880434', '880434A') AND a.supplierId=234) OR (a.articleSearch='03SKV284' AND a.supplierId=4969) OR ( a.articleSearch IN ('8530536', '8530536A2') AND a.supplierId=441) OR (a.articleSearch='GC4123' AND a.supplierId=4933) OR (a.articleSearch='150928' AND a.supplierId=4819) OR (a.articleSearch='19050080' AND a.supplierId=72) OR ( a.articleSearch IN ('134085', '2504085') AND a.supplierId=449) OR ( a.articleSearch IN ('8010772', '8010772E') AND a.supplierId=341) OR (a.articleSearch='12183' AND a.supplierId=269) OR (a.articleSearch='CP412' AND a.supplierId=6518) OR (a.articleSearch='DMB2095' AND a.supplierId=4501) OR (a.articleSearch='060717173012' AND a.supplierId=4723) OR (a.articleSearch='80757' AND a.supplierId=133) OR (a.articleSearch='130217' AND a.supplierId=403) OR ( a.articleSearch IN ('10772', '10772E') AND a.supplierId=244) OR (a.articleSearch='0880422' AND a.supplierId=94) OR (a.articleSearch='7148850013' AND a.supplierId=144) OR (a.articleSearch='CF88' AND a.supplierId=4705) OR (a.articleSearch='LVCL1252' AND a.supplierId=4564) OR (a.articleSearch='1IC585' AND a.supplierId=388) OR (a.articleSearch='49062' AND a.supplierId=15) OR (a.articleSearch='ECZFR019' AND a.supplierId=6355) OR (a.articleSearch='PCI1320' AND a.supplierId=4558) OR ( a.articleSearch IN ('8530536', '8530536A2') AND a.supplierId=27) OR (a.articleSearch='CL416' AND a.supplierId=356) OR (a.articleSearch='305126' AND a.supplierId=301) OR (a.articleSearch='886016034' AND a.supplierId=108) OR (a.articleSearch='245375' AND a.supplierId=21) OR (a.articleSearch='V25700031' AND a.supplierId=183) OR (a.articleSearch='CUF6125' AND a.supplierId=4627) OR ( a.articleSearch IN ('220830513', '220830700') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1307249', 'WG1496980', 'WG1822622', 'WG1938064', 'WG1965388') AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Ford (пасажирский) -> Ford FOCUS III ->Ford 1.0 EcoBoost, 02.2012- 12.2017, , 125 ->Катушка зажигания / элемент катушки зажигания