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