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 ('F4 FILOP629/1','F4 UFI23.416.00','B1 BOSF026407005','A3 MNN W712','F2 1004032162','A8 370 610','F2 1000740833','A5 44776','A3 FLT OP629T','F4 KAVMO-539','C4 F026407078','A5 206442','C9 W7127-12N','C9 DO261','F4 MMA71761637','C9 7143220010','C9 71760806','E2 300 058 756','C4 H97W07','A8 327 381','B7 A210006/DKM','A8 365 910','B7 MO-540/KAVO','C9 H97W07','A2 11150059801','C9 38813','B7 H90W22','C9 LS205','F4 UFI23.267.00','C4 W 712','A2 SF OF0126','A2 FI OP551','C6 000012','B1 VAL586023','B7 A210034/DKM','F4 MAHOC988','F4 WIXWL7074','F4 MAHOC1051','A2 UFI 23.267.00','A2 0451102056','B1 MANW7008','A3 HEN H90W12','B1 PPF1F0030','B9 MAN W712/43','C4 S 3416 R','B1 PURLS285','B7 SM196','C9 30-143220004','F2 1001692191','B1 PPF1F0023','B7 OP 629/IP','C9 H90W12','C4 OC 606','C4 W 7008','C4 0451103907','B1 BOS0451103298','B1 HENH319W','F4 BOF0451102056','A9 SF OF0126','B1 VAL586039','F4 HENH319W','F4 KBS50013099','A9 UFI 23.267.00','A8 365 937','B7 TO-138/KAVO','A2 OC21OF','F4 VAL586039','C9 F026407005','C9 OF-1067','B1 HENH97W07','A5 288070','B1 VKA11150059801','A2 OC981','A2 UFI 23.131.00','A9 OC606','A2 W7008','F4 KBS50013511','F4 MADFKFRD012','B9 FOR 1883037','B7 SM109','F4 PURLS934','A9 F026407005','F2 1004049582','B7 OP629/AG','B1 PPF1F0096','B1 KAMF102301','F2 1000325848','C4 F026407005','B1 FEB38813','B7 H315W','A9 F026407078','C4 LS285PU','F4 PURLS908','A9 OC988','F4 UFI23.103.00','A8 313 810','F4 MAHOC606','A2 F026407078','F4 DECA210006','F4 WIXWL7098','F2 1001845971','A9 W712/43','B1 FTROP629/1','B1 VAL586019','F4 VAL586019','B1 FTROP629','C4 S 3435 R','B1 VAI25-0103','B1 PURLS934','C9 DO215','A8 370 626','B9 FLT OP629T','A8 371 115','F4 MADFKVAG008','F4 KBS50013510','A9 OC21','A2 H97W07','C4 O0549DREIS','C9 LS908','B1 VAI25-0101','C4 OC 988','E9 38813','A8 365 946','F4 SCTSM196','A8 359 156','B7 H315WK','B7 H97W07','C9 W712/91','F4 SCTSM110','F2 1000951204','F4 KAVTO-138','F4 HENH90W12','F4 HENH90W19','A8 327 374','B1 BOSF026407078','C4 S 3413 R','F4 TOP300 029','A3 MHL OC988','B1 MANW712/43','B7 1118501200/JP','B7 W712/43/AG','F4 KBS50014566','B7 OP629/1/AG','F2 1000896837','B1 PURLS205','B9 MHL OC215','B1 VAL585657','F4 UFI23.413.00','F4 DECA210034','B1 PURLS908','F4 MMA71760806','F2 1001692190','C9 FE38813','F4 BOFF026407078','B1 JPN10F9073-JPN','B7 A210074/DKM','C9 0451103298','F2 1000823802','C9 LS188B','C9 H90W06','A3 BOS 0451103907','F4 FILOP551','B1 FASFT38088','A2 0451103907','F4 HENH97W07','F4 DECA210074','A5 373222','C4 H90W01','B1 FTROP551','B1 KNEOC606','A9 FI OP551','A3 MHL OC1051','F4 MAHOC981','A3 VAC V25-0145','B1 KNEOC21OF','A3 KAP TO-138','A2 OC606','A8 318 325','A8 353 103','A5 169850','A3 MNN W7008','F4 HENH90W01','A8 312 833','A2 H90W01','A8 920 551','A3 BOS F026407078','C9 H90W22','A3 MNN W712/43','C9 W712/43','B9 FLT OP629','B7 H90W12','C4 LS934PU','A5 230748','C9 LS934','A2 UFI 23.435.00','A8 370 544','C9 SP-892','A2 OC1051','A8 314 318','A2 OC21','F2 1000880115','F4 MADFKVAG013','F2 1019217075','C4 LS188BPU','F2 1004032209','A9 SF OF0078','A9 0451102056','A9 UFI 23.413.00','F4 JPG1118501200','F4 FILOP629','B1 JPN10F3016-JPN','A2 J1313021','C9 300029756','A3 VAC V25-0101','C4 S 8540 R','B7 OP 629/1/IP','A8 328 889','B7 OP 551/IP','F4 MANW7008','C9 OF-994','F4 KAOF102301','C4 S 9431 R','A3 BOS 0451103298','F2 1002996146','B9 MAN W7008','A5 206430','F4 SCTSM106','A2 SF OF0138','A9 UFI 23.416.00','C9 W712','F2 1009281668','A5 337788','B1 KAMF114401','F4 HENH315W','B1 BOS0451103907','C9 SP-1073','F4 UFI23.435.00','C4 W 7008 SD','F4 JPG1118504900','C9 0451102056','A9 UFI 23.188.00','F4 BOF0451103298','F4 BOFF026407005','F2 1000056345','A8 360 691','F4 KAOF114401','A8 370 601','B7 SM106','A3 FLT OP629','C9 OF-942','A9 FI OP629','C9 7143220001','A9 W7008','A8 302 051','B7 OP551/AG','A8 338 888','F2 1000740818','A2 W712/43','A9 11150059801','F2 1000344672','A2 586039','A2 UFI 23.103.00','B1 VAI25-0145','A5 40940','A5 189440','A2 UFI 23.416.00','C4 O0572DREIS','F2 1000281992','F2 1000814071','A9 SF OF0138','C4 W 712/43','B1 VAL586068','F2 1000556101','A9 UFI 23.435.00','F4 PURLS285','A8 389 804','C9 H90W19','C9 F026407078','A9 0451103298','B1 KNEOC988','A8 353 104','A8 348 232','A9 UFI 23.103.00','C9 W7008','C4 0451103298','A9 J1313021','B1 CHACOF100165S','F4 MAHOC21OF','F4 MAHOC21','A3 FLT OP629/1','F4 VAL586023','C9 LS922','B1 KNEOC21','F4 PURLS205','F4 TOP300 058','F2 1000533958','C9 71758709','F4 VIK11150059801','F2 1000857143','B1 HENH90W19','B1 HENH90W01','A9 OC21OF','C4 W 712/43 (10)','A2 OC988','A2 UFI 23.188.00','B7 H90W01','A5 43700','C9 300058756','C4 H315W','A2 W712','A3 BOS F026407005','C4 H90W19','F2 1001579715','C9 H90W01','B1 MANW712','B7 H90W19','A8 365 184','C9 OF-821','C4 LS205PU','A1 C165','B7 MO-539/KAVO','F4 BOF0451103907','C4 MO-540','C4 OC 21','B1 KAMF114501','A3 BOS 0451102056','B9 FLT OP629/1','F2 1000894124','A3 MHL OC981','C9 SP-945','F4 FASFT38085','F4 UFI23.131.00','A2 0451103298','A2 586023','C4 0451102056','B1 BOS0451102056','A2 SF OF0078','F4 MANW712','C4 S 4500 R','A3 VAC V25-0103','A2 UFI 23.413.00','B1 HENH90W12','F4 MAD15238/8','B9 MHL OC21','B7 SM110','B1 PURLS922','A9 UFI 23.131.00','C4 J1313021','A2 FI OP629','B1 KNEOC981','B1 JPN10F9117-JPN','C9 71761637','B1 KNEOC1051','C9 SP-1072','B1 PPF1F0114','A8 305 890','C4 COF100165S','F4 KAOF114501','F4 KAVFOF-10218','F4 MMA71758709','A3 MHL OC606','F4 MANW712/43','F4 PURLS188B','C4 OC 981','B1 HENH315W','A8 328 923','A9 W712','A8 365 941','A9 OC1051','F4 FASFT38088','C4 H319W','F4 JPG1518503700','F4 FEB38813','C4 OC 1051','A2 FI OP629/1','A3 MHL OC21','F4 MAD15583','C9 LS285','A9 FI OP629/1','C4 LS922PU','B1 PURLS188B','A9 OC981','F2 1009281800','F4 KAVMO-540','C9 SP-828','A8 365 824','C9 DO217','C4 LS908PU','C9 0451103907','A2 F026407005','A3 FLT OP551','F2 1001368856','A1 OC988','A3 MHL OC244','E6 FL1210','D2 WL7459','A2 J1312021','A1 W7008','A3 FLT OP618','A3 MNN W712/83','C4 J1312021','A1 WOF147','A3 JAP FO-279S','A5 43729','C4 FO-279SJAP','C4 W 712/83','C9 FO-279S','D2 FLT OP629/1','D2 OP629/1')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #