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 MHL OC1673','A8 920 430','C9 FO-599S','A2 0451103316','A1 0986452007','A3 MHL OC1254','B1 BLPADH22114','B1 PURLS489A','B1 FTROP536','C4 S 6900 R','C9 0986452016','A1 0986452907','A1 OC230','A3 JAP FO-914S','A3 BOS 0451103316','A9 UFI 23.485.00','C4 O0650DREIS','A5 13603','A1 J1314010HB','C9 FO-503S','A3 JAP FO-502S','A1 W811/80','A3 MHL OC1026','B1 FTROP617/1','A8 311 443','C9 FO-914S','A1 F026407124','E6 FL1151','A1 OC205','D1 BP ADS72101','B1 BLPADC42112','A8 365 855','C9 FO-510S','A8 926 772','A2 OC500','A3 JAP FO-307S','A2 OC115','A5 202470','C9 DO205','A5 40935','C9 ADG02144','A3 JAP FO-706S','A8 318 852','A1 10-03-307ASK','A3 FLT OP555/1','C4 F026407124','A2 UFI 23.583.00','A2 OC1255','A1 0986452016','C9 FO-321S','A5 30173','B7 OP 558/1/IP','D1 BP ADH22114','C4 H13W01','A1 OC500','A1 OC1254','B7 H20W07','B7 H13W01','B1 HENH13W01','C9 ADS72101','E6 FL1214','A1 J1317003HB','A1 OC1026','E6 FL1157','A1 0986452908','A5 44645','A3 MHL OC205','A1 0986452008','A1 OC113','A1 WOF306','A1 LS489APU','A8 360 056','D1 BP ADC42112','A2 W8017','A3 FLT OP617/1','D1 BP ADG02144','A1 10-03-321ASK','A9 FI OP617/1','C4 986452061','B7 W811/80/AG','A1 J1314012HB','A3 MHL OC1255','A9 MW810','A1 OC115','C9 DO912','A5 174793','C4 0986452036','A3 MHL OC500','A1 OC 205','A2 OC1673','A1 W8017','A9 OC230','A1 0986452059','B1 BLPADC42103','A9 OC115','B1 BOS0451103316','A2 OC1254','B1 FTROP558/1','C9 ADC42103','B7 OP 536/IP','A2 MW810','A1 J1315015HB','A1 0986AF1034','A5 30171','B1 BLPADS72101','A2 OC230','A1 F116','A3 MNN MW810','A8 365 590','A8 370 382','A2 UFI 23.165.00','E6 FL1199','A9 UFI 23.583.00','A8 313 523','A1 OC 230','C4 OC 205','A3 BOS F026407124','A5 30174','D1 BP ADM52101','B1 BOS0986452016','B1 BLPADZ92102','A3 JAP FO-510S','A3 JAP FO-901S','A8 920 092','A2 UFI 23.271.00','A1 F119','C9 F026407325','C9 ADZ92113','A1 W815/80','C9 0451103316','A3 BOS 0986452016','A5 385474','A1 J1314018HB','A9 UFI 23.271.00','A3 JAP FO-599S','A9 W8017','D1 BP ADC42103','C9 DO324','C4 OC 115','A2 UFI 23.159.00','C4 S 6902 R','A1 0451103316','C4 S 3485 R','A8 373 761','C9 H13W01','A2 OC205','C9 MW810','A8 314 274','C9 W815/80','A8 326 211','A8 919 462','A2 W811/80','A9 UFI 23.159.00','A9 FI OP536','C4 S 6901 R','A1 10-09-901ASK','A3 BOS 0986452036','A1 10-03-306ASK','C4 W 811/80','B7 TO-149/KAVO','A1 0986452036','A1 WOF120','A2 FI OP536','A1 J1313002HB','A3 FLT OP558/1','A3 MHL OC230','A8 360 033','C9 W8017','A8 313 537','C9 FO-307S','C9 ADC42112','B1 BLPADZ92113','A1 0986452916','A9 OC1254','C4 W 815/80','B1 VAL586017','B7 OP 617/1/IP','A2 F026407124','A1 F113','A3 JAP FO-703S','C9 FO-502S','A9 0451103316','A1 J1313030HB','C9 ADZ92102','A8 908 794','E6 FL1037','A9 0986452016','A1 J1313015HB','A1 L117','B1 MANW8017','C9 0986452036','A9 UFI 23.461.00','A1 F122','A8 300 100','C9 ADM52101','B1 BLPADM52101','A5 30160','B1 VAL586016','A1 10-05-510ASK','B1 MANMW810','D1 BP ADZ92102','A2 0986452036','C9 FO-703S','A9 OC1673','B7 OP617/1/AG','A2 FI OP617/1','A8 358 665','C9 H20W07','C4 W 8017','A1 10-09-914ASK','C9 F026407124','C4 S 3258 R','A3 MNN W811/80','C9 FO-706S','B1 FTROP555/1','C9 W811/80','A3 FLT OP536','A1 J1317004HB','C4 MW 810','B1 MANW815/80','A1 MW810','B1 MANW811/80','A1 10-07-703ASK','A3 BOS 0986452916','C9 DO828','A2 W815/80','A5 27476','A1 F208','A9 OC500','A3 MHL OC115','A3 MNN W815/80','A5 27488','A2 UFI 23.485.00','B1 BLPADG02144','C4 0451103316','A9 F026407124','A3 JAP FO-321S','B1 BOSF026407325','A3 JAP FO-503S','C9 ADH22114','A9 W811/80','A8 921 238','C9 LS489A','A1 OC1673','A9 0986452036','A8 318 757','D1 BP ADZ92113','A9 OC205','A5 272918','A2 UFI 23.461.00','B1 BOSF026407124','C9 FO-901S','A1 OC1255','A1 F108','A5 432468','A1 10-05-502ASK','A2 0986452016','A9 UFI 23.165.00','A8 361 750','B1 VAL586062','C4 LS489APU','B1 BOS0986452036','E6 FL1052','A8 318 255','A8 358 664','A1 F110','A1 H90W25','A1 H97W06','A1 J1311018HB','A1 J1313016HB','A1 W610/6','A1 W814/80','A1 WOF191','A1 WOF197','A2 FI OP557','A2 FI OP575','A2 FI OP617','A2 J1313002','A2 J1313015','A2 J1314010','A2 J1314012','A2 J1315015','A2 J1315025','A2 J1317004','A2 J1319006','A2 SF OF0054','A2 SF OF0063','A2 W610/6','A2 W814/80','A3 FLT OP557','A3 FLT OP575','A3 FLT OP617','A3 JAP FO-313S','A3 JAP FO-705S','A5 208501','A5 30162','A5 30187','A8 318 330','A8 318 339','A8 320 521','A8 349 237','A8 919 224','A9 J1313002','A9 J1313015','A9 J1314010','A9 J1314012','A9 J1315015','A9 J1315025','A9 J1317004','A9 J1319006','A9 SF OF0054','A9 SF OF0063','A9 W610/6','A9 W814/80','B1 CHACOF100110S','B1 CHACOF100116S','B1 FTROP557','B1 FTROP575','B1 FTROP617','B1 HENH90W25','B1 KAMF104701','B1 KNEOC1673','B1 KNEOC205','B1 KNEOC230','B1 MANW610/6','B1 MANW814/80','B1 VAL586021','B1 VAL586060','B7 A210023/DKM','B7 A210039/DKM','B7 H90W25','B7 H97W06','B7 HO-605/KAVO','B7 HO-701/KAVO','B7 MO-429/KAVO','B7 OP557/AG','B7 SM104','B7 SM121','B7 SM124','C4 H90W25','C4 H97W06','C4 J1313002','C4 J1313015','C4 J1314010','C4 J1314012','C4 J1315015','C4 J1315025','C4 J1317004','C4 O0539DREIS','C4 W 610/6','C4 W 814/80','C9 FO-313S','C9 OF-0410','C9 OF-919','C9 OF-934','C9 W610/6','C9 W814/80')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #