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