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 ('C9 FO-901S','A3 JAP FO-914S','A3 JAP FO-502S','A3 FLT OP617','A8 919 462','C4 W 811/80','A2 0986452036','B7 OP617/AG','C4 H13W01','C9 H13W01','A8 370 382','A1 10-09-914ASK','A9 OC617','A2 UFI 23.461.00','C9 FO-703S','A3 JAP FO-503S','C9 FO-914S','A5 30171','C9 0986452016','C9 W811/80','C4 S 3485 R','A2 W8017','B7 OP 617/1/IP','A1 J1317003HB','A9 UFI 23.485.00','B7 OP617/1/AG','A3 MNN W811/80','B7 W811/80/AG','C9 H20W07','A5 30173','B1 FTROP617/1','A8 365 855','A5 30160','A1 J1314010HB','C9 FO-706S','A1 0986452907','A8 313 537','C9 0451103316','A1 0986AF1034','A2 UFI 23.485.00','A9 FI OP617','A8 926 772','A3 BOS 0986452016','A1 10-05-510ASK','C4 S 6900 R','A5 174793','A1 10-09-901ASK','A3 JAP FO-307S','A1 0986452059','C9 LS489A','A9 UFI 23.271.00','A5 272918','A3 JAP FO-510S','B1 BOS0986452016','A1 10-05-502ASK','C9 DO828','B7 OP 617/IP','B1 MANW8017','C9 DO324','A1 10-03-321ASK','A9 0451103316','A1 0451103316','C4 O0650DREIS','A1 0986452036','B1 PURLS489A','A5 206439','A2 0451103316','B1 BOS0451103316','A2 FI OP617/1','A9 FI OP617/1','A3 JAP FO-706S','A3 JAP FO-321S','A5 30174','A5 40935','A8 373 761','B7 H20W07','A3 MHL OC617','A3 BOS F026407124','A5 44645','A1 F026407124','A2 W811/80','A1 OC617','A1 J1314012HB','A1 10-03-307ASK','A9 W8017','C9 F026407124','A8 365 590','C9 DO205','A2 UFI 23.271.00','A5 202470','C9 FO-321S','A8 921 238','B1 MANW811/80','A3 FLT OP617/1','A9 W811/80','A3 JAP FO-703S','A8 300 100','A9 0986452036','A1 W8017','A5 432468','C4 W 8017','A8 318 852','A9 F026407124','C4 S 6902 R','C4 F026407124','C9 FO-502S','C4 0986452036','A1 WOF306','A1 J1315015HB','C9 FO-599S','A9 UFI 23.165.00','C4 S 3258 R','A1 0986452008','A8 920 092','A1 0986452916','A8 320 521','C9 FO-510S','A3 BOS 0986452036','C9 DO912','A2 FI OP617','C4 OC 617','C4 0451103316','C9 W8017','A1 0986452016','B1 BOS0986452036','A3 BOS 0451103316','C9 0986452036','C4 986452061','A1 W811/80','A9 0986452016','A2 F026407124','A8 314 274','A3 JAP FO-901S','A2 UFI 23.165.00','C9 FO-503S','A8 326 211','A2 0986452016','B7 H13W01','B1 HENH13W01','B1 BOSF026407124','A1 0986452007','C4 LS489APU','A1 LS489APU','A9 UFI 23.461.00','A2 OC617','A8 313 523','A1 10-07-703ASK','A1 10-03-306ASK','A3 BOS 0986452916','B1 FTROP617','A1 0986452908','C4 S 6901 R','C9 FO-307S','A3 JAP FO-599S','A1 H90W25','A1 J1314018HB','A1 W610/6','A1 W814/80','A1 WOF191','A1 WOF197','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 38819','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 VAL586060','B1 VAL586062','B7 A210021/DKM','B7 A210023/DKM','B7 H90W25','B7 HO-823/KAVO','B7 MO-429/KAVO','B7 OP557/AG','B7 SM104','B7 SM124','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')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #