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 ('A2 UFI 23.461.00','F4 MAD15056','A8 920 430','F2 1001779232','A5 432468','C9 DO205','B1 VAI52-0131','B9 JAP FO-510S','B9 JAK J1317003','F2 1009329333','B9 JAK J1313016','A5 206439','A5 275609','F4 UFI23.485.00','F4 ASH10-05-502','F2 1001692200','A5 202470','A3 JAP FO-307S','F4 WIX51568','B1 FEB47474','C9 DO324','C9 FE32099','B9 PUR LS489A','F4 WIXWL7081','B1 BOS0986452036','C4 S 3485 R','A5 40935','F2 1003024098','F2 1001779381','B1 PURLS489A','A5 30171','F4 BOF0986452036','A3 FLT OP617','F4 WIXWL7512','A3 JAP FO-703S','B1 BOS0986452016','C4 S 6902 R','A8 365 855','A8 318 852','A5 44645','A3 VAC V52-0131','A8 919 462','C9 FE27155','A3 FLT OP617/1','A2 0451103316','C4 S 6900 R','A2 W8017','A5 174793','B1 VAI46-0083','A8 370 382','E9 32100','C4 S 6901 R','B7 W811/80/AG','F4 FEB32099','A8 920 549','A3 VAC V24-0018','A3 JAP FO-599S','A5 272918','C9 DO828','C9 DO912','F4 ASH10-03-306','F2 1000827645','A9 UFI 23.271.00','C9 FO-599S','A3 VAC V40-0089','C9 35-143220000','A3 VAC V46-0086','A9 W8017','A2 0986452016','A3 BOS 0451103316','A9 0986452036','C4 0986452036','C9 FO-510S','C9 31-143220006','B7 OP 617/IP','A2 0986452036','F2 1001692204','F4 ASH10-03-321','C9 35-143220002','A3 MNN W811/80','A8 926 772','C9 H13W01','F4 MAD15318/3','C4 27155F','C9 FO-914S','A8 921 238','A8 919 259','A8 314 274','A3 VAC V25-0144','C4 OC 617','E9 27155','A8 373 761','C9 H20W07','A3 JAP FO-901S','A2 UFI 23.485.00','F4 FILOP617','F4 ASH10-09-901','F4 UFI23.165.00','A3 JAP FO-502S','B1 FEB32099','F4 FEB27155','C4 32100F','B1 BOS0451103316','A5 30174','F4 FILOP617/1','C4 F026407124','C9 FO-901S','F2 1001356837','F2 1001059160','A9 W811/80','C4 LS489APU','B1 MANW811/80','E9 32099','B7 H20W07','F2 1004032105','C4 O0650DREIS','B9 MAN W8017','A9 UFI 23.485.00','C9 0986452016','A2 W811/80','C4 0451103316','A2 F026407124','C9 FO-321S','F2 1009329328','A2 UFI 23.271.00','F2 1001779379','F4 WIXWL7107','C9 6143220000','A3 VAC V46-0083','F4 HENH13W01','A5 234434','B1 FTROP617','B1 FEB32100','C4 986452061','C9 FO-503S','A9 F026407124','A3 VAC V40-0091','B7 OP617/AG','A3 BOS 0986452016','A3 BOS 0986452916','A2 UFI 23.165.00','B1 VAI46-0086','C9 LS489A','C9 FO-706S','F4 ASH10-03-307','B7 OP617/1/AG','B1 VAI42-0050','C9 W8017','A5 30173','B1 MANW8017','A8 320 521','F2 1000827770','F2 1000254999','A3 JAP FO-510S','C9 FE32100','F2 1011595350','C4 W 811/80','A2 FI OP617/1','A3 VAC V46-0084','F4 MAD15096/1','F2 1001368883','F4 PURLS489A','B7 H13W01','A8 313 537','F4 MAD15571','C4 H13W01','C9 FO-703S','A9 FI OP617/1','B7 OP 617/1/IP','F2 1003128117','A8 920 092','F2 1001462726','F4 FEB47474','B1 VAI25-0144','F2 1001369779','A3 VAC V46-0224','A9 0986452016','A9 UFI 23.461.00','C9 FO-307S','F4 MAD15131','B1 VAI40-0089','B1 VAI24-0018','A3 BOS 0986452036','C4 W 8017','A3 VAC V24-0047','B1 HENH13W01','A3 JAP FO-503S','F4 FEB184130','F4 UFI23.461.00','F2 1001437527','B1 VAI46-0224','A9 SF OF0063','F4 BOF0451103316','B1 VAI46-0084','A8 919 224','A9 0451103316','B1 VAI30-1338','A3 JAP FO-706S','A9 UFI 23.165.00','A3 JAP FO-321S','F4 ASH10-05-510','A8 313 523','A3 MHL OC617','C4 47474F','A5 30160','F2 1000743267','B1 VAI40-0091','B1 FTROP617/1','C4 S 3258 R','A3 JAP FO-914S','F4 FILOP633','B1 VAI24-0047','A3 BOS F026407124','F2 1001410126','A2 SF OF0063','C9 W811/80','F2 1004032115','F4 WIXWL7417','A9 FI OP617','A8 365 590','F4 UFI23.271.00','F4 MANW811/80','F2 1003073188','A2 OC617','B1 BOSF026407124','F4 BOF0986452016','A2 FI OP617','C9 FO-502S','A9 OC617','F2 1000831550','F4 MAHOC617','B9 MAN W811/80','A3 VAC V30-1338','A8 326 211','C9 0451103316','A3 VAC V42-0050','F4 FEB32100','B1 FEB27155','F2 1000287690','C9 0986452036','A8 300 100','C9 F026407124','F4 MANW8017','F4 BOFF026407124','D3 B14010JC','D3 B14010PR','D3 JAK J1314010','A2 FI OP557','A2 FI OP575','A2 OC115','A2 SF OF0054','A2 UFI 23.243.00','A2 W610/6','A2 W814/80','A3 FLT OP557','A3 FLT OP575','A3 JAP FO-410S','A3 MHL OC115','A5 13603','A5 208501','A5 230739','A5 38819','A8 300 081','A8 318 330','A8 318 339','A8 349 237','A8 360 033','A8 360 056','A8 361 017','A8 361 750','A8 365 888','A9 OC115','A9 SF OF0054','A9 UFI 23.243.00','A9 W610/6','A9 W814/80','B1 BLPADG02144','B1 BLPADH22114','B1 BLPADM52101','B1 BLPADM52105','B1 BLPADS72101','B1 BLPADS72105','B1 FTROP557','B1 FTROP575','B1 HENH90W25','B1 KAMF100301','B1 KAMF104701','B1 KAMF115501','B1 KNEOC115','B1 MANW610/6','B1 MANW814/80','B1 PPF1F0009','B1 PPF1F0058','B1 VAL586060','B1 VAL586062','B7 A210021/DKM','B7 A210023/DKM','B7 A210983/DKM','B7 H90W25','B7 HO-823/KAVO','B7 MO-429/KAVO','B7 OP557/AG','B7 SM104','B7 SM124','B9 FLT OP557','B9 FLT OP575','B9 MAN W610/6','C4 H90W25','C4 O0539DREIS','C4 OC 115','C4 W 610/6','C4 W 814/80','C9 ADG02144','C9 ADH22114','C9 ADM52101','C9 ADM52105','C9 ADS72101','C9 ADS72105','C9 FO-410S','C9 OF-0410','C9 W610/6','C9 W814/80','D1 BP ADC42103','D1 BP ADG02144','D1 BP ADH22114','D1 BP ADM52101','D1 BP ADM52105','D1 BP ADS72101','D1 BP ADS72105','E6 FL1037','E6 FL1052','E6 FL1062','E6 FL1151','E6 FL1199','F2 1000594945','F2 1000743272','F2 1001138071','F4 ASH10-04-410','F4 ASH10-05-599','F4 BLPADG02144','F4 BLPADH22114','F4 BLPADM52101','F4 BLPADM52105','F4 BLPADS72101','F4 BLPADS72105','F4 DECA210021','F4 DECA210983','F4 FEB183930','F4 FEB193871','F4 FILOP557','F4 FILOP575','F4 HENH90W25','F4 KAOF100301','F4 KAOF104701','F4 KAOF115501','F4 KAVHO-823','F4 MAHOC115','F4 MANW610/6','F4 MANW814/80','F4 MMA71758747','F4 SCTSM104','F4 UFI23.243.00','F4 VAL586062','C4 J1314010')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #