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 IN ('06257', '08338', '02065') AND a.supplierId=101) OR ( a.articleSearch IN ('24710', '24749', '24769') AND a.supplierId=4598) OR (a.articleSearch='55127' AND a.supplierId=6558) OR (a.articleSearch='234211' AND a.supplierId=317) OR (a.articleSearch='130065710' AND a.supplierId=323) OR (a.articleSearch='4276C' AND a.supplierId=208) OR ( a.articleSearch IN ('020498085G', '191798116A') AND a.supplierId=6366) OR (a.articleSearch='460888' AND a.supplierId=405) OR (a.articleSearch='2103' AND a.supplierId=4834) OR (a.articleSearch='GRK0022' AND a.supplierId=6443) OR ( a.articleSearch IN ('1131700610', '1144000510') AND a.supplierId=268) OR ( a.articleSearch IN ('1150050', '4320010') AND a.supplierId=4546) OR (a.articleSearch='270196' AND a.supplierId=403) OR (a.articleSearch='03724' AND a.supplierId=4664) OR (a.articleSearch='1004980003C' AND a.supplierId=144) OR (a.articleSearch='30237' AND a.supplierId=331) OR ( a.articleSearch IN ('00298', '00615', '02961') AND a.supplierId=4683) OR (a.articleSearch='P180013' AND a.supplierId=4558) OR (a.articleSearch='T403724' AND a.supplierId=4667) OR ( a.articleSearch IN ('99902065', '99906257', '99908338') AND a.supplierId=151) OR ( a.articleSearch IN ('100087', '102855', '107547') AND a.supplierId=301) OR (a.articleSearch='623551' AND a.supplierId=4970) OR (a.articleSearch='162020' AND a.supplierId=4730) OR (a.articleSearch='191798116A' AND a.supplierId=4999) OR (a.articleSearch='V103298' AND a.supplierId=183) OR (a.articleSearch='15146' AND a.supplierId=4425) OR (a.articleSearch='K70001201' AND a.supplierId=4346) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw GOLF III Van (1H1) ->Vw 1.9 D, 08.1991- 07.1995, , 75 ->Ремонт / обслуживание