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 ('E6 FL1224','C9 H13W03','A8 312 854','C9 DO854','C9 LS965','A9 F026407001','A8 370 625','A2 F026407210','B1 BLPADM52106','C9 FO-705S','A2 0986452061','A5 30162','C4 OC 1566','A2 0451103275','A5 410733','A9 UFI 23.424.00','A8 358 666','C9 0451103275','C9 ADH22113','A1 0451103275','A3 BOS 0986452061','C9 DO836','B1 HENH97W06','A3 JAP FO-703S','C9 ADM52106','A2 OC1566','B1 BLPADG02109','D1 BP ADM52105','A8 300 080','A1 J1310500HB','C9 28-143220005','A9 UFI 23.258.00','C9 35-143220006','A5 30187','B1 BLPADM52121','A1 10-03-313ASK','C9 FO-313S','A8 358 654','A9 UFI 23.271.00','A1 0986452061','A8 919 224','B1 VAI32-0017','A1 J1317005HB','A3 JAP FO-300S','D1 BP ADM52121','A8 365 902','B1 BOSF026407001','A3 BOS 0451103275','C4 S 5120 R','A3 JAP FO-593S','C9 34-143220002','C4 0986452061','C9 FO-300S','B1 MANW67/1','A1 J1317004HB','D1 BP ADH22113','A1 10-07-703ASK','C9 37-143220009','C9 H97W06','B7 H97W06','C9 0986452061','A1 LS892PU','C9 FO-120S','A9 OC1566','C4 F026407209','A3 BOS F026407210','A2 586022','B1 PURLS301','C9 ADG02109','C4 S 3484 R','B7 W67/1/AG','A1 J1313016HB','A3 JAP FO-018S','C9 LS301','A1 10-03-307ASK','B1 PURLS965','A2 UFI 23.424.00','A8 360 886','A5 37986','A3 VAC V32-0017','A3 JAP FO-313S','A1 F026407210','A5 242157','C4 S 3424 R','E6 FL1015','C4 0451103275','A8 318 352','B7 H13W03','B1 BOSF026407127','C4 W 67/1','C9 LS892','A2 UFI 23.258.00','A8 919 462','A1 0451104068','A8 365 943','B1 VAL586022','E6 FL1062','A8 365 901','A2 F026407001','A1 J1314012HB','A9 F026407209','A5 174794','A9 UFI 23.452.00','A2 UFI 23.484.00','A3 JAP FO-705S','A9 UFI 23.272.00','C9 SP-1002','C9 34-143220001','B1 BOSF026407209','B1 PURLS892','B1 BOS0451103275','C9 35-143220005','C4 O0544DREIS','B1 BLPADH22113','A1 OC1566','C9 FO-593S','C4 F026407001','A1 WOF189','A5 202448','C9 FO-018S','A8 365 336','A5 135057','C9 F026407001','A3 JAP FO-301S','C9 ADN12112','C4 H97W06','B1 BLPADM52105','C9 FO-703S','A9 UFI 23.484.00','B7 OP595/AG','C9 SP-1079','A1 LS301PU','A1 10-03-315ASK','A1 W67/1','A1 LS965PU','C9 DO949','C9 36-143220008','A3 MHL OC1566','C9 FO-315S','A5 44094','B7 OP 595/IP','A1 32099 FE','A1 10-05-593ASK','A9 UFI 23.259.00','A1 J1311018HB','A3 BOS F026407001','C9 ADM52121','A3 BOS F026407209','A2 UFI 23.259.00','D1 BP ADN12112','A3 JAP FO-120S','A3 BOS 0451104509','D1 BP ADM52106','A5 80960','A1 10-07-705ASK','C9 50013851','A3 BOS 0451104068','A2 UFI 23.452.00','C9 35-143220000','A1 F026407001','B1 BLPADN12112','C4 LS892PU','A9 F026407210','C9 F026407210','B1 FEB32099','A8 907 969','A1 F026407209','D1 BP ADG02109','A5 288024','A1 10-01-120ASK','A3 FLT OP595','C9 LS871A','A9 W67/1','C9 FE32099','A3 JAP FO-315S','A8 921 237','C4 S 3258 R','B7 SM166','B1 BOSF026407210','A9 FI OP595','A2 FI OP595','B1 BOS0986452061','A8 919 464','A8 920 549','A3 MNN W67/1','C4 F026407210','A1 H97W06','A2 F026407209','C9 W67/1','A1 0986AF1039','A1 0451104509','B7 SM134','A2 UFI 23.271.00','E6 FL1183','E6 FL1009','A2 UFI 23.272.00','A9 0451103275','A2 W67/1','C9 ADM52105','C9 SP-1001','C9 SP-1006','B1 FTROP595','B9 B11020UN','D3 B11020','D3 B11020UN','A1 32100 FE','A1 OC195','A2 OC195','A2 SF OF0066','A3 MHL OC195','A5 24791','A9 OC195','A9 SF OF0066','B1 BLPADM52107','B1 KAMF104001','B1 KNEOC195','B7 A210159/DKM','B7 NO-2223/KAVO','C4 NO-2233','C4 OC 195','C9 ADM52107','C9 FE32100','D1 BP ADM52107','E6 FL1045','A2 J1311018','A2 J1317004','C4 J1311026','D2 OP595')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #