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 J1314013','A2 UFI 23.265.00','C9 LS489A','A1 0986452041','A3 JAP FO-H05S','C4 O0539DREIS','B1 MANW610/6','A8 318 761','B7 A210021/DKM','A2 UFI 23.103.00','C4 LS910PU','C4 COF100128S','C9 2143220008','C4 J1313002','A9 FI OP575','A8 326 553','A2 FI OP632','A2 W7023','A8 370 624','A3 FLT OP575','A5 372329','E6 FL1037','A9 H97W05','A5 202446','C9 H97W05','B1 MISZ438','C9 LS350','A3 BOS 0451103364','A9 W610/7','B1 PURLS350','C4 S 6901 R','A9 0986452036','B7 W610/3/AG','A2 586013','A2 J1315024','B1 PURLS910','A1 WOF197','C4 W 610/7','A2 J1314010','A1 J1310507HB','B7 TO-149/KAVO','D1 BP ADS72101','C9 0986452036','C9 SP-960','C4 32100F','C9 SP-989','D1 BP ADL142102','C4 LS225PU','C9 DO324','A1 W610/3','A8 361 750','A9 UFI 23.103.00','A9 UFI 23.265.00','A1 W610/7','A8 914 400','B1 MANW7023','A2 UFI 23.159.00','A1 WOF380','A2 W610/7','A1 F208','A3 MNN W610/6','B7 A210021-S/DKM','C4 W 6019','C4 0986452036','B1 PURLS225','A1 0986452907','B7 OP 545/2/IP','A3 MNN W610/7','C4 F026407077','A1 LS490APU','A8 318 852','A3 VAC V24-0018','A9 F026407077','A1 10-03-316ASK','C9 LS490A','A2 J1314013','A9 W610/3','A1 F026407025','C9 FO-406S','A3 BOS 0986452041','A5 30117','A2 UFI 23.133.00','A1 J1313002HB','A1 WOF258','A1 W7023','A5 284765','A3 JAP FO-498S','A8 365 387','A8 349 831','A1 J1314013HB','A8 302 460','A1 J1313016HB','C9 W610/7','A8 907 970','B1 HENH97W05','A1 0986452059','A1 W610/6','C9 DO289','A8 371 115','A2 F026407077','A3 BOS 0986AF1061','C4 W 610/3','A1 F126','A1 LS287PU','A5 82995','A2 F026407025','A9 UFI 23.151.00','A9 F026407025','A2 W6019','C4 LS287PU','A9 N1317009','C9 ADH22114','A9 FI OP632','A2 UFI 23.151.00','C9 FE32100','A1 10-04-410ASK','B1 BLPADH22114','B1 MANW610/3','E6 FL1045','C9 DO912','C4 F026407025','A5 432473','C9 DO925/A','B1 PURLS489A','A1 COF102126S','C9 50013146','C9 F026407077','A5 30105','A1 H97W05','A1 LS910PU','C9 H97W02','B1 BOS0986452041','C4 H97W05','C9 W610/3','A5 496739','B1 BOS0986452036','A8 365 888','A1 W6019','A1 LS350PU','C9 0986452906','C9 FO-498S','C4 LS350PU','C9 SP-934','C9 SP-919','A1 J1311019HB','A5 288090','A5 174791','A5 44074','B7 OP575/AG','A1 0986452554','C9 W6019','A1 10-04-406ASK','A5 162212','B1 BLPADL142102','B1 BOSF026407025','C9 F026407025','A8 318 339','A2 W610/3','A3 FLT OP632','B1 MANW7040','A8 318 757','B1 PURLS287','A9 UFI 23.438.00','D1 BP ADN12111','B1 FTROP545/2','C9 ADN12111','B1 CHACOF100208S','E6 FL1211','A3 FLT OP545/2','A2 FI OP595/2','A2 FI OP545/2','C9 FO-H05S','B7 OP595/2/AG','B7 OP 558/1/IP','A2 0986452041','C9 LS910','C9 W7023','A9 J1314010','D1 BP ADM52107','A1 10-0H-005ASK','B1 VAL586062','A1 J1314010HB','A9 UFI 23.243.00','A1 0986452906','B7 OP 575/IP','C4 W 7040','C4 J1314010','B1 BLPADN12111','A5 80960','A8 920 549','C4 S 6900 R','C4 O0537DREIS','A1 0986452036','A3 JAP FO-198S','A5 75071','E6 FL1222','A9 J1313016','B1 BOSF026407077','C4 H313W','A1 32100 FE','C4 J1311019','B1 CHACOF102126S','C9 6143220000','C4 S 4030 R','A9 0986452041','A3 JAP FO-410S','C4 J1315024','C4 LS489APU','C9 FO-K02S','A2 UFI 23.243.00','C4 0986452041','A2 W610/6','A8 312 866','A3 FLT OP595/2','A8 313 523','C9 DO853/A','A5 174793','C4 J1313016','C9 0986452041','C9 50013109','B7 H97W05','A2 0986452036','A9 FI OP545/2','A9 FI OP595/2','E6 FL1151','A8 365 906','C9 37-143220005','A1 0451103364','A2 UFI 23.438.00','B1 VAI24-0018','B7 H313W','A1 50013146','B1 VAL586013','A3 VAC V26-0012','A8 360 406','A9 J1313002','B1 FEB32100','A8 378 828','C4 W 610/6','A9 UFI 23.133.00','B1 FTROP575','C9 31-143220006','B7 OP 595/2/IP','B1 BLPADM52107','B1 FTROP632','A2 FI OP575','C9 LS287','B1 MANW610/7','A1 LS225PU','A8 368 390','B1 MANW6019','A5 38819','A2 J1313016','A8 350 614','A8 365 829','C4 W 7023','C9 FO-410S','C9 LS301','B1 BLPADS72101','A9 W7023','A2 J1314010F','B7 OP545/2/AG','A3 JAP FO-406S','A2 J1313002','C9 ADM52107','C9 31-143220005','C9 SP-873','A1 10-01-198ASK','A1 W7040','C4 COF100208S','C9 DO895','A3 BOS 0986452554','B1 FTROP558/1','D1 BP ADH22114','A9 W610/6','A9 UFI 23.159.00','A9 W7040','C9 31-143220008','A9 J1314013','C9 ADS72101','B1 FTROP595/2','A1 LS301PU','A1 LS489APU','B1 HENH313W','A3 JAP FO-002S','A3 BOS 0986452906','A3 BOS 0986452036','C9 DO925','A2 N1317009','C9 W7040','A8 920 015','B1 CHACOF100128S','C9 FO-198S','B7 A210057/DKM','C4 S 3265 R','A1 0986AF1061','A1 10-04-498ASK','A3 FLT OP558/1','B1 PURLS301','A2 W7040','A3 BOS F026407077','C9 LS225','A3 BOS F026407025','A3 MNN W610/3','A3 JAP FO-K02S','A2 J1311019','A1 F026407077','A5 40935','A8 914 082','A8 349 237','C9 ADL142102','A1 J1314018HB','A8 370 542','A9 W6019','A9 J1311019','A2 H97W05','C9 SP-1094','C9 W610/6','A2 SF OF0054','A3 JAP FO-313S','A3 JAP FO-316S','A3 JAP FO-599S','A5 294014','A5 30160','A5 30162','A5 30172','A8 358 666','A8 360 056','A9 SF OF0054','B1 BLPADC42119','B1 BLPADG02109','B1 BLPADM52101','B1 BLPADM52105','B1 BLPADM52106','B1 FEB104333','B1 FEB109204','B1 KAMF101401','B1 KAMF113501','B7 SM832','C9 ADC42119','C9 ADG02109','C9 ADM52101','C9 ADM52105','C9 ADM52106','C9 FE109204','C9 FO-313S','C9 FO-316S','C9 FO-599S','C9 OF-0410','C9 OF-1094','D1 BP ADC42119','D1 BP ADG02109','D1 BP ADM52101','D1 BP ADM52105','D1 BP ADM52106','D1 BP ADS72106','E6 FL1015','E6 FL1052','E6 FL1062')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #