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