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 ('A3 MNN W814/80','C9 W814/80','A8 313 523','A2 0986452006','A8 365 888','A3 BOS 0986452036','A1 10-04-406ASK','C9 SP-934','C9 LS489A','A9 UFI 23.103.00','A2 W67/1','A8 300 081','A5 208501','B1 KNEOC115','A1 0986452906','A1 50013146','A2 UFI 23.243.00','C9 SP-919','A1 J1313002HB','A1 W67/1','B7 OP 558/1/IP','C4 0986452036','A2 UFI 23.103.00','C9 0986452036','A2 J1314012','A1 X118','A5 162212','A5 202448','B1 KNEOC205','B1 BOS0986452036','A5 40935','A9 UFI 23.243.00','C9 SP-960','C4 J1313002','A8 350 614','A3 BOS 0986452006','B7 OP 557/IP','A1 0986452059','C9 W67/1','C9 0986452906','A1 0986452036','A2 W814/80','A9 FI OP557','B1 BLPADH22114','C4 O0544DREIS','D1 BP ADH22114','C4 S 6900 R','B1 MANW67/1','A1 J1314013HB','A1 LS350PU','A8 365 829','A8 371 115','C4 F026407077','A9 0986452036','A3 JAP FO-703S','B7 OP557/AG','A5 30105','A1 LS490APU','B1 FTROP558/1','A9 W814/80','C9 LS490A','A8 920 015','A3 FLT OP558/1','C4 W 67/1','B1 PURLS350','B7 W67/1/AG','B1 PURLS489A','C4 J1314012','C9 FO-703S','C9 LS350','A9 UFI 23.133.00','E6 FL1151','A8 907 970','A8 300 080','A1 F026407077','A3 MNN W67/1','A2 J1314010F','B1 VAL586060','A9 J1314013','C4 W 814/80','A9 W67/1','A2 J1313002','A3 JAP FO-406S','A2 UFI 23.159.00','C9 ADH22114','A1 LS489APU','A2 0986452036','A2 J1314013','C9 DO289','A1 J1314010HB','A2 J1314010','B1 FTROP557','C4 LS350PU','A9 J1313002','A8 318 757','C9 FO-406S','A2 UFI 23.133.00','A9 J1314012','B1 VAL586062','A9 UFI 23.159.00','A3 BOS 0986452906','A2 FI OP557','A1 J1314018HB','C9 0986452006','A1 0986452006','B1 MANW814/80','A1 W814/80','A9 F026407077','A1 WOF191','A3 FLT OP557','C4 J1314010','A1 WOF189','C9 F026407077','C9 DO324','A1 10-04-498ASK','B1 BOSF026407077','A3 BOS 0986452554','A9 J1314010','A5 174793','A8 318 330','C4 J1314013','A8 318 852','C9 SP-873','A3 BOS F026407077','C4 LS489APU','C9 50013146','A2 F026407077','A1 0986452554','A1 0986452907','A1 32100 FE','A1 OC617','A1 W610/3','A1 W610/6','A1 WOF197','A2 FI OP575','A2 OC115','A2 OC617','A2 SF OF0054','A2 W610/3','A2 W610/6','A3 FLT OP575','A3 JAP FO-502S','A3 JAP FO-599S','A3 MHL OC115','A3 MHL OC617','A5 13603','A5 202446','A5 206439','A5 30160','A5 30171','A8 302 460','A8 318 339','A8 349 237','A8 360 033','A9 OC115','A9 OC617','A9 SF OF0054','A9 W610/3','A9 W610/6','B1 BLPADG02144','B1 BLPADM52105','B1 BLPADM52107','B1 FTROP575','B1 KNEOC617','B1 MANW610/3','B1 MANW610/6','B7 A210021/DKM','B7 A210023/DKM','B7 HO-823/KAVO','B7 SM124','B7 W610/3/AG','C4 O0537DREIS','C4 O0539DREIS','C4 OC 115','C4 OC 617','C4 W 610/3','C4 W 610/6','C9 31-143220006','C9 ADG02144','C9 ADM52105','C9 ADM52107','C9 FE32100','C9 FO-599S','C9 OF-0410','C9 OF-919','C9 W610/3','C9 W610/6','D1 BP ADG02144','D1 BP ADM52105','D1 BP ADM52107','E6 FL1045','E6 FL1062')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #