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 BOSF026407001','A2 UFI 23.452.00','A3 JAP FO-313S','A9 0451104025','A5 135057','A9 FI OP595/2','B1 PURLS892','B7 OP 643/6/IP','A3 JAP FO-705S','A9 F026407142','A1 OC1198','A9 J1317004','A1 F026407210','A2 W6025','C4 J1311026','C4 J1317005','A1 WOF380','A9 UFI 23.452.00','C9 FO-315S','A3 BOS 0451104025','B1 FTROP595','A5 44094','C4 S 5120 R','A5 372329','A8 909 602','A5 37986','A1 F026407209','A3 BOS F026407210','A9 F026407001','A8 909 802','B1 BOS0986452036','A8 365 902','A2 F026407001','A2 OC1566','A5 30187','A5 288024','A3 MHL OC575','A2 0451103275','B1 KNEOC194','C9 FO-313S','C4 0451103275','A1 0451103292','C9 0451103292','A8 907 969','A5 75071','A3 BOS 0451104068','A5 432473','A1 10-07-705ASK','C4 0986452036','A1 LS965PU','A2 J1311026','B1 BOS0451104025','C9 F026407001','A2 F026407209','A1 OC495','A2 J1310303','D1 BP ADM52121','C9 W7023','A2 FI OP595','C9 LS301','B1 HENH97W06','A1 J1314012HB','C4 J1317004','C9 LS892','C4 F026407001','A1 LS301PU','A3 FLT OP595','C9 0451104025','A5 250139','C4 F026407025','C9 DO853/A','A9 UFI 23.271.00','A9 UFI 23.259.00','C4 F026407209','C9 DO854/A','A3 MHL OC495','A8 313 523','A2 UFI 23.424.00','A3 BOS 0451103275','C4 J1315024','A5 24791','A8 371 710','C9 FO-705S','B1 MANW67/1','A9 W7023','C4 F026407142','A1 0451104068','C9 ADN12112','A1 0451104509','A3 BOS F026407025','A2 UFI 23.484.00','C4 O0544DREIS','A5 80960','A8 360 886','B1 MANW6025','C9 DO949','A9 UFI 23.424.00','A2 J1313016','A2 OC1198','A1 J1311018HB','A1 OC285','A1 J1313016HB','C4 986452041','A3 BOS F026407001','A3 JAP FO-120S','B7 OP643/6/AG','E6 FL1183','A1 0986452061','C4 H97W06','A8 914 400','A9 J1311026','A3 MHL OC521','C4 W 7023','A5 372458','B7 H97W06','B1 FTROP595/2','A3 MHL OC195','A5 40935','C9 SP-1002','A9 UFI 23.258.00','A9 0986452036','C4 OC 495','A2 J1315024','A2 OC575','B1 KNEOC617','B1 PURLS965','A1 10-07-703ASK','A5 40942','A2 F026407025','A2 FI OP643/6','A3 BOS F026407209','C4 S 6900 R','A9 J1317003','A8 300 080','A2 J1314014','A1 J1317005HB','A3 FLT OP595/2','A9 J1317008','A1 10-03-315ASK','A9 F026407210','A9 0451103275','A5 174794','B1 BLPADN12112','C9 LS490A','B7 H13W03','A8 919 224','A1 W67/1','A8 365 943','A8 358 666','A8 370 625','A3 JAP FO-301S','A5 30162','A9 OC195','A1 J1310500HB','A1 W6025','C9 DO854','B1 BOS0451103292','A9 FI OP643/6','C4 S 3424 R','C9 0986452036','A1 10-05-593ASK','C9 FO-703S','A9 F026407209','C4 OC 195','A1 0986452036','B1 BLPADM52106','A2 UFI 23.258.00','E6 FL1015','A9 J1310303','A9 J1317005','C9 H97W06','C9 F026407142','A2 F026407210','D1 BP ADM52106','A3 JAP FO-315S','C4 451103275','A1 OC575','A9 W6025','A1 OC195','A2 W67/1','A9 J1313016','A1 F026407001','A2 F026407142','A2 0986452036','B7 W67/1/AG','B1 BOS0451103275','C9 SP-1079','A8 318 352','C9 0986452061','A1 F026407025','B1 MANW7023','C4 0986452061','C9 F026407025','C9 ADM52121','A3 MHL OC1566','A8 312 854','C4 0451103292','A8 312 856','A1 OC259','A3 JAP FO-703S','C4 J1313016','A8 919 464','B1 KNEOC521','A1 OC1566','C9 FO-120S','A3 JAP FO-593S','A3 BOS 0986452036','A8 913 453','B1 BOSF026407210','B1 PURLS301','C9 W67/1','C4 W 6025','C4 J1310500','A1 10-01-120ASK','A1 10-03-313ASK','A8 365 387','C4 F026407210','C9 FO-593S','A2 0451103292','A2 UFI 23.259.00','C4 986452036','A9 F026407025','C4 S 3258 R','A9 0451103292','A1 H97W06','A2 FI OP595/2','C4 OC 1566','B7 OP 595/2/IP','C4 J1314014','A1 WOF279','A2 W7023','A1 LS490APU','A1 W7023','C4 451103292','C4 0451104025','A2 J1310500','C4 S 3484 R','A3 BOS 0986452061','A1 J1317004HB','A2 J1317004','A8 378 828','B7 CY-021/KAVO','C9 LS871A','A1 0451104025','C9 H13W03','A5 242157','A9 J1310500','A9 OC495','A1 0451103275','A5 202448','A8 919 462','D1 BP ADG02109','A1 LS892PU','C4 OC 575','A1 F026407142','C9 SP-1006','A9 W67/1','A2 OC195','A1 WOF189','C4 J1317008','B7 OP595/AG','D1 BP ADN12112','C4 W 67/1','A9 FI OP595','A3 BOS 0451104509','A2 J1317003','A2 OC521','C9 W811/85','E6 FL1009','C9 LS965','C9 W6025','C4 S 3428 R','A8 921 237','A8 365 901','A5 267387','A9 OC1566','A3 BOS 0451103292','B1 BOSF026407025','B1 KNEOC196','C9 ADG02109','A5 410733','C4 LS892PU','C9 ADM52106','B1 BOS0986452061','A8 365 336','C9 DO836','A2 0451104025','A8 920 549','B7 SM166','A9 OC575','A2 OC495','A9 UFI 23.484.00','B7 SM134','C4 J1317003','A3 MNN W67/1','B1 BOSF026407209','B7 OP595/2/AG','A3 BOS F026407142','B1 KNEOC1566','C4 451104025','A3 FLT OP643/6','A2 UFI 23.272.00','E6 FL1224','C9 F026407210','B7 OP 595/IP','A5 51807','A1 W811/85','C4 986452061','C9 0451103275','C4 J1310303','A2 J1317005','B1 BLPADM52121','B1 BLPADG02109','A1 OC521','A2 J1317008','A2 UFI 23.271.00','B1 FTROP643/6','B1 BOSF026407142','A2 0986452061','A9 UFI 23.272.00','A2 SF OF0066','A9 SF OF0066','B1 FEB32099','B1 KAMF103301','B1 KNEOC195','B7 HO-821/KAVO','B7 NO-2223/KAVO','C4 NO-2233','C9 FE32099')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #