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