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 ('A1 LS892PU','B1 VAI32-0017','A1 OC982','A2 OC277','A3 MHL OC982','A1 WOF191','C4 W 814/80','A8 360 056','A1 OC138','A8 300 081','A8 318 852','A8 373 839','A3 BOS 0986452036','A3 FLT OP558/2','B1 BLPADC42104','A1 0986452020','D1 BP ADM52101','A5 30105','B1 PURLS892','A2 0986452006','B1 KAMF102001','B7 A210023/DKM','B1 MANW814/80','C9 ADS72105','B1 PURLS225','C9 35-143220006','A8 365 888','B7 1218502509/JP','C9 50013146','A8 361 017','A3 MNN W814/80','A3 MHL OC138','B1 FTROP558/2','A3 BOS 0986452020','A1 W7037','B1 KNEOC138','D1 BP ADS72105','B1 KAMF118401','A2 UFI 23.243.00','B7 MO-431/KAVO','A8 924 016','B7 10503/JAPKO','C9 DO289','C4 LS489APU','C9 FO-503S','A5 208501','B7 OP558/2/AG','A5 287946','A3 VAC V32-0017','B7 H90W25','A3 VAC V26-0012','A1 LS225PU','A2 OC982','A1 0986452036','C4 H90W25','A3 BOS 0986452006','A5 40935','B1 HENH90W25','A3 BOS F026407104','A1 F026407104','B1 BLPADS72105','C9 ADC42104','B7 1218501100/JP','C9 H90W25','B1 MANW7037','A2 J1313002','B7 1218501109/JP','A2 0986452020','C9 31-143220005','A9 UFI 23.272.00','B7 H20W05','A9 UFI 23.243.00','B1 BOS0986452036','A2 FI OP558','C9 0986452036','B1 HENH411W','A9 0986452036','A1 50013146','A2 H90W25','B7 OP 558/IP','B1 KNEOC982','A5 30174','A2 W814/80','B7 MO-523/KAVO','A9 FI OP558','A2 0986452036','A1 H90W25','A1 LS489APU','C4 H411W','C9 0986452020','C9 0986452006','C9 LS489A','C9 LS892','A5 174793','A3 KAP MO-523','B7 SM124','B7 OP 558/2/IP','B1 FTROP558','B7 A210110/DKM','A2 OC138','A3 FLT OP558','A1 WOF379','A8 318 364','B1 KNEOC277','A8 313 523','A2 W7037','A2 N1317010','B1 BOS0986452020','C4 F026407104','C9 OF-4004','B1 PURLS489A','C4 LS225PU','C9 ADM52101','B7 10406/JAPKO','B1 BLPADM52101','A1 0986452006','B1 VAL586060','C9 DO206','C9 W814/80','A1 OC277','A9 W7037','E6 FL1052','A5 174794','B1 PURLS964','C9 LS964','A9 OC982','A2 UFI 23.272.00','C9 FO-406S','C9 LS225','C4 OC 982','C9 SP-937','C4 0986452036','C9 SP-922','C9 W7037','C9 F026407104','A3 JAP FO-503S','C4 J1313002','C9 SP-919','B7 A210022/DKM','C4 LS892PU','A5 201882','A9 J1313002','A5 174791','C4 W 7037','A9 W814/80','A1 W814/80','A3 JAP FO-406S','B1 BOSF026407104','D1 BP ADC42104','A1 H97W05','A1 LS350PU','A1 OC196','A1 W610/3','A1 W610/6','A1 WOF131','A1 WOF197','A2 FI OP575','A2 H97W05','A2 J1313016','A2 OC196','A2 SF OF0054','A2 W610/3','A2 W610/6','A3 FLT OP575','A3 MHL OC196','A5 162212','A5 202446','A5 23607','A5 496739','A8 302 460','A8 318 339','A8 349 237','A9 J1313016','A9 OC196','A9 SF OF0054','A9 W610/3','A9 W610/6','B1 FTROP575','B1 KAMF113501','B1 KNEOC196','B1 MANW610/3','B1 MANW610/6','B1 PURLS350','B1 VAL586013','B7 A210021/DKM','B7 H97W05','B7 SM104','B7 W610/3/AG','C4 H97W05','C4 J1313016','C4 O0537DREIS','C4 O0539DREIS','C4 OC 196','C4 W 610/3','C4 W 610/6','C9 OF-0410','C9 OF-1094','C9 OF-919','C9 W610/3','C9 W610/6')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #