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 ('A3 VAC V25-0200','A1 50013386/10','C9 7143220016','B7 H90W32','B1 VAI46-0086','C9 H20W02','A1 0451103303','A1 0451103254','A2 UFI 23.198.00','B1 MISZ401','A2 W7043','A8 321 237','A3 BOS 0451103391','B7 OP 546/1/IP','A8 318 326','A8 365 933','C4 H90W32','A3 FLT OP546/2','A2 J1311023','A2 FI OP546/2','C9 DO1801','A3 BOS 0451103303','A3 VAC V46-0086','B1 FTROP540/1','B1 BOS0451104520','C4 S 3293 R','A9 FI OP540/1','A5 80310','B1 VAI42-0125','A1 0451103162','B1 VAL586027','B1 PURLS384','B1 PURLS867B','C9 H90W13','C4 W 712/82','A1 50013386','A9 UFI 23.401.00','A1 W716/1','B7 H90W23','C9 16-143220001','A1 LS592APU','A3 MNN W712/47','A3 FLT OP620','B1 BOS0451103355','A9 FI OP540/1T','A3 BOS F026407017','A9 F026407017','A9 0451103299','A3 BOS 0451103355','B7 OP546/2/AG','A1 0451103391','B1 BOS0451103299','B1 HENH90W13','C4 0451103299','A3 JAP FO-H02S','A1 LS867BPU','A5 40932','A5 266308','A5 372328','C9 LS867B','C9 0451103261','B1 FTROP620','A3 BOS 0451104518','A1 0451104520','A8 338 889','A3 BOS 0451104520','C4 S 5030 R','B1 MANW712/47','A3 MNN W712/8','A1 0451103355','A8 365 872','A9 W712/82','B7 H90W13','A9 W7043','E3 16-14 322 0001','C9 LS923','B1 FEB31300','C4 H90W21','A8 370 620','A1 10-H0-002ASK','A2 UFI 23.401.00','B1 HENH90W23','A1 W712/8','C9 H90W21','C9 2143220000','A1 0451103238','A1 J1311023HB','A1 50014116','A9 UFI 23.439.00','C9 W7043','B1 MANW716/1','C9 LS592A','A2 W712/82','C9 0451103089','A8 365 948','A1 10-08-893ASK','A5 86383','B1 MANW712/8','B1 BOSF026407017','B1 MANW7043','A1 F026407017','C9 0451103355','C4 O0601DREIS','A5 40953','B7 OP 540/1T/IP','A1 0451103308','A2 0451103238','B1 HENH90W21','A8 313 812','C9 SP-943','B1 MANW712/82','A2 UFI 23.402.00','B7 OP 546/2/IP','A1 0451103174','A3 FLT OP546/1','C4 W 712/8 (10)','A8 338 208','A3 JAP FO-699S','C9 0451103303','C9 ADT32116','A9 UFI 23.191.00','C4 W 712/8 SD','A2 FI OP620','C9 DO930','A2 UFI 23.191.00','A2 FI OP540/1T','B1 PURLS880A','A2 0451103261','C4 LS867BPU','A3 MNN W712/82','A8 345 329','A8 312 839','C9 FO-H02S','C9 LS880','C9 50013361','A8 306 367','A1 0451104518','B1 VAI25-0200','B7 A210008/DKM','A3 FLT OP540/1','A9 FI OP620','A3 BOS 0451103299','A1 LS880APU','A9 0451103261','C9 FE32223','A1 0451103261','A2 F026407017','A8 359 756','A8 365 874','A2 586002','C9 FE31300','A5 40946','C9 FO-699S','C4 F026407017','C4 W 712/47','B1 FTROP546/1','A8 315 291','B1 BOS0451103238','C4 LS384PU','A1 32223 FE','A1 F026408743','A3 VAC V42-0125','C4 LS923PU','B7 OP546/1/AG','A9 UFI 23.198.00','C9 0451103238','A9 UFI 23.402.00','A5 80897','A1 LS384PU','A8 315 293','A1 0451103299','E3 214 322 0002','A2 586027','A2 W712/47','A1 10-06-699ASK','A1 WOF180','C9 F026407017','B1 BOS0451103261','D1 BP ADT32116','C9 W716/1','C4 LS592APU','C4 31300F','B1 FEB48484','C9 DO1837','C9 DO884','C9 LS384','C4 J1311023','C9 W712/8','B7 A210017/DKM','A3 JAP FO-189S','A1 W712/82','A1 0451104506','B1 BLPADT32116','A5 80200','C9 H90W23','A3 BOS 0451103261','A5 80171','A1 FT0535','A1 10-01-189ASK','A1 W7043','C9 50013386','C4 0451103261','A1 WOF220','A9 FI OP546/1','B1 FEB32223','B1 VAL586080','C9 FO-189S','A8 315 289','A8 313 546','B1 FEB48505','C4 H90W13','B1 FTROP546/2','B1 BOS0451103303','C4 O0582DREIS','A8 371 109','A2 FI OP546/1','B7 A210410/DKM','A8 929 360','A3 BOS 0451103238','A3 MNN W716/1','B7 OP 540/1/IP','C9 SP-918','C4 0451103355','C9 2143220002','C4 H90W23','A1 0451103148','A8 380 014','A2 FI OP540/1','C4 W 716/1','A9 0451103238','B1 PURLS592A','A1 LS923PU','A1 31300 FE','C9 W712/82','B7 H90W21','A2 0451103299','B7 OP540/1/AG','A3 BOS 0451104506','A3 FLT OP540/1T','A2 UFI 23.439.00','B7 OP620/AG','A9 FI OP546/2','E3 2 143 220 002','A9 UFI 23.293.00','C4 W 712/8','A5 272968','B1 VAL586002','C4 W 7043','B1 HENH90W32','C9 FO-893S','B1 FTROP540/1T','B7 OP 620/IP','A9 W712/47','A8 378 605','A9 J1311023','C9 W712/47','C4 S 0130 R','A2 UFI 23.293.00','A2 0451103355','C9 7143220009','B7 A210008-S/DKM','A8 315 286','C4 0451103238','A2 H90W21','B1 VAI42-0050','B1 PURLS923','A8 377 728','C9 LS880A','C4 32223F','A1 W712/47','C9 0451103299','A3 BOS F026408743','A9 0451103355','C9 0451104520','C9 H90W32','A3 VAC V42-0050','B7 OP540/1T/AG','A2 O77/90.7','A3 KAP HO-611','D2 OP540/1','A1 W7015','A1 W7053','A1 W7058','A2 FI OP629/2','A2 SF OF0003','A2 W7015','A2 W7053','A2 W7058','A3 FLT OP629/2','A5 202450','A5 202456','A5 202462','A8 303 186','A8 374 862','A8 378 012','A8 923 915','A8 926 329','A9 SF OF0003','A9 W7015','A9 W7053','A9 W7058','B1 BLPADF122107','B1 BLPADF122112','B1 BLPADL142104','B1 BLPADT32142','B1 FEB108285','B1 FTROP629/2','B1 HP720 803','B1 KAMF100401','B1 MANW7015','B1 MANW7053','B1 MANW7058','B1 VAL586000','B7 OP629/2/AG','B7 W7015/AG','B7 W7053/AG','C4 O0550DREIS','C4 W 7015','C4 W 7053','C4 W 7058','C9 ADT32142','C9 FE108285','C9 OF-888','C9 W7015','C9 W7053','C9 W7058','D1 BP ADF122112','D1 BP ADL142104')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #