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.165.00','A5 202470','A1 0986452036','A3 MHL OC230','C9 0986452016','A1 F119','B1 BLPADG02144','C9 FO-502S','A2 UFI 23.461.00','A2 MW810','A3 MHL OC1254','C9 W8017','A8 370 382','C9 W811/80','A3 MNN W815/80','B1 BLPADC42112','E6 FL1052','A8 318 255','C4 S 6902 R','A2 W815/80','C9 ADZ92113','A3 BOS 0986452036','A3 FLT OP555/1','A8 358 665','C4 S 3485 R','A2 OC1254','A2 W8017','D1 BP ADH22114','A1 W811/80','A9 FI OP617/1','A1 0986452907','B1 VAL586062','A9 F026407124','C9 DO912','A8 926 772','A1 J1313002HB','C9 ADG02144','A1 0451103316','A8 313 523','A3 MHL OC1255','C9 ADZ92102','B1 BLPADZ92113','A8 361 750','C9 H13W01','A1 0986AF1034','B1 MANW811/80','A1 0986452916','A1 0986452059','D1 BP ADZ92113','A1 0986452007','C9 DO324','A1 F113','A5 30173','A3 JAP FO-914S','C9 ADH22114','C9 FO-706S','A5 40935','A9 MW810','A3 FLT OP558/1','A9 UFI 23.271.00','B1 BLPADM52101','A3 JAP FO-503S','A9 OC230','A2 0986452036','A3 BOS 0986452916','A5 13603','A1 OC1255','C9 LS489A','A1 F108','C4 S 6901 R','B1 BOS0986452016','A1 OC205','B1 BLPADS72101','A1 J1314012HB','A3 FLT OP536','A3 MHL OC115','A3 JAP FO-307S','A8 326 211','A1 J1317004HB','C4 0986452036','A2 UFI 23.485.00','A9 OC205','A2 OC1255','A1 F122','A3 JAP FO-706S','A1 LS489APU','A3 JAP FO-510S','A8 300 100','A1 F116','B1 HENH13W01','A3 MNN MW810','A1 MW810','E6 FL1151','C4 986452061','A9 UFI 23.485.00','A5 272918','E6 FL1037','C9 FO-503S','A3 BOS 0451103316','C9 F026407124','A8 360 056','A3 MHL OC1673','A2 OC115','B1 BOS0451103316','E6 FL1199','B1 BOS0986452036','A9 0986452036','A1 OC1026','A3 MHL OC500','C4 S 6900 R','A3 JAP FO-502S','C4 0451103316','C9 DO205','A9 UFI 23.159.00','D1 BP ADZ92102','A1 OC113','A3 JAP FO-703S','D1 BP ADC42112','A8 920 092','A1 OC 205','A1 OC500','C9 FO-307S','B1 FTROP536','A1 OC1254','A3 JAP FO-321S','C4 S 3258 R','A8 921 238','A8 313 537','A8 919 462','A3 JAP FO-901S','A3 BOS 0986452016','A2 OC205','C9 FO-703S','A1 J1317003HB','C9 0451103316','A1 10-05-510ASK','A9 W8017','A1 J1314010HB','A3 MNN W811/80','A2 OC1673','A2 UFI 23.271.00','A2 OC500','A5 174793','A9 UFI 23.461.00','C9 FO-510S','A1 10-03-321ASK','A9 0451103316','A2 OC230','D1 BP ADM52101','A8 365 590','A1 W815/80','D1 BP ADC42103','A1 WOF306','A1 WOF120','A8 365 855','A8 920 430','C4 LS489APU','C9 ADM52101','A8 373 761','A1 F026407124','B7 OP 558/1/IP','B1 MANMW810','E6 FL1214','A1 0986452008','B1 VAL586017','C4 W 811/80','A1 0986452908','B1 FTROP617/1','C9 F026407325','D1 BP ADG02144','A5 432468','C4 OC 205','B1 FTROP555/1','B1 BOSF026407325','A9 OC500','A8 314 274','A1 10-09-914ASK','A9 OC1673','A3 JAP FO-599S','A2 FI OP536','B1 MANW8017','A9 0986452016','C9 FO-901S','A8 318 757','E6 FL1157','A2 FI OP617/1','A1 0986452016','A9 W811/80','B7 OP 617/1/IP','A1 OC115','A3 MHL OC205','A2 UFI 23.583.00','A3 BOS F026407124','B7 OP617/1/AG','A1 J1313030HB','A9 OC1254','A8 318 852','C9 0986452036','A1 10-07-703ASK','C9 FO-599S','B1 MANW815/80','A1 J1315015HB','A5 30171','C9 W815/80','B1 VAL586016','A1 L117','A8 908 794','C9 DO828','B7 H20W07','A5 385474','A5 27488','A1 J1313015HB','B1 BOSF026407124','C4 OC 115','C9 ADC42112','A9 OC115','B7 TO-149/KAVO','A8 358 664','A2 UFI 23.159.00','A2 W811/80','A1 10-09-901ASK','B1 FTROP558/1','C4 O0650DREIS','A1 10-03-307ASK','A1 W8017','B7 H13W01','A9 FI OP536','A2 F026407124','A5 27476','C4 MW 810','A1 OC1673','B1 BLPADC42103','A3 MHL OC1026','C9 MW810','C9 ADC42103','C9 FO-914S','A8 311 443','B7 OP 536/IP','C9 H20W07','A1 F208','A1 10-03-306ASK','A1 OC230','A1 10-05-502ASK','C4 W 815/80','B1 BLPADH22114','B7 W811/80/AG','A9 UFI 23.165.00','A1 J1314018HB','C4 F026407124','A5 30174','C4 H13W01','B1 BLPADZ92102','A2 0986452016','A2 0451103316','A5 44645','A5 30160','A9 UFI 23.583.00','C9 FO-321S','A1 OC 230','A3 FLT OP617/1','B1 PURLS489A','A8 360 033','D1 BP ADS72101','C4 W 8017','C9 ADS72101','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)) #