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 ('D1 BP ADL142102','C4 LS225PU','B7 H97W05','B1 FTROP575','B7 W610/3/AG','B1 KNEOC196','B1 BLPADC42116','A1 WOF197','A3 BOS F026408721','A2 UFI 23.265.00','A5 372329','A2 586013','C9 ADL142102','D1 BP ADM52107','A8 318 761','A8 312 866','C9 LS225','B1 KNEOC617','E6 FL1211','A1 10-03-316ASK','A1 J1311019HB','A9 W610/3','A1 WOF131','D1 BP ADN12111','C9 LS910','B1 MANW610/6','B1 MANW610/3','C4 W 610/3','A8 302 460','B1 PURLS287','A3 MNN W610/3','A5 44074','A1 0451103364','C4 LS287PU','B1 BOS0986452041','C9 50013109','A2 FI OP545/2','A2 0986452041','A5 288090','C9 SP-989','B1 BLPADN12111','C4 S 3265 R','C9 ADN12111','B1 CHACOF102126S','B7 OP 545/2/IP','A1 10-04-410ASK','A8 368 390','C4 S 4030 R','A5 23607','A9 OC196','A9 W610/6','A3 MHL OC196','C9 LS287','A1 LS287PU','B1 VAL586013','A1 0986452041','C9 W610/6','C9 0986452041','A9 FI OP575','A2 OC196','A9 H97W05','A1 OC196','A9 UFI 23.438.00','A2 W610/6','C4 LS910PU','C4 O0539DREIS','C4 O0537DREIS','A1 W610/6','A1 WOF258','A5 202446','A1 LS910PU','A2 FI OP575','B7 OP545/2/AG','A3 BOS 0986452041','A2 H97W05','A9 UFI 23.265.00','B1 FTROP545/2','A8 374 429','B1 KNEOC986','C9 DO925','A1 COF102126S','A1 LS225PU','A8 318 339','C9 DO895','A8 370 624','A8 360 406','C9 W610/3','A1 W610/3','B1 BLPADM52107','A3 FLT OP575','D1 BP ADC42116','A5 174791','A2 W610/3','E6 FL1222','A8 920 549','C4 H97W05','B1 HENH97W05','B7 OP575/AG','B1 BLPADL142102','C9 SP-919','C4 W 610/6','A1 H97W05','C4 OC 196','A3 BOS 0451103364','A5 496739','B1 PURLS225','A8 349 237','A9 FI OP545/2','C9 H97W05','A1 10-01-198ASK','C9 SP-1094','A1 J1313002HB','A9 0986452041','C9 ADM52107','E6 FL1045','A1 F026408721','A3 FLT OP545/2','A2 UFI 23.438.00','A8 365 906','A8 326 553','C9 ADC42116','A5 82995','A1 J1313016HB','B7 OP 575/IP','C9 DO912','B1 KNEOC259','B1 PURLS910','C4 0986452041','A3 MNN W610/6','A1 32100 FE','A1 W67/1','A1 WOF189','A2 FI OP595','A2 SF OF0054','A2 SF OF0066','A2 W67/1','A3 FLT OP595','A3 JAP FO-120S','A3 JAP FO-313S','A3 JAP FO-314S','A3 JAP FO-316S','A3 JAP FO-410S','A3 JAP FO-502S','A3 JAP FO-510S','A5 202448','A5 30162','A5 30171','A5 30172','A5 30173','A5 35782','A5 37986','A5 38819','A8 300 080','A8 318 352','A8 360 886','A9 SF OF0054','A9 SF OF0066','A9 W67/1','B1 BLPADH22114','B1 BLPADM52106','B1 BLPADN12112','B1 FEB104333','B1 FEB32099','B1 FTROP595','B1 KAMF113501','B1 MANW67/1','B1 VAL586022','B7 A210021/DKM','B7 A210159/DKM','B7 MO-511/KAVO','B7 OP595/AG','B7 SM104','B7 SM134','B7 W67/1/AG','C4 W 67/1','C9 2143220008','C9 ADH22114','C9 ADM52106','C9 ADN12112','C9 FE32099','C9 FE32100','C9 FO-120S','C9 FO-313S','C9 FO-314S','C9 FO-316S','C9 FO-410S','C9 OF-0410','C9 OF-1094','C9 W67/1','D1 BP ADH22114','D1 BP ADM52106','D1 BP ADN12112','E6 FL1015','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #