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 ('C4 W 610/1 SD','B1 PURLS743','A1 OC183','C9 0451103271','A1 10-02-214ASK','A8 312 830','B1 VAL586042','A8 360 885','A1 0451103363','A3 BOS 0986452928','B1 BOS0451103363','A9 W712/73','C9 DO815','C9 SP-951','A9 0451103363','A8 370 626','E6 FL1203','C4 0451103271','B1 BLPADT32109','A3 VAC V64-0002','C4 J1316004','A1 J1316004HB','B1 BOS0451103276','A9 J1318011','C4 OC 217','A1 J1312010HB','C9 0986452928','A2 W610/1','A2 J1316004','E6 FL1158','A2 OC988','A1 OC216','A9 FI OP572','A1 LS144BPU','A5 337788','B1 VAI70-0012','A3 MHL OC601','B1 VAL586040','A2 OC601','C4 LS188BPU','A8 359 156','C9 F026407208','C9 FO-020S','B1 MANW712/21','B1 PURLS908','C9 W712/73','A1 10-02-210ASK','A1 WOF259','A2 0986452035','A3 MHL OC988','C9 W610/1','A2 J1318011','C9 50013919','A8 312 857','C9 H90W27','A8 320 510','A2 J1312018','A1 OC331/1','A1 WOF199','C9 FO-898S','C9 ADT32109','B1 BLPADK82102','C9 W712/21','A8 318 331','C9 ADK82102','A5 30191','A3 BOS 0451103363','A1 0451103271','C9 H97W01','A8 303 521','A9 OC501','A9 FI OP635','C4 0451103276','A1 F026407013','A5 30154','B1 CHACOF102110S','A8 313 520','A3 MHL OC1063','C9 LS188B','A2 FI OP635','A3 MHL OC217','A5 47432','A1 W712/21','A5 174740','A2 UFI 23.213.00','A3 FLT OP635','B1 BOSF026407208','A1 WOF110','A9 W712/21','A5 206442','B7 H130W','A1 OC217/5','A8 307 715','A5 30192','A8 328 205','A3 BOS 0986452027','B7 H90W20','A1 LS357PU','B1 BOS0986452928','A1 OC466','B1 VAI25-0145','C9 SP-1296','B1 MANW610/1','A3 VAC V25-0145','A1 F026407208','A1 OC217','C4 OC 534','B1 PURLS188B','C4 OC 1063','A1 LS908PU','A9 UFI 23.251.00','C9 DO862','A3 JAP FO-601S','A3 JAP FO-020S','A8 312 860','A1 WOF342','A9 J1313021','A9 OC1063','B1 HENH130W','C9 0986452035','B1 PURLS357','C9 LS357','A1 OC1063','B1 VAL586077','B7 OP572/AG','A8 365 877','B1 VAL586082','C4 LS908PU','C4 LS743PU','A1 0986452028','A1 0986452927','C4 H97W07','A3 JAP FO-394S','C4 J1312014','A3 MHL OC74','A1 0986452017','B1 MANW712/73','A1 LS188BPU','A1 10-08-800ASK','A5 206434','A8 919 261','A9 UFI 23.263.00','A8 332 595','A1 10-02-203ASK','C4 J1313021','A1 W610/1','A3 MNN W712/73','A2 H97W07','A2 FI OP572','A3 BOS 0986452035','C4 S 3251 R','A3 MHL OC217/6','C4 COF100138S','A1 10-08-898ASK','A9 0451103276','A5 80216','A9 J1312014','A2 586042','A9 OC217/6','A2 F026407208','C9 33-143220004','A3 MHL OC501','A1 0986452558','A1 0986452928','C9 FE27149','A2 OC501','A5 246901','A5 27522','A3 HEN H90W20','B1 HENH97W07','A8 365 895','A1 J1313021HB','A9 OC331/1','A3 JAP FO-214S','A1 0451103080','D9 16510-60B11 100db','A3 JAP FO-210S','A9 N1318017','A1 C138','C9 FO-394S','C9 DO851/A','A1 0986452038','B1 CHACOF100138S','C9 0986452019','C4 S 8540 R','C9 FO-210S','C9 0986452028','A5 410726','C4 OC 501','D1 BP ADK82102','A8 920 551','A2 J1313021','B7 H97W01','A1 OC534','B7 OP 583/IP','B1 HENH90W20','C9 H130W','B1 BOS0986452035','A3 VAC V70-0012','A2 OC466','A2 W712/21','A2 OC217','C4 0986452019','A2 W712/73','C4 N1318017','A8 357 677','C4 F026407208','A1 0986452019','C9 FO-214S','A1 LS743PU','A9 F026407208','A1 27149 FE','A5 48009','C4 S 2327 R','A2 OC331/1','C9 50013848','A9 0986452028','A3 BOS 0451103276','A3 BOS 0986452019','A3 JAP FO-203S','A9 OC988','C9 SP-1087','C4 W 712/21','A1 0451103276','A5 51783','A1 OC501','A3 MHL OC534','C9 0451103276','A1 J1312014HB','C4 0986452035','A3 BOS 0451103271','A2 OC217/6','B7 SM106','A8 389 804','A8 313 519','A3 MHL OC331/1','C9 LS144B','C4 O0535DREIS','C9 33-143220003','A8 325 297','A2 UFI 23.263.00','C9 ADM52118','A2 0986452028','B1 FEB27149','B1 FTROP572','B1 BOS0986452028','C9 DO816','A3 MNN W610/1','A3 JAP FO-800S','A9 0451103271','C3 16510-61A01','A8 920 547','C4 H90W20','C4 0451103363','B1 HENH90W27','C9 FO-800S','C9 H97W07','A9 OC534','B1 BOS0451103271','A8 934 625','B1 VAL586073','C9 SP-1227','A1 0986452027','C4 OC 217/6','C9 H90W20','A1 OC988','A9 W610/1','A1 OC74','A3 FLT OP583','A1 J1318000HB','A9 0986452035','A1 OC601','B1 BOSF026407221','A2 N1318017','A2 UFI 23.251.00','A1 WOF431','B1 HENH97W01','A8 365 185','A2 J1312014','B7 OP 572/IP','D1 BP ADT32109','A1 COF102110S','C4 S 3263 R','C4 J1318011','A2 OC534','C4 OC 466','A2 0451103276','A3 BOS 0986452028','A9 0986452019','A2 0986452027','B1 BOS0986452019','A2 0451103271','C9 50013863','C9 LS908','C9 71758749','C4 H97W01','A3 JAP FO-898S','A2 UFI 23.210.00','A1 J1318011HB','A1 0986AF1041','B1 FTROP635','A1 F026407221','A2 FI OP583','A8 365 904','B1 VAI64-0001','C9 33-143220002','A1 C110','B7 H90W27','C9 FO-601S','C9 30-143220000','B1 VAL586083','C9 SP-991','D1 BP ADM52118','B7 W610/1/AG','B1 FTROP583','A2 0986452019','C9 0451103363','C4 0986452028','C4 W 712/73','B1 VAI64-0002','A1 0986452917','C4 H90W27','A3 VAC V64-0001','A1 W712/73','A1 OC217/6','A2 OC1063','A2 0451103363','A1 0986452035','C9 DO217','A1 10-02-205ASK','A9 J1312018','A5 169850','A1 OC182','A5 130154','A9 FI OP583','C4 J1312018','A5 24795','C9 DO230','A3 FLT OP572','A8 320 528','A5 174792','A9 J1316004','A1 J1318003HB','A9 UFI 23.210.00','B1 BLPADM52118','A3 MNN W712/21','C9 F026407221','C9 LS743','A5 200755','A5 246884','D3 B12014UN','C9 50013104','C4 W 610/1','C9 FO-203S','B7 OP 635/IP','B7 H97W07','E6 FL1010','C4 LS357PU','A1 WOF149','C4 OC 988','C4 W 68/3','A1 W68/3','C9 W68/3','A2 N1318016','A2 SF OF0072','A9 N1318016','A9 SF OF0072','B1 FEB39829','B1 KAMF102201','B1 KAMF119001','B1 KNEOC534','B7 A210032/DKM','B7 SO-915/KAVO','B7 TO-137/KAVO','C4 N1318016','C9 OF-991','A8 300 023')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #