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 FL1015','C9 FO-120S','A9 UFI 23.484.00','A3 BOS 0451103275','B1 FTROP595','A1 10-03-313ASK','A1 LS489APU','A3 JAP FO-593S','A1 10-07-703ASK','C9 FO-593S','A9 UFI 23.452.00','A5 174793','B1 BOSF026407210','A8 365 902','B1 PURLS489A','A9 W67/1','C9 LS892','C4 S 3424 R','C4 H97W06','A5 44094','D1 BP ADM52121','B7 H97W06','B1 BLPADM52106','A9 F026407001','A2 F026407209','A1 0451103275','A2 UFI 23.259.00','A8 921 237','C9 LS871A','B7 OP595/AG','A5 410733','E6 FL1009','A8 365 901','D1 BP ADN12112','C4 F026407001','C4 S 3484 R','A8 360 886','C9 DO854','A2 UFI 23.272.00','C9 FO-705S','C9 0451103275','B1 KNEOC195','A8 919 224','B1 BLPADH22113','A3 BOS 0986452061','A9 FI OP595','C9 SP-1006','A1 WOF189','A5 174794','B1 BOSF026407001','C9 F026407210','A1 F026407001','A3 BOS 0451103292','A1 LS892PU','B1 KNEOC285','A3 BOS F026407210','A2 UFI 23.484.00','A2 0451103275','C9 0986452061','B1 BOS0986452061','D1 BP ADM52106','C9 ADM52121','B1 PURLS965','A9 0451103275','A5 242157','A3 BOS F026407001','C9 50013851','B1 HENH97W06','B1 BOSF026407209','C9 F026407001','A3 FLT OP595','A8 312 856','A3 VAC V32-0017','C4 0986452061','A1 WOF279','A5 30187','C9 SP-1079','A1 LS965PU','C9 DO949','A8 365 336','C9 DO836','B1 KNEOC1566','B1 BOS0451103292','A8 365 943','C4 LS489APU','A8 300 080','C4 W 67/1','A1 10-01-120ASK','A3 BOS F026407209','C9 LS965','C4 S 5120 R','B1 VAI32-0017','A9 F026407209','A1 W811/85','A3 JAP FO-705S','C9 W67/1','A1 J1314012HB','C9 0451103292','A2 UFI 23.452.00','B1 BOS0451103275','C9 LS489A','A1 H97W06','A8 358 666','C9 LS301','A1 0986452061','E6 FL1183','A5 202448','B1 MANW67/1','A2 F026407001','A1 F026407209','A9 UFI 23.424.00','A8 312 854','A5 80960','A1 J1317004HB','A2 UFI 23.424.00','B1 KNEOC575','B1 PURLS301','B1 VAL586022','B1 BLPADN12112','A1 10-07-705ASK','A1 W67/1','A3 JAP FO-120S','A8 907 969','C9 ADM52106','A2 UFI 23.258.00','A5 372458','A9 UFI 23.258.00','C9 H97W06','A1 LS301PU','B1 BLPADM52121','A8 370 625','A5 40942','C4 LS892PU','A8 318 852','A1 J1310500HB','A5 37986','A8 318 352','A5 135057','D1 BP ADG02109','A1 0451104068','A9 UFI 23.259.00','A2 0451103292','B1 BLPADG02109','C9 ADG02109','A9 UFI 23.272.00','C9 ADH22113','A2 0986452061','A3 MNN W67/1','C4 0451103292','B7 W67/1/AG','B7 OP 595/IP','D1 BP ADH22113','A3 BOS 0451104509','C9 SP-1005','A2 586022','C4 O0544DREIS','A2 W67/1','C9 W811/85','A1 F026407210','A3 BOS 0451104068','A2 F026407210','A1 0451103292','C4 0451103275','A9 0451103292','A1 10-03-315ASK','C4 F026407210','C9 ADN12112','E6 FL1224','A1 0451104509','C4 S 3258 R','A1 J1311018HB','A9 F026407210','C9 SP-1002','B7 SM166','A2 FI OP595','A8 919 464','C4 F026407209','B1 PURLS892','A2 J1311018','C4 J1317004','A2 J1311026','A3 JAP FO-313S','D3 B13013','B9 B11020UN','D3 B13013K','C4 J1311026','D3 B13013UN','D3 JAK J1317004','A1 32100 FE','A1 OC195','A2 OC195','A2 SF OF0066','A3 JAP FO-316S','A3 JAP FO-599S','A3 MHL OC195','A5 24791','A5 30160','A5 30162','A5 30172','A8 361 750','A9 OC195','A9 SF OF0066','B1 BLPADM52105','B1 BLPADM52107','B1 BLPADS72101','B1 FEB32099','B1 KAMF104001','B1 KAMF117201','B7 A210159/DKM','B7 FO-011A/KAVO','B7 SM134','C4 OC 195','C9 ADM52105','C9 ADM52107','C9 ADS72101','C9 FE32099','C9 FE32100','C9 FO-307S','C9 FO-313S','C9 FO-316S','C9 FO-599S','D1 BP ADM52105','D1 BP ADM52107','D1 BP ADS72101','E6 FL1037','E6 FL1045','E6 FL1062','D2 OP595')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #