Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('A8 315 293','E3 16-14 322 0001','A8 380 014','C9 0451104520','C4 0451103299','A1 W7053','C9 DO930','A5 372328','A1 0451104518','A2 OC99','A8 306 367','A2 J1311023','A5 80310','B1 PURLS880A','C9 16-143220001','B1 MANW7053','A9 UFI 23.293.00','A9 W7053','C4 H90W23','E3 214 322 0002','C9 0451103299','A2 586002','A1 10-01-189ASK','A8 365 948','C4 W 712/8 SD','B1 MANW712/47','B7 SM168','A1 10-08-893ASK','A1 0451103355','A2 UFI 23.191.00','A5 202462','A1 10-06-699ASK','A1 OC99','A9 OC976','A1 W716/1','C9 H90W23','C9 SP-918','A2 UFI 23.401.00','A1 WOF180','A3 BOS 0451103299','A3 MHL OC2','A1 50013386/10','C4 J1311023','A3 BOS F026408900','C9 FO-189S','C9 50013386','A1 W712/47','C9 LS592A','B1 BOS0451103299','A1 0451103391','C9 SP-943','B1 CHACOF100118S','C9 FE32223','C9 DO1801','C9 ADT32116','C9 H20W02','A3 JAP FO-H02S','A1 0451104520','A8 365 872','A5 37628','C4 OC 976','A1 OC100','C9 0451103089','A1 0451103162','A1 OC503','B1 VAL586002','A1 F026408743','A3 JAP FO-189S','A9 0451103238','C9 LS923','C4 LS923PU','B1 PURLS867B','A2 UFI 23.198.00','B1 VAI42-0050','B1 BOSF026407353','A5 80897','B7 H90W23','C9 W716/1','A9 W7058','B7 SM113','A8 365 933','C9 H90W21','D1 BP ADT32116','A1 WOF128','A1 0451103238','A8 315 291','A8 313 812','C9 0451103238','A2 F026407353','B1 HENH90W21','A3 MHL OC100','A8 313 546','C4 H90W13','A8 315 289','B1 VAL586000','A9 OC503','B1 VAI46-0086','B7 H90W21','A1 10-H0-002ASK','C9 FO-H02S','B7 H90W13','A3 MHL OC99','A1 LS592APU','A1 WOF146','B1 FEB31300','A3 MNN W716/1','A1 LS923PU','B1 BOS0451103303','C4 COF100118S','A3 MHL OC976','B7 W7058/AG','A8 926 329','A2 OC100','A3 BOS 0451103261','A1 50013386','A1 0451103254','A2 0451103299','A1 FT0535','C4 W 712/47','A1 31300 FE','A2 UFI 23.293.00','A3 BOS 0451104518','A9 W712/47','A9 UFI 23.191.00','A1 OC 310','A3 MNN W712/47','A9 UFI 23.402.00','A2 F026408900','A1 OC 99','C4 0451103238','A9 0451103299','A9 J1311023','A2 0451103238','C9 71760130','A1 J1311023HB','B1 PURLS923','C4 W 712/8 (10)','C9 50013361','C9 ADL142104','A9 UFI 23.439.00','A8 315 286','A3 BOS F026408743','A3 MNN W712/8','A1 0451103261','A3 BOS 0451104520','C4 31300F','B1 VAL586027','A1 0451103148','A1 0451103308','C9 2143220000','A2 62 93 2223','C4 S 0130 R','A1 32223 FE','C9 W712/47','C9 W712/8','A1 0451104506','B1 BOS0451103261','C9 0451103261','A5 40932','B1 HENH90W23','B1 MISZ401','A8 929 360','A2 W712/47','C9 W7053','A9 UFI 23.198.00','A3 VAC V42-0050','A5 40946','A5 80171','A9 UFI 23.401.00','A1 OC976','A2 62 93 1300','C9 0451103303','A1 W712/8','C9 H90W13','A1 0451103303','C4 S 5030 R','C9 FO-893S','A1 OC99O.F.','A5 202456','A1 0451103299','C4 LS867BPU','A2 OC503','C4 S 3293 R','D1 BP ADL142104','A1 F026408900','A2 0451103261','C4 W 7058','C4 0451103355','A8 365 874','B1 BOS0451103238','A1 OC271','C9 FO-699S','B1 MANW716/1','B1 PURLS592A','A5 40953','C9 W7058','B1 FEB32223','A2 0451103355','C4 OC 100','A1 OC2','A1 LS867BPU','A8 371 109','B1 BOS0451104520','A2 UFI 23.439.00','C9 0451103355','A3 BOS 0451103238','A1 OC310','A2 OC976','B1 MANW7058','A2 586027','A2 UFI 23.402.00','C9 LS880A','B1 VAI42-0125','A2 H90W21','A3 BOS 0451103303','A3 VAC V46-0086','A1 0451103174','A3 JAP FO-699S','B7 W7053/AG','C9 DO884','A2 W7058','A3 VAC V42-0125','A1 W7058','A5 80200','C4 H90W21','C4 W 712/8','A9 0451103261','A2 W7053','C9 71760128','C4 W 7053','B1 MANW712/8','C4 LS592APU','A5 86383','A8 312 839','B1 BLPADL142104','A1 LS880APU','C4 32223F','C9 F026408900','B1 BLPADT32116','B1 BOSF026408900','C9 LS880','A3 BOS 0451103391','A9 0451103355','A3 BOS 0451103355','E3 2 143 220 002','A3 BOS 0451104506','A8 303 186','C9 FE31300','B1 HENH90W13','B7 SM187','C9 DO1837','C9 LS867B','A3 MHL OC503','B1 BOS0451103355','C4 0451103261','C4 W 716/1','C4 O0601DREIS','C4 F026408900','A8 321 237','C4 OC 503','C9 2143220002','A2 O77/90.7','A3 KAP HO-611','D2 OP540/1','A1 0986452041','A2 0986452041','A2 SF OF0003','A3 BOS 0986452041','A5 44074','A8 312 866','A9 0986452041','A9 SF OF0003','B1 BOS0986452041','B1 HP720 803','B1 KAMF100401','B1 KNEOC976','B1 VAL586037','B7 A210008/DKM','C4 0986452041','C9 0986452041','C9 OF-727','C9 OF-888','C9 OF-943','A3 FLT OP540/1')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #