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