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 ('B7 ST393','C4 WK 512 SD','A3 JAP FC-W01S','C9 50013611','A1 EP155PU','B1 VKA12010076601','A1 0450902151','A2 SF PF7015','B7 1118701100/JP','B1 VAI40-0018','A2 FI PP907','A9 FI PP905/2','A9 SF PF7012','A9 UFI 31.722.00','A1 WFF114','C4 0450905273','B7 PP905/AG','C4 H110WK','A3 VAC V46-0031','A1 KL573','A9 FI PP907','C9 0450905273','A9 J1330901','E2 201 622 756','A3 FLT PP907','A3 VAC V40-0019','C9 MBNA964','B1 TRU07.38.041','B1 VAI46-0031','C4 S 1562 B','A2 SF PF7012','C4 CFF100225','B1 BOS0450905904','C4 EP155PU','A8 367 164','A9 0450905904','B1 BOS0450905273','A9 KL84','B7 1118700900/JP','A8 370 357','B1 MISE562','B7 DF-7741/KAVO','A1 WK512','A3 FLT PP905/2','C4 0450905316','A5 40886','C9 0450905280','C9 WK512','C9 EFP202','A5 82102','B7 PP 907/IP','B1 FTRPP905','A1 L225','B7 A110184/DKM','A2 0450905280','B1 DELEFP202','A3 MHL KL83','A2 40 91 7635','B1 KAMF300801','B7 DF-7744/KAVO','A8 313 610','A1 WFF700','A9 FI PP905','C9 50013643','A2 0450905904','A3 MHL KL573','C9 0450905904','C9 FC-W01S','B1 VAL587010','C9 PF-2024','B7 A110004/DKM','B1 VAL587008','B7 PP 905/2/IP','A9 KL573','C4 CFF100201','C4 WK 512','B7 H110WK','B1 KNEKL83','A8 313 621','B1 KNEKL146','A8 303 183','C9 201622595','A1 J1330901HB','A2 0450905273','B1 KAMF301501','A9 WK512','A1 17635 FE','C9 1002010013','C9 H110WK','C9 0450905316','A5 38820','A8 313 622','A3 MNN WK512','A1 0450905273','A1 KL83','A9 0450905280','C9 71760676','B1 VAI40-0019','C9 MBNA987','B1 CHACFF100225','A1 WFF143','A1 EP163PU','A9 KL83','C9 EP163','B1 FTRPP905/2','B1 PUREP155','A2 0S 1515 B','C9 PF-2060','A9 SF PF7015','A3 VAC V51-0007','C4 0450905280','A5 35985','C4 F0279DREIS','C4 07.38.041','A3 BOS 0450902151','A9 0450905316','A9 0450902151','B1 VAI51-0007','A3 VAC V40-0018','C4 KL 84','C9 SP-2060','B1 FTRPP907','A1 0450905280','A2 587008','C4 J1330901','C4 EP163PU','A3 BOS 0450905316','A1 WFF234','B7 A110003/DKM','A2 KL573','A3 VAC V10-0207','B1 BOS0450905280','A2 UFI 31.722.00','C6 007098','A2 UFI 31.515.00','A3 BOS 0450905273','C9 71760845','C4 S 1722 B','B7 30W01/JAPKO','A1 EP164PU','C9 SP-2061','A2 WK512','A2 KL83','B7 ST308','B1 PUREP163','B1 BOS0450902151','A8 911 012','C4 KL 573','B1 HENH110WK','A8 314 120','B7 PP907/AG','A8 920 678','B1 BOS0450905316','B7 ST342','C9 MBNA985','A3 FLT PP905','B7 WK512/AG','B1 HP201 622','C9 FE17635','A3 MHL KL84','A1 KL84','A5 43691','B1 KAMF300201','A9 UFI 31.515.00','A1 0450905904','C9 0450902151','B1 MANWK512','B7 PP905/2/AG','B1 DELEFP214','A2 FI PP905/2','A2 0450902151','A2 FI PP905','A8 318 573','C9 EP155','A2 J1330901','A2 0450905316','B1 KNEKL84','C4 17635F','A8 318 288','C9 EP164','A3 KAP DF-7741','B1 PUREP164','C4 KL 83','A5 38184','B1 FEB17635','A8 930 367','A1 L224','B1 CHACFF100201','A2 KL84','C4 S 1515 B','A8 318 730','B1 VAI10-0207','C9 SP-2134','C4 0450902151','B7 PP 905/IP','A3 BOS 0450905280','A1 0450905316','A3 BOS 0450905904','A1 30-W0-001ASK')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #