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 365 895','A2 UFI 23.251.00','A1 OC1566','B1 MANW610/3','A2 J1310303','A3 MNN W610/9','A3 MHL OC1566','A1 WOF110','C4 W 811/81','A3 FLT OP621','A2 W610/1','A9 W610/1','C9 SP-1087','C4 OC 195','C4 W 610/9','C9 0986452028','A3 BOS 0986452019','C4 0451103276','C4 0986452041','A1 LS743PU','A2 OC195','A3 MNN W68/3','C4 O0547DREIS','A8 320 525','C4 S 3251 R','C4 O0537DREIS','C9 0451103276','A1 OC217/6','A2 0986452044','A2 OC2176','A3 MNN W811/81','A5 206434','C4 986452019','A8 312 866','B1 KNEOC217/6','C9 0986452044','A2 OC1198','B7 H130W','A3 JAP FO-800S','A5 372329','A2 W610/9','A1 W610/9','A1 0451103276','C9 SP-1227','C4 J1312014','A1 LS908PU','A9 0986452044','A9 OC195','A1 0986452041','C9 W68/1','B7 H13W03','A2 OC331/1','C4 OC 217/6','A3 BOS 0986452041','A8 359 156','C9 W811/81','A9 W68/3','A2 J1313021','B1 KNEOC1566','A5 44074','A3 MHL OC331/1','B1 MANW68/3','B1 FTROP621','C9 0986452019','C4 LS908PU','A2 0451103276','A1 WOF258','C4 H97W01','A9 OC1566','C4 J1313021','C4 W 610/3','A5 51783','A2 OC217/6','A1 OC183','C9 0986452041','B1 BOS0986452044','A5 80216','C4 OC 217','A5 202446','C9 DO862','B1 HENH130W','B7 OP621/AG','A3 BOS 0451103276','A1 0986452028','C4 0986452019','A2 W811/81','A2 FI OP621','A5 30191','B1 BOS0986452028','B1 PURLS301','C9 FO-898S','A1 WOF1868','B1 HENH97W08','C4 J1310303','A3 BOS 0986452028','A8 303 521','C4 J1318011','A1 WOF217','C4 O0535DREIS','C4 W 610/80','A1 J1312014HB','C4 W 610/1','C9 LS301','B1 KNEOC534','A2 OC1566','A3 JAP FO-214S','A2 J1312014','B1 BOS0451103276','A5 202449','C9 W610/9','B1 PURLS908','C4 986452044','C4 986452028','A9 OC331/1','C4 0986452028','B1 MANW811/81','C4 W 610/1 SD','A5 288024','B1 MANW610/9','C9 LS743','A9 FI OP621','A1 OC217','A5 24791','A3 BOS 0986452027','A1 W610/1','A9 0986452019','C4 0986452044','A8 365 185','C4 W 68/1','C9 FO-214S','B1 BOS0986452019','B7 W610/3/AG','C4 451103276','B7 H97W01','A8 312 860','A3 MNN W610/3','A9 J1318011','B1 PURLS743','C4 986452041','A1 W68/1','C9 H97W01','C4 LS743PU','A1 OC331/1','A3 MHL OC217/6','A1 OC1198','A3 JAP FO-898S','A8 313 519','C9 H13W03','A2 J1318011','A9 OC217/6','A9 J1313021','A9 W811/81','A8 302 460','A1 0986452044','C9 H130W','C9 W68/3','A3 MHL OC217','B1 HENH97W01','A9 0986452028','A8 312 857','A3 BOS 0986452044','A9 UFI 23.251.00','A5 62149','A2 W68/3','D3 B12014UN','A1 OC195','A9 0986452041','A5 27522','A8 312 820','A1 W68/3','A1 LS301PU','A1 OC2175','A9 0451103276','A8 349 511','A1 OC3311','A1 W610/3','B7 W610/1/AG','C9 W610/3','B1 MANW610/1','A1 0986AF1041','A3 MNN W610/1','C4 W 68/3','A1 0986452019','B1 KNEOC217','C9 DO815','A5 337788','A1 0986452027','C9 W610/1','A2 W610/3','A1 0451103364','A3 MHL OC195','A2 0986452019','A9 W610/3','B1 BOS0986452041','A1 W811/81','A8 300 023','B7 W68/3/AG','B7 H97W08','A2 OC217','B7 OP 621/IP','C4 OC 1566','C9 LS908','C9 H97W08','A1 WOF199','A2 0986452027','C4 W 811/81 SD','A9 W610/9','A1 WOF342','A2 0986452028','A9 J1310303','A8 303 393','A5 47432','A2 0986452041','A5 24795','A1 OC217/5','A1 W818/84','A3 BOS 0451103364','A1 J1318011HB','A9 J1312014','A5 48009','A5 80960','C9 FO-800S','A1 C138','A1 C170','A1 COF102110S','A2 J1311017','A2 SF OF0372','A8 307 265','A9 J1311017','A9 SF OF0372','B1 BLPADK82102','B1 BLPADT32112','B1 CHACOF100170S','B1 FEB39829','B1 KAMF105201','B7 SM106','B7 SM148','B7 SO-915/KAVO','C3 16510-61A01','C4 J1311017','C9 30-143220009','C9 ADK82102','C9 ADT32112','C9 OF-1227','C9 OF-6108','D1 BP ADK82102','D1 BP ADT32112')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #