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