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