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