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 COF102126S','A9 OC194','A2 UFI 23.265.00','C4 J1311026','B1 VAL586013','B7 MO-511/KAVO','A8 327 960','C4 J1311019','C4 OC 495','B1 KAMF101401','C9 DO925/A','B7 OP575/AG','C9 FO-313S','A8 326 553','A5 82995','A1 LS225PU','A3 JAP FO-316S','A2 W610/3','A1 F026407001','B1 HENH313W','A8 312 866','B7 NO-2223/KAVO','A3 VAC V30-1338','B1 HENH97W08','B7 SM166','C9 W67','B7 H97W06','A1 H97W06','A9 W610/3','A3 VAC V26-0012','A3 MHL OC196','C4 J1313016','C4 S 3258 R','B1 MISZ438','C9 2143220008','A1 F208','A8 365 979','A3 FLT OP545/2','A9 SF OF0063','B1 VAI32-0017','A2 J1311026','A5 30172','C9 FO-120S','A2 J1311019','C9 H97W06','C9 H97W05','A3 JAP FO-022S','A5 372329','B1 MANW67','A3 JAP FO-406S','A2 586013','C9 H97W11','C9 LS287','A3 BOS F026407001','C4 0451103372','A5 30105','A2 J1313016','C9 DO324','A2 SF OF0066','B7 MO-424/KAVO','B7 A210159/DKM','A9 OC986','B7 FO-011A/KAVO','C9 OF-934','C9 50013109','A2 SF OF0054','C9 LS350','C4 OC 196','A2 J1315024','B1 VAL586021','B1 FTROP575','C9 6143220000','A3 VAC V32-0017','B7 SM103T','A5 162212','A9 UFI 23.438.00','A1 J1315026HB','A2 OC495','C4 COF100208S','C9 DO828','A5 37986','A3 JAP FO-H05S','B1 BOS0451103372','C9 SP-1094','A5 202446','B1 BOSF026407001','B1 KAMF115601','A5 23607','B1 FTROP545/2','B1 CHACOF102126S','B7 OP 575/IP','C9 FO-198S','C9 0986452061','C9 F026407001','C9 50013146','A1 OC259','A5 294014','C9 0986452041','A2 OC521','A9 W67','A1 LS287PU','B1 KNEOC986','B7 10406/JAPKO','A1 10-04-406ASK','C4 S 3265 R','A1 J1311019HB','A1 H90W25','C4 OC 194','C4 H97W06','A1 OC196','A1 F110','A3 MHL OC194','B7 H97W05','A2 UFI 23.479.00','A1 OC1198','A3 MNN W610/3','A9 0986452041','C4 OC 986','A1 F126','A3 JAP FO-120S','B1 FEB32100','A5 38819','A8 921 237','A9 J1313016','A2 OC194','A1 OC495','B7 SM103','A1 10-03-313ASK','A9 UFI 23.479.00','A8 318 761','A2 OC986','C4 H90W25','A2 H90W25','C9 FO-410S','C4 H97W05','B1 BOSF026407347','B7 A210021/DKM','B1 HENH97W06','A8 318 339','A8 370 542','A3 BOS 0986452041','A5 44074','C4 O0537DREIS','B1 KAMF102001','C4 LS225PU','A2 OC196','A1 32100 FE','C4 F026407001','B7 A210023/DKM','B7 H97W11','B1 CHACOF100208S','C4 O0543DREIS','C9 OF-919','B7 1118502200/JP','C4 H97W01','A8 919 224','B1 VAI30-1338','A8 907 969','A9 FI OP575','B7 H313W','A2 F026407001','B1 KNEOC521','A5 267387','A3 FLT OP575','A1 0986452061','C9 DO912','B7 10120/JAPKO','A1 OC194','A1 LS350PU','A1 OC986','A2 UFI 23.484.00','B1 VAL586153','B7 10316/JAPKO','A8 370 625','A9 SF OF0066','C9 H90W25','A1 J1311018HB','A8 368 390','A8 302 460','A2 SF OF0063','A8 370 624','C9 DO854/A','B7 OP 545/2/IP','C9 32-143220004','C9 71758756','A1 WOF131','A8 365 906','A1 OC521','A3 BOS 0986452061','A2 OC1198','A3 MHL OC521','A3 VAC V46-0224','B1 MANW610/3','C4 LS287PU','A5 135057','A1 F129','A1 0451103372','C4 0986452061','A9 J1317004','A9 FI OP545/2','A3 MNN W67','A9 UFI 23.265.00','C9 W610/3','A3 VAC V52-0131','B1 PURLS350','A2 UFI 23.438.00','B7 SM104','C4 J1315024','C9 71758747','C4 J1315026','C4 32100F','B1 KAMF113501','B7 NO-242C/KAVO','A1 WOF260','B1 PURLS910','B1 VAL586060','A1 0451103364','C4 S 4030 R','A9 UFI 23.484.00','B7 H97W08','C9 FO-022S','A3 JAP FO-198S','C4 S 3484 R','B1 HENH97W01','A3 KAP MO-511','C9 OF-1094','A1 W610/3','B7 H90W25','B7 OP545/2/AG','A8 350 614','C4 W 67','A1 10-03-316ASK','C9 FO-316S','B1 BOS0986452061','A9 OC495','A9 F026407001','C4 S 6900 R','C9 FE32100','A2 FI OP545/2','C4 S 3261 R','A3 KAP FO-011A','A3 MHL OC495','A3 BOS 0451103364','B1 BOS0986452041','C4 0986452041','C4 LS910PU','A1 10-04-410ASK','B1 VAI24-0018','C4 H97W11','A9 H97W05','A9 J1311026','C9 H97W08','B7 10022/JAPKO','A5 174791','A5 200758','C9 LS225','C4 NO-2233','B7 W610/3/AG','C4 LS350PU','B1 PURLS287','A3 MHL OC986','A3 JAP FO-410S','A5 288090','C9 OF-067','A2 FI OP575','C9 71760123','A3 JAP FO-313S','B1 HENH97W11','A3 KAP HO-821','A2 J1317004','A1 H97W05','C9 FO-H05S','A2 0451103372','C4 S 3479 R','A1 0986452041','B1 CHACOF100128S','C9 DO328','A3 BOS 0451103372','B1 VAI46-0224','B7 H97W01','B1 KAMF104401','A2 W67','C9 OF-0410','B1 HENH90W25','A8 920 549','A1 J1313016HB','A9 SF OF0054','B7 HO-821/KAVO','C9 FO-406S','A1 50013146','B7 10410/JAPKO','B7 SM124','C9 LS910','B1 HENH97W05','B1 PURLS225','B7 SM134','C4 W 610/3','B1 VAI52-0131','B1 KAMF103301','A8 370 630','B1 KNEOC495','B7 10313/JAPKO','A5 496739','A1 LS910PU','C9 50013848','A1 OC 194','A9 0451103372','C4 COF100128S','A1 WOF258','A5 30162','A3 KAP NO-2223','C4 H313W','A2 H97W05','C4 J1317004','C9 0451103372','A9 J1311019','A2 0986452041','B1 KNEOC196','A3 VAC V24-0018','A9 OC196','A2 J1315026','B7 SM121','A2 0986452061','A1 W67','A5 250139','C9 F026407347','C9 H97W01','A1 F026407077','A1 W610/6','A1 WOF197','A2 F026407077','A2 W610/6','A3 BOS F026407077','A8 349 237','A8 907 970','A9 F026407077','A9 W610/6','B1 BOSF026407077','B1 MANW610/6','C4 F026407077','C4 O0539DREIS','C4 W 610/6','C9 F026407077','C9 W610/6')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #