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 ('A2 J1314010','A8 920 549','A2 J1314010F','A1 J1314018HB','B1 KNEOC617','C4 O0539DREIS','C9 H97W05','A1 F026407025','C4 H97W05','A9 SF OF0063','A5 372329','B1 MANW610/10','A2 F026407077','A5 75071','A8 365 906','C9 FO-316S','A3 JAP FO-410S','A5 30172','B7 OP575/AG','C4 J1314012','A9 0986452041','B1 FTROP575','A9 FI OP575','A5 162212','A2 SF OF0054','A2 UFI 23.265.00','A1 10-04-410ASK','A3 MHL OC115','A2 0986452061','B1 HENH90W25','C9 F026407025','C4 J1313016','C4 OC 115','A9 UFI 23.265.00','A9 J1313016','A9 J1314013','A2 J1314012','A1 WOF380','A5 38819','B1 CHACOF100128S','C4 COF100128S','B1 KAMF102001','A9 OC115','A3 KAP HO-824','A1 LS910PU','A8 914 400','B7 HO-818/KAVO','B7 A210021/DKM','A2 OC617','A3 KAP MO-429','A3 JAP FO-316S','B7 OP 575/IP','C9 FO-410S','A2 H97W05','C4 LS910PU','C4 W 610/6','A3 KAP HO-823','A5 496739','C9 OF-0410','C9 DO828','B1 MANW610/6','B1 KNEOC196','C9 OF-1094','C9 50013146','C4 LS489APU','C9 F026407077','A1 LS489APU','A5 174793','A3 BOS F026407025','A3 JAP FO-599S','A9 J1314012','B1 KAMF113501','B7 10410/JAPKO','A3 KAP HO-818','B1 VAI24-0018','A5 30160','A5 13603','C4 F026407025','A1 J1314013HB','C4 S 3265 R','A9 F026407025','A9 OC617','C4 J1314013','B1 VAL586021','B1 BOSF026407025','A3 FLT OP575','A9 H97W05','A2 W610/6','A1 OC617','A3 MHL OC617','A8 350 614','A1 OC259','B7 HO-824/KAVO','B1 CHACOF102126S','A1 OC115','A1 10-05-599ASK','C4 0986452041','A3 VAC V26-0012','B1 PURLS350','B1 KAMF101401','A2 0986452041','A1 0986452041','A8 318 852','A1 F026407077','C4 H90W25','C9 W610/6','B1 PURLS489A','C9 LS910','B7 H97W05','A9 J1314010','A3 BOS 0451103364','C9 0986452061','A3 VAC V52-0131','A1 H90W25','A1 0451103364','A9 F026407077','A1 0986452061','A1 WOF197','B7 MO-429/KAVO','A9 W610/6','C9 H90W25','A5 206439','A8 312 866','C9 FO-599S','B7 A210023/DKM','A1 LS350PU','B1 PURLS910','A1 H97W05','C4 J1314010','C4 F026407077','A9 SF OF0054','A2 F026407025','A3 MNN W610/6','C9 LS350','B1 HENH97W05','B1 BOS0986452041','A1 J1313016HB','B1 VAI52-0131','C9 DO925/A','A2 H90W25','A3 BOS F026407077','C4 LS350PU','A8 920 015','A1 COF102126S','C9 71758747','A2 FI OP575','A3 BOS 0986452041','A2 J1314013','B7 HO-823/KAVO','C9 LS489A','A1 W610/6','A3 KAP MO-511','C9 31-143220006','C9 0986452041','B1 BOS0986452061','B7 10316/JAPKO','A2 J1313016','A8 907 970','B7 10599/JAPKO','A1 10-03-316ASK','B1 VAL586062','A1 WOF258','A8 370 624','B7 1118502200/JP','A2 SF OF0063','B7 H90W25','C9 OF-934','A2 OC115','C4 0986452061','A3 VAC V24-0018','A3 BOS 0986452061','A1 50013146','A5 44074','B7 SM104','C4 OC 617','A8 318 339','B7 MO-511/KAVO','B1 BOSF026407077','B7 SM121','A5 82995','A8 349 237','A1 W610/3','A1 W814/80','A1 WOF191','A2 W610/3','A2 W814/80','A5 202446','A5 208501','A8 302 460','A9 W610/3','A9 W814/80','B1 MANW610/3','B1 MANW814/80','B1 VAL586060','B7 W610/3/AG','C4 O0537DREIS','C4 W 610/3','C4 W 814/80','C9 W610/3','C9 W814/80','D1 BP ADH22114')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #