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 ('A5 44645','B1 PURLS225','B7 10599/JAPKO','A3 KAP MO-429','B7 10410/JAPKO','A2 OC1566','C9 FO-313S','A3 MNN W815/80','C9 H97W08','A1 WOF279','A8 312 856','A1 LS892PU','C4 LS225PU','C9 W815/80','C9 DO328','C4 W 811/80','A2 FI OP595','A3 MHL OC1673','A8 370 382','C9 0451103275','A1 F026407209','A8 365 902','C9 34-143220002','A3 MNN W87','B7 HO-823/KAVO','A3 BOS F026407209','C4 J1317003','C9 DO854/A','A2 W815/80','A1 LS301PU','A3 KAP FO-011A','A3 MHL OC1566','B1 KAMF117201','B1 KAMF104701','A2 J1317003','A5 385474','A8 370 625','B1 PURLS301','C4 LS892PU','C4 J1317004','A1 0451103292','C9 0451103316','A1 10-05-599ASK','B7 OP 643/6/IP','A5 40942','A3 BOS 0451103275','C9 W811/80','A3 BOS 0451103316','B7 MO-429/KAVO','A9 F026407209','A1 OC1673','C9 OF-934','A2 J1311026','C4 OC 1566','C9 OF-1465','B1 BOSF026407209','C9 LS301','A9 UFI 23.271.00','A8 365 336','A8 318 255','B7 SM832','B1 KAMF103301','A2 J1317008','B7 OP 536/IP','B1 MANW87','A1 J1317005HB','C9 SP-1465','B7 10705/JAPKO','A2 OC1052','B1 HENH97W06','A3 FLT OP643/6','A9 0451103275','A5 410733','C4 CFF100104','C9 OF-946','A3 FLT OP536','A3 KAP NO-2223','A3 MHL OC1052','C9 LS965','A9 UFI 23.259.00','A3 BOS 0451103292','A1 W87','A9 W811/80','C9 FO-502S','A8 314 274','A1 OC1052','A3 JAP FO-120S','A2 FI OP643/6','C9 FO-410S','A5 202470','C9 DO324','B1 KAMF300901','B1 PURLS892','A1 50013386','C9 50013386','A8 920 092','A1 0451103275','A2 UFI 23.159.00','C9 MBNA006','A5 80960','A3 JAP FO-300S','A5 174794','B1 HENH13W01','A8 345 060','C4 OC 195','A9 J1317004','B7 W811/80/AG','A2 SF PF7060','A5 37986','A2 0451103316','A1 10-04-410ASK','A2 UFI 23.271.00','A1 0451103316','A2 FI OP617','A9 SF OF0066','A5 242157','A9 FI OP536','C9 71758756','A9 0451103292','B7 A210023/DKM','A3 MHL OC195','C9 FO-120S','B1 BOS0451103316','C9 H13W01','B1 FTROP536','A5 30162','A9 FI OP643/6','C9 H97W06','A1 W811/80','A1 50013386/10','B1 BOS0451103275','C9 50013851','A9 J1317005','B7 A210039/DKM','A9 J1317008','A1 LS225PU','C4 J1317008','A8 318 352','B7 OP595/AG','B1 KNEOC205','A9 OC195','A3 JAP FO-502S','B1 KNEOC195','A3 FLT OP617','B7 OP617/AG','B1 FTROP617','A1 32099 FE','A2 OC195','B7 H97W08','C4 NO-2233','B1 BOS0451103292','C4 H97W06','C4 W 87','C4 H13W01','B7 HO-816/KAVO','A8 320 521','B7 MO-523/KAVO','C4 F026407209','A3 KAP FO-012A','A5 174791','C9 FE32099','A9 J1313016','A2 0451103275','B1 FEB32099','C9 MBNA018','B1 CHACFF100104','B7 H13W01','B7 FO-011A/KAVO','C9 DO925/A','B7 OP 595/IP','A2 UFI 23.259.00','A1 WOF1404','A1 F129','B1 MANW811/80','C9 FO-300S','B1 MANW815/80','C4 0451103292','B1 VAL586022','A8 913 453','A3 KAP HO-823','A2 586022','C9 OF-1006','A9 FI OP595','A1 OC195','B7 FO-012A/KAVO','B1 PURLS965','A2 F026407209','B7 A210159/DKM','C4 J1317005','C4 S 3484 R','A3 KAP MO-523','B1 KAMF115601','C4 J1311026','B7 10502/JAPKO','C9 35-143220002','A2 W87','C9 LS892','A3 JAP FO-198S','A1 H97W06','C4 W 815/80','C9 W87','A3 JAP FO-410S','A2 FI OP536','B1 VAL586017','A9 FI OP617','A1 J1317003HB','A9 0451103316','A9 OC1673','A9 UFI 23.159.00','A9 J1317003','B7 OP643/6/AG','A1 OC1566','A2 SF OF0066','B7 SM166','A8 300 100','B1 FTROP643/6','C4 0451103316','A1 0986AF1034','A3 MNN W811/80','C4 S 3258 R','A2 W811/80','B1 FTROP595','C9 71758725','A9 J1311026','A1 0986AF1039','B7 OP 617/IP','A2 0451103292','A1 10-07-705ASK','A5 38819','C4 0451103275','A2 J1317005','B1 KNEOC1566','B1 HENH97W08','A2 SF OF0063','A1 10-05-502ASK','A2 J1317004','A9 SF OF0063','A2 OC1673','C4 O0650DREIS','A3 VAC V32-0018','A2 J1313016','A3 JAP FO-313S','A5 30171','A9 OC1566','B7 NO-2223/KAVO','B7 SM121','C4 J1313016','C9 0451103292','C4 S 6901 R','A1 LS965PU','A8 919 462','B1 VAI32-0018','C9 LS225','A9 W87','A1 W815/80','A5 24791','A3 FLT OP595','A5 288024','C9 FO-198S','C9 35-143220000','B7 SM134','B7 H97W06','A1 J1311018HB','A1 W6025','A1 W67/1','A1 WOF189','A2 W6025','A2 W67/1','A3 JAP FO-316S','A5 202448','A5 30172','A8 300 080','A8 909 802','A8 919 224','A9 W6025','A9 W67/1','B1 MANW6025','B1 MANW67/1','B7 W67/1/AG','C4 W 6025','C4 W 67/1','C9 FO-316S','C9 W6025','C9 W67/1')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #