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 ('A1 W610/1','A9 0986452062','A9 0451103363','A2 W940/1','C9 W940/18','B7 W610/1/AG','A1 WOF1868','A9 OC478','A3 MNN W940/1','B1 PURLS359','B1 MANW610/1','A3 BOS 0451103363','A2 J1312015','A3 BOS 0986452062','B1 HENH90W27','A8 325 297','A8 306 512','A1 WOF203','A9 0986452044','B1 BOS0986452058','B7 H96W01','C9 FO-394S','A9 UFI 23.477.00','A2 UFI 23.253.00','C9 W712/83','A1 0986AF1042','A5 174792','A8 389 804','C4 O0535DREIS','A1 W711/80','B7 OP 618/IP','C4 LS188BPU','A1 0451103275','A8 312 820','A1 OC466','C9 W610/1','A5 43729','B1 HENH14W32','C9 SP-994','A8 332 595','A8 313 482','C4 O0583DREIS','A8 312 855','C9 FO-215S','A2 OC466','A2 W7015','C4 OC 988','C9 DO910','C9 DO339','C9 LS357','A3 JAP FO-215S','A2 J1312021','A1 LS186PU','A1 0986AF1041','A2 W610/1','B1 HENH96W01','B1 PURLS186','C4 0451103276','A1 J1312011HB','C9 LS908','A3 JAP FO-279S','B1 KNEOC988','C4 J1312015','A1 OC235','C9 LS359','A1 10-02-279ASK','B1 PURLS188B','A9 0451103275','C9 H96W01','C4 0451103363','A9 0451103276','A3 MNN W712/73','C4 986452044','A3 MHL OC478','A3 MHL OC988','C4 LS186PU','C9 0451103363','A2 UFI 23.477.00','A1 W940/18','B1 PURLS357','A3 MNN W712/83','A3 JAP FO-394S','A8 370 404','B1 MANW712/73','B1 MANW7015','A1 OC 478','A3 FLT OP618','C9 H90W27','A5 115502','C9 0451104063','C4 0451103275','A5 44813','C4 0986452058','A1 0451103276','B1 MANW940/18','A2 W940/18','C4 451103363','A2 0986452062','C9 LS188B','A9 W940/1','A1 W712/83','C9 H14W32','C4 W 712/83','A8 303 521','A3 BOS 0986452058','A1 0986452044','A2 0451103363','A9 0451104063','B1 FTROP618','C4 451103275','A9 W940/18','A2 OC988','B1 KNEOC235','A9 W610/1','B1 BOS0451103275','A5 202450','C9 SP-845','B7 W7015/AG','B1 BOS0451103276','A9 W7015','A2 OC478','A5 432463','C4 O0550DREIS','A1 LS908PU','C4 P559418','A5 44642','C4 LS357PU','B1 BOS0986452062','B1 KNEOC478','A9 UFI 23.253.00','C4 H14W32','A3 MNN W940/18','A8 312 860','B1 BOS0451103363','C4 S 3253 R','A2 0986452058','C9 DO911','A8 359 156','A8 320 522','B1 BOS0451104063','B7 H90W27','B7 H90W30','C4 W 7015','B1 MANW712/83','A3 MNN W610/1','A8 328 205','A5 206442','C4 451103276','A1 W712/73','C4 H90W27','C9 FE27147','C4 J1312021','A1 27147 FE','A1 J1312015HB','A1 0451103363','C9 0986452058','A1 0986452002','C4 OC 466','C4 0986452062','A5 246884','A1 W940/1','C4 W 940/1','C4 W 712/73','A1 WOF243','B7 OP618/AG','A5 85355','C4 0451104063','C9 0451103275','A1 0986452062','A9 FI OP618','A1 WOF1862','A3 BOS 0451103275','A9 J1312021','A5 337788','A9 J1312015','A2 0451103275','C9 W940/1','C4 986452058','A8 328 206','A1 0986AF1060','A1 OC478','A9 W712/83','A8 920 093','A5 500318','C4 H96W01','C9 FO-279S','C9 0986452044','A8 365 896','A5 337785','A3 BOS 0451103276','A5 250170','A2 W712/83','B1 FEB27147','B1 PURLS908','A2 W712/73','B7 H14W32','A3 BOS 0451104063','A2 FI OP618','A1 LS359PU','A5 169850','A1 W7015','B7 W712/83/AG','C4 LS908PU','A9 0986452058','A1 WOF342','A8 303 523','A1 0451104063','A1 LS188BPU','A3 BOS 0986452044','A9 OC988','C4 W 610/1 SD','A2 J1311035','A8 378 012','C9 0986452062','C4 0986452044','C9 LS186','A2 0451104063','B1 BOS0986452044','C4 451104063','C4 27147F','C9 W712/73','A1 WOF259','C4 S 6902 R','C4 W 940/18','A1 WOF199','A5 62149','A1 LS357PU','C9 0451103276','A2 0451103276','A2 0986452044','A5 51783','B1 MANW940/1','A1 0986452058','A8 303 046','A9 W712/73','C4 W 610/1','A1 OC988','C4 J1311035','C9 W7015','A1 C182','A1 W68/3','A1 W940/81','A2 FI OP549','A2 FI OP621','A2 J1318011','A2 SF OF0183','A2 SF OF0372','A2 W68/3','A2 W940/81','A3 FLT OP549','A3 FLT OP621','A5 202449','A8 300 023','A8 318 425','A8 320 525','A8 360 057','A8 360 975','A9 J1318011','A9 SF OF0183','A9 SF OF0372','A9 W68/3','A9 W940/81','B1 BLPADM52118','B1 BLPADT32108','B1 BLPADT32114','B1 CHACOF100182S','B1 FTROP549','B1 FTROP621','B1 KAMF106401','B1 KAMF119001','B1 MANW68/3','B1 MANW940/81','B7 MO-534/KAVO','B7 OP621/AG','B7 SM106','B7 SM133','B7 SM143','B7 TO-133/KAVO','B7 TO-138/KAVO','C4 J1318011','C4 O0547DREIS','C4 W 68/3','C4 W 940/81','C9 30-143220004','C9 ADM52118','C9 ADT32108','C9 ADT32114','C9 OF-1227','C9 OF-478','C9 W68/3','C9 W940/81','D1 BP ADM52118','D1 BP ADT32108')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #