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 ('C4 W 712/43','B1 FTROP629/1','C4 H97W07','A8 365 184','B1 PURLS285','A1 LS922PU','B1 PURLS205','A9 OC1051','B1 KNEOC606','C9 FO-279S','A2 W712/43','C4 S 4500 R','C9 LS908','A1 38813 FE','C9 OF-994','B7 A210034/DKM','A2 UFI 23.188.00','C4 OC 606','A1 LS188BPU','A5 337788','A5 189440','B7 H315WK','A9 0451102056','A9 OC606','A1 C204','C4 F026407005','A1 OC606','C4 LS285PU','A1 C104','A3 FLT OP629','A8 353 103','A2 H97W07','A2 SF OF0078','C4 LS934PU','A1 WOF112','B1 HENH315W','C4 OC 988','B1 BOSF026407005','A2 OC21OF','C9 300029756','C9 FE38813','C4 H90W19','C4 H90W01','C9 H97W07','B1 CHACOF100165S','B1 KNEOC988','C9 W7008','A3 FLT OP629/1','A1 F026407005','A2 OC981','C4 W 712/43 (10)','A3 BOS F026407078','C4 LS205PU','B1 HENH90W19','B7 1118501200/JP','B1 BOS0451103907','C9 7143220001','C4 OC 981','A5 373222','B1 HENH97W07','C9 H90W01','A1 OC235','C4 W 7008 SD','B1 VAL586023','C9 OF-821','A1 OC21O.F.','C9 SP-945','C9 H90W12','A2 UFI 23.435.00','B1 FTROP551','C4 S 3435 R','A8 370 544','A2 F026407005','C4 OC 21','A3 MNN W712/43','A9 J1313021','C9 W712/43','B1 KNEOC21','C4 0451103298','A9 W7008','B1 PURLS934','A8 370 601','A2 UFI 23.131.00','C9 H90W22','C9 OF-1067','B7 H315W','B7 OP629/1/AG','B7 OP 629/1/IP','C9 F026407078','A8 360 691','A9 UFI 23.267.00','A9 UFI 23.103.00','A1 J1313021HB','C9 71760806','A8 318 325','A1 J1313022HB','C4 O0572DREIS','A8 365 946','A2 H90W01','A8 365 824','A2 0451103298','C4 F026407078','C6 000012','E2 300 058 756','A9 W712/43','A5 44776','A2 OC988','B7 A210006/DKM','B1 VAI25-0145','C4 S 3413 R','C4 H315W','B1 VAL586039','A9 SF OF0138','A3 MHL OC988','B7 TO-138/KAVO','C9 H90W06','A5 206430','B1 HENH90W12','A3 VAC V25-0103','A1 OC1051','B1 KNEOC21OF','C4 COF100165S','B1 KAMF102301','B7 SM110','A8 370 610','B1 MANW712/43','B1 VAL586019','B7 10279/JAPKO','A9 FI OP551','B7 H97W07','C9 DO217','A1 WOF123','C9 0451102056','C4 LS188BPU','B7 A210074/DKM','B1 FEB38813','B1 BOS0451103298','A1 OC981','A1 F026407078','A2 11150059801','D9 16510-60B11','A8 312 833','A2 W712','A3 VAC V25-0101','A9 FI OP629','A3 VAC V25-0145','A9 UFI 23.413.00','A9 OC988','C4 H319W','C9 W712','A8 313 810','A2 FI OP629/1','C4 MO-540','C9 LS922','A9 W712','A1 WOF147','A1 W712/43','A3 BOS F026407005','C9 300058756','A9 F026407005','B7 MO-540/KAVO','B1 BOSF026407078','A1 LS285PU','A3 BOS 0451103298','A9 F026407078','B1 KAMF114401','B1 FTROP629','A8 338 888','A9 OC21OF','B1 PURLS188B','A3 JAP FO-279S','C9 F026407005','A8 305 890','A1 0451103298','C9 0451103907','A1 0451102056','C9 SP-1072','A3 BOS 0451103907','A8 365 910','A2 SF OF0138','B7 SM109','B7 H90W12','C9 71761637','A1 W712','B7 A210070/DKM','C4 0451103907','B1 KNEOC1051','A9 SF OF0078','A8 348 232','A5 206442','B7 OP551/AG','A2 UFI 23.413.00','A2 OC21','B1 VKA11150059801','A9 FI OP629/1','A5 40940','A9 SF OF0126','B1 VAI25-0103','A9 UFI 23.435.00','B7 SM196','A8 920 551','C4 S 9431 R','B1 VAL585657','A9 UFI 23.131.00','A5 288070','C4 S 8540 R','C9 DO261','A1 C165','C4 O0549DREIS','A9 UFI 23.416.00','A5 43729','B1 KNEOC981','B1 PURLS922','A3 FLT OP629T','A3 BOS 0451102056','C9 LS285','A1 LS908PU','A2 0451103907','A1 OC988','A1 OC21','C4 S 3416 R','C4 OC 1051','A8 353 104','C4 LS908PU','A8 371 115','A1 C20480102000/GRX','A2 OC606','A2 OC1051','A9 11150059801','A3 MNN W7008','A8 389 804','B7 H90W01','C9 LS188B','A2 J1313021','A3 MHL OC981','A2 UFI 23.267.00','A8 365 941','A2 SF OF0126','A2 W7008','B7 H90W22','A2 586039','A3 MHL OC606','A1 WOF256','A9 OC981','C4 J1313021','A1 LS205PU','A2 FI OP551','A1 LS934PU','B1 HENH319W','A2 UFI 23.416.00','B1 BOS0451102056','A8 370 626','B1 HENH90W01','A2 F026407078','A5 43700','A2 UFI 23.103.00','A2 FI OP629','A9 UFI 23.188.00','C9 7143220010','C9 SP-1073','A3 KAP TO-138','A3 HEN H90W12','B7 OP 629/IP','A1 W7008','C9 LS205','A8 359 156','C4 W 712','C9 DO215','D9 16510-60B11 50db','A2 586023','C9 OF-942','B1 VAI25-0101','A1 0451103907','A3 MNN W712','A3 MHL OC21','B7 OP 551/IP','B1 MANW7008','C9 71758709','A2 0451102056','A8 302 051','A8 314 318','B7 W712/43/AG','C4 W 7008','C4 LS922PU','A5 169850','D9 16510-60B11 10db','B7 MO-539/KAVO','C9 SP-828','B7 H90W19','A3 FLT OP551','C4 0451102056','C9 30-143220004','C9 LS934','B1 PURLS908','A9 0451103298','A9 OC21','C9 SP-892','C9 H90W19','B1 VAL586068','A3 MHL OC1051','B1 KAMF114501','B1 MANW712','A8 365 937','C9 0451103298','B7 OP629/AG')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #