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 ('A5 40943','F2 1000743034','C9 SP-1137','B9 MAN W719/30','F4 KAOF101601','B9 MEY 1001150009','A2 0451103314','B7 1118501500/JP','B7 W719/30/AG','F4 MANW719/30(10)','C9 SP-978','A3 MNN W719/30','B1 TRU07.18.020','F4 BOFF026408902','C9 H14W27','A4 1118501500','F4 PURLS324','A2 SF OF0039','B1 HENH14W27','C6 000514','A9 UFI 23.436.00','B7 SM111','A3 MNN W719/5','C9 71758770','A5 40948','A2 0451103033','C9 100653756','A5 230705','A3 BOS F026408902','F4 JPG1118501500','B1 BOS0451103033','A5 13901','C4 LS324PU','C9 71758731','F4 BRSB18018','B1 JPN10F9053-JPN','F2 1000179703','C9 ADV182108','A3 MHL OC264','C4 0451103344','B1 CHACOF100183S','A2 30 92 2550','F4 BRSB19032','C4 H14W27','C9 0451103344','A2 W719/30','C9 LS324','A3 VAC V10-0950','A9 0451103344','B1 VAI10-0950','F4 BOF0451103033','C4 COF100183S','A2 UFI 23.436.00','C9 DO894','F2 1000280773','F4 VAL586029','A5 202465','C4 OC 264','B7 OP 526/1/IP','F4 FILOP526/1','C9 W719/5','A2 FI OP526/1','A2 11150060501','B1 MMW152071758770','B1 MANW719/5','A2 0451103344','F4 KBS50013529','B7 A210022-S/DKM','F4 MANW719/5','C4 O0625DREIS','A8 313 983','C9 OF-812','C9 OF-978','A8 365 947','A3 VAC V10-0320','A3 MNN W719/30(10)','F2 1001138044','A5 189436','F4 HENH14W27','B1 FTROP526/1','F2 1018863530','F4 KAOF100501','C4 W 719/30 SD','A3 BOS 0451103314','B1 BOS0451103344','B1 VAI10-0320','F2 1000327866','B7 A210022/DKM','E2 100 653 756','A8 338 885','F2 1000743028','F4 TOP100 653','B1 KNEOC264','F4 UFI23.436.00','B1 KAMF101601','A2 586029','F4 BOF0451103344','A3 FLT OP526/1','F2 1004032134','F4 MAD15002/9','C9 50013529','C4 F026408902','A9 W719/5','A9 11150060501','C9 0451103033','A9 SF OF0039','C4 0451103033','A8 302 048','C4 S 3291 R','B9 MAN W719/5','F4 WIXWL7071','F2 1000428589','C6 017157','A4 100 115 0009','A2 UFI 23.291.00','B1 VKA11150060501','A9 OC264','C4 O0618DREIS','B1 KAMF100501','A3 TRU 07.18.020','B1 MANW719/30','A8 312 788','A8 308 716','C4 W 719/30','A2 F026408902','A3 BOS 0451103033','B1 VAL586029','F4 MMA71758770','C4 W 719/5 (10)','B1 BLPADV182108','C4 W 719/30 (10)','B9 FLT OP526/1','A3 BOS 0451103344','B9 QWP WOF102','B1 VKA11150060001','A8 327 384','D1 BP ADV182108','A1 OC264','C9 F026408902','A9 FI OP526/1','B1 VKAK11783401','F4 DECA210022','C9 0451103314','C9 W719/30(10)','F4 KAVFOF-10195','A9 W719/30','C4 0451103314','B1 PPF1F0004','B1 PURLS324','F4 MAHOC264','C9 W719/30','F4 MANW719/30','C4 S 3436 R','C4 W 719/5','F2 1004032214','A2 OC264','A8 370 400','A8 359 288','C9 1001150009','A2 W719/5','B1 BOS0451103314','F4 MMA71758731','A9 0451103314','F4 BLPADV182108','B7 OP526/1/AG','C6 016004','A9 0451103033','F4 BOF0451103314','F4 SCTSM111','F4 VIK11150060501','B7 H14W27','B1 VAI10-3157')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #