SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/ 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) WHERE ( a.articleSearch IN ('TSP0585029') AND a.supplierId=89) OR ( a.articleSearch IN ('AVE95000S', 'AVE94000P') AND a.supplierId=287) OR ( a.articleSearch IN ('38342', '38367', '38369', '38370', '38373') AND a.supplierId=205) OR ( a.articleSearch IN ('120004', '121018', '121035', '121041', '121042', '121043', '121044', '121046') AND a.supplierId=4654) OR ( a.articleSearch IN ('840118N', '840125N', '840210N', '840220N', '840520N', '840034N', '840041N') AND a.supplierId=80) OR ( a.articleSearch IN ('20215019', '20215046', '20215047', '20215099', '20215099CP') AND a.supplierId=4656) OR ( a.articleSearch IN ('160063910') AND a.supplierId=323) OR ( a.articleSearch IN ('CN1220', 'RT1333', 'RT1335', 'RT1336', 'VN1076', 'CN1221', 'VW1076') AND a.supplierId=247) OR ( a.articleSearch IN ('0026001923') AND a.supplierId=4995) OR ( a.articleSearch IN ('1212016', '1212027', '1212072', '1212073', '1212074', '1212075', '1212081', '1212133') AND a.supplierId=4553) OR ( a.articleSearch IN ('DVE02006', 'DVE23003', 'DVE23007', 'DVE23008', 'DVE32002', 'DVE32004', 'DVE32005') AND a.supplierId=4760) OR ( a.articleSearch IN ('DCE1022', 'DCE1075', 'DCE1077', 'DCE1078', 'DCE1091') AND a.supplierId=253) OR ( a.articleSearch IN ('673046') AND a.supplierId=355) OR ( a.articleSearch IN ('42006', '42033', '42034', '42067', '42076') AND a.supplierId=441) OR ( a.articleSearch IN ('43130113', '43130980', '43130986', '43130115', '43130116', '43130124', '43130987', '43130990', '43130991', '43130992', '43130993', '43130994') AND a.supplierId=313) OR ( a.articleSearch IN ('260516', '260557', '260929') AND a.supplierId=4819) OR ( a.articleSearch IN ('8UW351239221', '8UW351239241', '8UW351239244') AND a.supplierId=4734) OR ( a.articleSearch IN ('K42006', 'K42033', 'K42034', 'K42076') AND a.supplierId=341) OR ( a.articleSearch IN ('1128000500') AND a.supplierId=268) OR ( a.articleSearch IN ('42006', '42033', '42034', '42067', '42076') AND a.supplierId=4399) OR ( a.articleSearch IN ('VAL001', 'VAL003', 'VAL013', 'VAL014') AND a.supplierId=292) OR ( a.articleSearch IN ('AC133645') AND a.supplierId=403) OR ( a.articleSearch IN ('K42006', 'K42033', 'K42034', 'K42076') AND a.supplierId=244) OR ( a.articleSearch IN ('06544') AND a.supplierId=4683) OR ( a.articleSearch IN ('7110449', '7110507', '7110679', '7110686') AND a.supplierId=4543) OR ( a.articleSearch IN ('CN1220', 'RT1333', 'RT1335', 'RT1336', 'VN1076', 'CN1221', 'VW1076') AND a.supplierId=340) OR ( a.articleSearch IN ('42006', '42033', '42034', '42067', '42076') AND a.supplierId=27) OR ( a.articleSearch IN ('10313') AND a.supplierId=6691) OR ( a.articleSearch IN ('KTT140003', 'KTT140047') AND a.supplierId=4466) OR ( a.articleSearch IN ('108924') AND a.supplierId=301) OR ( a.articleSearch IN ('6N0820679C') AND a.supplierId=4999) OR ( a.articleSearch IN ('508639', '508641', '508644', '508646', '508648', '508652', '508866') AND a.supplierId=21) OR ( a.articleSearch IN ('09001220', '43001333', '43001335', '43001336', '58001076') AND a.supplierId=36) OR ( a.articleSearch IN ('V15770004', 'V46770001', 'V46770005') AND a.supplierId=183) OR ( a.articleSearch IN ('058018', '8881100052', '8881100056', '8881100057', '8881100095') AND a.supplierId=97) OR ( a.articleSearch IN ('K42006', 'K42033', 'K42034', 'K42076') AND a.supplierId=4275) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Audi (пасажирский) -> Audi TT (8N3) ->Audi 1.8 T quattro, 03.2005- 06.2006, , 245 ->Клапаны