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 OP 595/2/IP','A2 FI OP617','A3 FLT OP595/2','A5 432472','A9 UFI 23.616.00','A2 FI OP595/2','A1 LS892PU','B7 OP595/AG','A3 MHL OC1183','A2 F026407160','A3 VAC V32-0017','C9 0451103275','A8 376 420','A1 J1311018HB','A9 0451103275','A8 358 666','A5 410733','B1 BLPADG02109','A3 MHL OC1566','E6 FL1224','A9 W6018','C4 S 5120 R','A3 JAP FO-705S','A5 30187','B1 FTROP595','C9 ADN12112','A8 300 080','A1 0451103275','A3 MHL OC195','A3 FLT OP595','A2 F026407001','C4 W 67/1','A5 44094','C4 OC 195','A9 F026407209','A8 320 521','C4 F026407160','A2 0451103275','B1 HENH97W06','A9 F026407210','C4 LS892PU','A1 J1314012HB','B7 H328W','A9 F026407001','C9 DO853/A','A8 370 625','A1 OC1052','C4 OC 1566','B1 PURLS892','A2 FI OP595','A5 288024','B1 BOSF026407210','E6 FL1183','C9 DO854/A','A9 FI OP617','B1 BLPADH22113','A9 F026407160','D1 BP ADG02109','A2 OC1566','A8 919 224','A1 W67/1','A3 BOS 0986452061','B1 BOSF026407160','A5 24791','A2 OC1183','A3 MNN W67/1','A2 W6018','C9 ADG02109','A2 UFI 23.259.00','A1 OC1566','A1 OC195','A1 J1313016HB','B1 BOSF026407209','D1 BP ADM52121','C9 W67/1','A9 OC1566','A9 FI OP595','B7 W67/1/AG','A5 372458','C4 W 6018','A3 BOS F026407209','A1 J1317005HB','A2 H97W09','A1 F026407001','A1 WOF1404','C9 0986452061','C9 ADH22113','A3 MHL OC1052','A5 30162','A1 10-03-313ASK','A9 FI OP595/2','B1 BLPADM52121','C9 F026407001','A1 J1313002HB','B7 OP617/AG','B1 BOS0451103275','A2 F026407209','B7 OP 595/IP','A1 H97W06','A3 BOS F026407160','A8 907 969','A1 J1310500HB','A9 UFI 23.259.00','C9 F026407160','A3 FLT OP617','C4 H97W09','B7 OP595/2/AG','A3 BOS F026407001','A1 F026407210','C9 LS892','A8 365 902','B1 VAL586022','A2 586022','B1 BLPADM52106','C4 0986452061','C4 O0544DREIS','C9 DO854','A9 W67/1','E6 FL1009','B7 OP 617/IP','C9 W6018','A3 JAP FO-313S','A1 W811/85','C4 S 3258 R','C9 FO-593S','A8 381 698','A5 174742','A1 F026407209','A1 OC285','A3 BOS 0451103275','A1 F026407160','D1 BP ADH22113','A3 JAP FO-315S','B1 FTROP595/2','A8 914 088','A9 UFI 23.272.00','A3 BOS F026407210','C9 ADM52106','B1 FTROP617','C9 W811/85','A8 920 549','A2 UFI 23.272.00','C9 FO-315S','C9 FO-705S','A1 OC1183','A2 OC1052','A9 OC195','A8 378 828','C9 ADM52121','D1 BP ADN12112','A2 UFI 23.616.00','A2 F026407210','A9 OC1183','A2 W67/1','A3 JAP FO-593S','B1 BLPADN12112','C4 0451103275','C4 H97W06','A5 202448','C4 F026407209','B1 VAL586033','C9 H97W06','A5 135057','A8 312 854','D1 BP ADM52106','B7 H97W06','B1 BOSF026407001','A8 318 352','C9 H97W09','A8 360 886','B1 HENH328W','A1 0986452061','A1 W6018','A8 370 628','B1 MANW6018','B1 HENH97W09','C4 F026407210','B1 MANW67/1','C4 S 3484 R','A8 918 284','C4 F026407001','C9 F026407210','A2 0986452061','E6 FL1015','C9 FO-313S','A1 10-03-315ASK','B1 VAI32-0017','A1 WOF1907','A1 J1317004HB','A1 WOF189','A5 174794','B7 H97W09','A2 OC195','C4 H328W','B1 BOS0986452061','A1 J1311011HB','A1 J1313015HB','A1 J1317003HB','A2 J1310303','A2 J1311026','A2 J1317004','A2 J1317008','A2 SF OF0066','A2 UFI 23.258.00','A3 JAP FO-120S','A5 37986','A8 365 901','A8 920 092','A8 920 430','A9 J1310303','A9 J1311026','A9 J1317004','A9 J1317008','A9 SF OF0066','A9 UFI 23.258.00','B1 CHACOF100129S','B1 FEB32099','B1 KAMF103301','B1 KNEOC1183','B1 KNEOC195','B1 VAL586017','B1 VAL586060','B7 A210159/DKM','B7 FO-011A/KAVO','B7 HO-821/KAVO','B7 NO-2223/KAVO','B7 SM134','C4 J1310303','C4 J1311026','C4 J1317004','C4 J1317008','C9 34-143220002','C9 35-143220000','C9 35-143220007','C9 FE32099','C9 FO-120S','C9 OF-946','C9 SP-1002','C9 SP-1436')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #