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 ('B1 KAMF113501','B7 OP 575/IP','C9 LS225','A2 FI OP575','A1 F026408721','C9 50013109','A1 J1311019HB','C4 O0537DREIS','A2 0986452041','B1 BLPADN12111','C9 DO925/A','A5 30172','B7 OP 545/2/IP','A1 W610/3','B7 W610/3/AG','C9 0986452041','C9 DO912','A1 0451103364','A3 MNN W610/3','A1 0986452041','A3 BOS 0986452041','A8 368 390','A2 W610/3','A5 202446','D1 BP ADC42116','A9 W610/3','C4 J1313016','C9 LS910','A3 JAP FO-316S','B1 FTROP545/2','A5 288090','A2 F026407025','A1 F026407025','A8 914 400','B1 MANW610/6','A2 UFI 23.265.00','C4 LS910PU','B1 FTROP575','A1 WOF258','A9 W610/6','C9 ADM52107','E6 FL1222','A5 44074','D1 BP ADN12111','B1 VAL586013','C4 O0539DREIS','B1 KNEOC617','C9 FO-316S','C4 J1315024','A1 10-0H-005ASK','A3 BOS F026408721','B7 10316/JAPKO','A9 FI OP575','C9 SP-989','B1 PURLS910','A9 UFI 23.438.00','C9 DO925','A1 W610/6','C9 ADC42116','A2 J1315024','A8 360 406','C9 SP-1094','C9 ADL142102','A5 372329','D1 BP ADL142102','A8 374 429','A9 J1313002','A1 WOF197','C9 W610/3','C4 0986452041','B1 BLPADC42116','B1 KNEOC259','A3 BOS F026407025','A1 10-03-316ASK','B1 BOSF026407025','A9 J1313016','A8 302 460','D1 BP ADM52107','A9 FI OP545/2','A1 J1313016HB','C4 W 610/6','A8 365 906','B1 KNEOC196','A2 586013','C4 LS225PU','A2 J1311019','A1 WOF380','A5 82995','A8 349 237','A3 FLT OP545/2','A8 920 549','A2 UFI 23.438.00','A9 J1311019','A2 J1313016','B1 BLPADM52107','A1 COF102126S','A9 F026407025','A8 318 339','A8 318 761','C4 LS287PU','C4 J1313002','B1 BLPADL142102','C4 S 4030 R','B1 PURLS225','A1 J1313002HB','B7 OP545/2/AG','A3 MNN W610/6','B7 A210021/DKM','E6 FL1045','C4 S 3265 R','C9 SP-919','A2 FI OP545/2','B1 CHACOF102126S','A1 LS225PU','C9 DO895','A8 312 866','C9 F026407025','B1 PURLS287','C9 W610/6','A5 174791','B7 OP575/AG','A9 UFI 23.265.00','C9 ADN12111','A8 326 553','A2 J1313002','A1 LS910PU','C9 DO853/A','B1 BOS0986452041','A1 LS287PU','A3 BOS 0451103364','A1 10-01-198ASK','A2 W610/6','C4 W 610/3','B1 KNEOC986','A9 0986452041','E6 FL1211','A5 75071','C4 F026407025','A3 FLT OP575','C4 J1311019','C9 LS287','B1 MANW610/3','A1 10-04-410ASK','A1 32100 FE','A1 F026407077','A1 OC196','A1 OC986','A1 WOF131','A2 F026407077','A2 OC196','A2 OC986','A2 SF OF0054','A3 BOS F026407077','A3 JAP FO-120S','A3 JAP FO-313S','A3 MHL OC196','A3 MHL OC986','A5 200758','A5 23607','A5 30105','A5 30162','A5 30174','A5 37986','A8 907 970','A9 F026407077','A9 OC196','A9 OC986','A9 SF OF0054','B1 BLPADH22114','B1 BOSF026407077','B1 FEB104333','B1 VAL586011','B1 VAL586021','B1 VAL586023','B7 SM104','C4 F026407077','C4 OC 196','C4 OC 986','C9 2143220008','C9 6143220000','C9 ADH22114','C9 F026407077','C9 F026407347','C9 FE32100','C9 FO-120S','C9 FO-313S','C9 FO-406S','C9 FO-503S','C9 OF-0410','C9 OF-1094','D1 BP ADH22114','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #