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