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 ('A1 0986452061','B1 VAL586017','A2 FI OP595/2','A1 H97W06','B1 VAI24-0018','C9 28-143220005','A3 BOS F026407142','A1 WOF1404','A3 BOS F026407001','A3 JAP FO-593S','A2 J1310303','C9 OF-919','A2 586022','A2 SF OF1020','C9 FO-593S','B1 PURLS301','A2 0986452061','A3 FLT OP595/2','B7 A210982/DKM','C9 F026407160','B1 PURLS489A','B1 KNEOC1183','A2 W7023','B7 10120/JAPKO','B1 PURLS892','A5 432473','A1 F129','C9 6143220000','A1 0986AF1039','B1 FTROP595','B1 MANW6018','B1 MANW67/1','A3 KAP FO-011A','C4 F026407209','A1 LS892PU','B1 MANW7023','B1 KAMF101401','A8 919 462','A2 SF OF0054','B7 1518502709/JP','A8 919 464','B1 FTROP643/6','A3 BOS 0451103364','A2 586013','A1 F026407160','A9 OC1183','C9 W67/1','A5 432472','A9 F026407142','A9 FI OP643/6','A5 174793','E6 FL1224','A5 288024','B1 KAMF117201','C4 N1313035','A9 SF OF0066','C9 F026407210','A1 W67/1','B1 BLPADM52106','C4 S 3616 R','A2 N1313035','A5 37986','A1 W7023','A9 N1313035','B7 10313/JAPKO','C4 W 6025','C9 FO-307S','A2 F026407210','A2 W67/1','C9 50013848','C4 OC 195','A1 10-05-503ASK','A9 J1311026','C4 0986452061','A8 909 602','A3 MNN W67/1','C4 H328W','C4 J1311026','C9 36-143220008','C9 LS301','B7 1218505409/JP','A8 909 802','A8 360 886','A8 907 969','C4 LS892PU','A8 318 352','A9 W6025','C4 NO-2233','A1 F026407210','A1 F026407209','A2 J1317004','A2 SF OF0066','C4 J1317004','B1 BOSF026407209','A9 UFI 23.452.00','D1 BP ADG02109','A2 SF OF0063','C4 S 5120 R','A9 SF OF0054','B1 HENH97W06','A1 LS489APU','E6 FL1183','B7 H328W','A8 300 080','A3 MHL OC195','C4 OC 1566','B7 OP595/AG','E6 FL1015','B7 CY-021/KAVO','D1 BP ADN12112','C9 SP-1465','C9 FE32099','A9 W6018','B1 KAMF104701','C9 71758756','B1 BOSF026407142','E6 FL1009','A1 WOF189','A8 318 852','A9 OC575','A1 OC1052','A9 J1317008','A3 BOS F026407160','A8 365 387','A3 BOS 0986452061','A2 OC1566','C9 LS892','A2 OC1052','B7 OP643/6/AG','A9 UFI 23.484.00','A1 32099 FE','A9 F026407210','C9 DO854/A','B1 VAL586155','A3 MHL OC1566','A8 370 625','C4 H97W06','C4 W 6018','A1 0451103364','A8 376 420','A9 F026407001','A5 242157','A2 UFI 23.452.00','A9 FI OP595','D1 BP ADM52106','A5 174742','B1 PURLS965','A1 10-01-120ASK','C9 0986452061','A8 921 237','C4 W 7023','A2 FI OP643/6','A2 OC1198','A3 JAP FO-120S','C9 ADM52121','A9 F026407209','C9 W6025','C9 OF-1465','C4 F026407210','A9 SF OF1020','C4 OC 575','C4 J1310303','A9 W7023','A9 UFI 23.271.00','B1 KAMF115601','C4 O0544DREIS','A1 OC1183','A3 JAP FO-307S','A2 OC1183','C9 LS965','C4 J1310500','C4 F026407160','B1 MANW6025','A2 FI OP595','A3 BOS F026407210','C9 H97W06','A8 358 666','C9 W7023','A2 J1317008','A9 F026407160','A5 24791','A1 WOF1907','C9 ADN12112','C9 F026407001','A9 SF OF0063','A2 J1310500','B1 KAMF118801','A1 OC575','B1 BOSF026407210','C4 LS489APU','B7 10593/JAPKO','A5 202448','A1 LS965PU','B1 KAMF103301','C9 W6018','C9 SP-1002','A1 F026407142','A5 135057','B7 OP 595/IP','B1 BLPADM52121','B1 CHACOF100129S','A1 LS301PU','C9 OF-1002','B1 FEB32099','B1 FTROP595/2','B1 HENH328W','A2 W6025','B1 BLPADN12112','A8 378 828','C4 W 67/1','A9 OC1566','C9 34-143220002','A9 OC195','C4 COF100129S','A1 W6025','A2 UFI 23.616.00','C9 FO-120S','C4 J1317008','C9 OF-1436','A1 OC195','C9 DO324','C9 71758725','A3 MHL OC1183','A2 OC195','C9 ADM52106','B7 OP 595/2/IP','A2 J1311026','A5 410733','A1 W6018','A9 W67/1','A2 W6018','B7 W67/1/AG','A3 VAC V24-0018','A8 913 453','A9 UFI 23.616.00','A2 F026407160','C9 DO854','B7 H97W06','A3 FLT OP643/6','B1 BOSF026407160','A2 F026407209','A1 OC1198','B1 BLPADG02109','A8 365 336','A5 80960','B7 FO-011A/KAVO','B1 KNEOC195','C9 SP-1436','A9 J1317004','A9 J1310303','A3 FLT OP595','A8 381 698','A8 914 088','C9 35-143220007','B1 VAL586013','C4 F026407001','A5 174794','C9 ADG02109','B1 BOS0986452061','A1 F026407001','C9 LS489A','A1 10-05-593ASK','A3 MHL OC1052','A8 918 284','B7 OP595/2/AG','A1 10-03-313ASK','C9 F026407142','D1 BP ADM52121','A1 OC1566','A2 UFI 23.484.00','B7 A210039/DKM','A9 FI OP595/2','A3 MHL OC575','A5 44094','C4 S 3484 R','A8 312 854','A3 BOS F026407209','C4 F026407142','A2 F026407142','C9 37-143220009','B1 VAL586022','B7 OP 643/6/IP','A9 J1310500','A2 OC575','C9 50013733','A2 F026407001','B1 BOSF026407001','A2 UFI 23.271.00','A1 32100 FE','B1 BLPADM52107','B7 A210159/DKM','B7 NO-2223/KAVO','B7 SM134','C9 ADM52107','C9 FE32100','D1 BP ADM52107','E6 FL1045')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #