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 ('A2 F026407210','C4 J1317004','C9 0451103275','A9 J1311026','A8 350 614','A9 FI OP595/1','A8 370 625','A9 H97W05','B1 HENH328W','A5 44094','A2 J1311026','C9 ADM52106','C4 S 5120 R','D1 BP ADM52106','B7 NO-2223/KAVO','A3 MHL OC195','C9 H97W05','A9 UFI 23.258.00','A8 358 666','A2 UFI 23.260.00','A9 OC195','C9 H97W06','C9 H97W09','A8 370 628','B7 FO-011A/KAVO','A8 300 080','A9 J1313002','B1 PURLS301','B7 SM134','B1 BLPADM52106','A8 365 902','B1 MANW7023','A2 FI OP575/1','A3 MNN W67/1','B1 FEB32099','E6 FL1183','A2 J1310303','C9 ADM52121','C4 0451103275','B1 FTROP595','A3 FLT OP595/1','B1 PURLS892','B7 H20W05','A1 W7023','C4 H328W','B1 FTROP595/1','A3 KAP FO-011A','C4 H97W09','A1 H97W05','A2 J1317004','A3 BOS 0986452061','A3 KAP NO-2223','A8 365 387','C4 S 3424 R','A5 162212','A1 F116','A2 UFI 23.424.00','A2 H97W05','E6 FL1015','B1 MANW67/1','B1 BOS0451103275','A5 24791','C4 LS489APU','A8 318 852','A1 LS489APU','C4 H13W01','A1 J1317004HB','B7 H13W01','C9 FE32099','C4 J1313002','C9 LS489A','B1 BLPADG02109','A2 W7023','B1 FTROP575/1','A1 LS350PU','A1 OC195','A9 F026407210','B1 KAMF104001','B7 OP575/1/AG','B7 OP 575/1/IP','D1 BP ADG02109','C9 SP-1079','A2 N1313035','B7 OP 595/IP','C9 W7023','A5 80960','C4 N1313035','E6 FL1224','C4 LS350PU','B1 HENH97W05','B7 OP595/AG','B1 HENH97W06','C9 H97W08','A1 OC259','A2 UFI 23.616.00','B7 H328W','A8 365 943','C9 W67/1','A9 UFI 23.259.00','A1 WOF189','C4 F026407210','A2 H97W09','C9 0986452061','A9 0451103275','A2 J1313002','C9 LS301','A9 J1310500','A1 32099 FE','A8 919 464','B1 PURLS350','C4 J1311026','B7 SM104','A8 373 438','A1 0986452061','A2 FI OP595','A9 J1317008','C4 H97W06','A2 W67/1','B1 HENH97W09','A8 365 903','A9 UFI 23.424.00','C4 0986452061','A9 N1313035','A2 FI OP595/1','A1 LS892PU','A5 432473','B1 PURLS489A','C4 J1310500','C9 DO949','C9 F026407210','A9 FI OP575/1','B7 H97W09','C4 S 3258 R','B1 HENH13W01','B7 H97W06','B7 H97W08','A9 UFI 23.452.00','B7 10313/JAPKO','C4 S 3261 R','A9 UFI 23.243.00','B1 HENH97W08','A9 UFI 23.616.00','B1 BOSF026407210','A8 318 352','B1 BLPADM52121','A5 496739','A8 370 382','A9 W67/1','C9 DO853/A','A8 312 854','A1 W67/1','C4 S 6901 R','A2 UFI 23.452.00','C4 W 67/1','C9 SP-1002','C4 H97W05','C4 LS892PU','D1 BP ADM52121','A9 J1313016','C4 J1317008','A2 J1310500','A3 FLT OP595','A2 UFI 23.258.00','C4 J1313016','A9 FI OP595','A8 365 888','A2 0451103275','C9 DO324','C4 J1310303','A2 UFI 23.259.00','C4 W 7023','A1 0451103275','A3 BOS 0451103275','A2 0986452061','C9 LS871A','A8 370 624','C9 ADG02109','C9 DO854/A','A2 J1313016','A5 202448','A1 10-03-313ASK','A3 BOS F026407210','B7 W67/1/AG','B1 BOS0986452061','A2 OC195','C9 H13W01','A9 J1310303','B1 KNEOC195','A9 J1317004','A5 174793','C4 O0544DREIS','B7 OP 595/1/IP','B7 OP595/1/AG','C9 LS350','A9 UFI 23.260.00','C4 OC 195','A1 F129','A1 H97W06','C9 LS892','B7 H97W05','A9 W7023','A1 LS301PU','A3 FLT OP575/1','B7 SM166','A8 356 138','A2 J1317008','A8 914 088','A1 F026407210','A8 381 698','A2 UFI 23.243.00','A8 365 901','C9 DO854','A5 174794','A3 JAP FO-313S','A1 32100 FE','A2 SF OF0066','A8 360 886','A9 SF OF0066','B1 BLPADM52107','B1 BLPADN12112','B1 CHACOF100129S','B1 KAMF118801','B1 VAL586022','B7 A210159/DKM','C9 34-143220002','C9 35-143220007','C9 ADM52107','C9 ADN12112','C9 FE32100','C9 SP-1436','D1 BP ADM52107','D1 BP ADN12112','E6 FL1045')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #