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 ('A2 587001','B1 HENH82WK01','A3 MNN WK6002','A9 SF PF7015','A5 246821','A5 80473','A8 908 987','B7 A110004/DKM','B7 1118700900/JP','B7 NF-2360/KAVO','C9 WK612','A8 315 275','A2 KL248','C9 EFP201','B1 CHACFF100224','A3 DLP EFP201','A5 23632','A8 313 618','B1 VAL587002','A1 J1331043HB','B7 30M00/JAPKO','C4 WK 6002 SD','A2 WK6032','A2 WK613','C4 WK 613','B1 VAL587001','A5 98187','A1 KL14','B1 MANWK6032','C9 207024595','B7 H82WK01','A2 FI PP831/1','B1 KNEKL248','C9 FC-120S','A3 TRU 02.38.061','E2 720 937 756','C9 MBNA964','A8 370 359','A1 WFF115','C9 EP210','A2 UFI 31.510.00','A8 315 276','C9 71760845','C9 H112WK','C4 H112WK','A1 EP202PU','A2 J1331043','C4 S 1710 B','A1 KL 60','C9 WK612/1','C4 EP90CPU','B1 VEM20-09-0468-1','C9 50013080','B1 DELEFP214','A1 WK6031','A3 MHL KL63','B7 PP831/AG','A9 UFI 31.710.00','B7 H481WK','B1 KAMF300501','A2 0450905287','A1 30-01-120ASK','C4 F0315DREIS','A3 MNN WK612','B1 MANWK612','A3 JAP FC-M00S','A1 WK612','A8 378 455','A8 367 218','A2 SF PF7036','D2 0 450 902 161','A3 VAC V42-0007','C4 J1331021','A9 KL60','C4 S 1510 B','C9 WK6031','A1 EP210PU','C9 71760852','A3 FLT PP831/1','C9 50013623','A9 WK6031','C9 6143230002','C4 WK 612','A1 KL 72','B1 MANWK6002','C9 71760701','A2 KL14','A1 KL63','C9 MBNA950','A9 UFI 31.510.00','A1 WFF204','A3 MNN WK613','A1 KL248','A9 KL248','A1 50013623','A2 FI PP831','A2 WK6031','A3 VAC V40-0642','A3 JAP FC-909S','A3 MHL KL14','C4 S 1948 B','C4 KL 60','A1 EP90CPU','B1 MANWK613','A9 J1331043','C4 H107WK','A1 30-0M-000ASK','C9 WK6002','B1 CHACFF100236','B1 FTRPP831/1','C9 FE32399','B7 PP831/1/AG','C4 0450902161','A2 KL416/1','A8 315 277','B1 PUREP210','D2 L225','D2 L201','A9 UFI 31.948.00','A8 300 128','A1 WK6002','B7 ST326','A9 SF PF7036','A9 0450902161','A2 SF PF7015','C9 SP-2061','A2 0450902161','C4 CFF100236','A1 EP139PU','A1 KL60','B1 CHACFF100201','A2 KL60','A2 WK6002','A3 JAP FC-120S','A1 30-09-909ASK','C4 H481WK','C4 EP202PU','A8 315 280','A2 587003','C9 WK6032','C4 H82WK01','C9 H107WK','C9 H82WK01','A2 UFI 31.710.00','A8 930 378','B1 TRU02.38.061','C9 WK613','B1 DELEFP201','C9 0450905287','C4 KL 14','D2 L236','A8 318 396','B1 FTRPP831','E3 180014610','B1 HENH107WK','C9 6148180002','B1 FEB32399','A2 KL63','A9 WK6032','A1 0450905287','A2 J1331021','C4 WK 6031','A9 WK613','B7 A110005/DKM','A1 KL72','B1 PUREP202','C9 EP202','B1 VAL587008','B7 A110398/DKM','A8 305 664','A2 587008','A1 L236','A3 MNN WK612/1','E2 207 024 595','A1 WK613','B7 H112WK','B1 PUREP139','B7 H107WK','C4 0450905287','C9 EP90C','C9 FC-909S','B1 KAMF302901','C4 KL 248','A1 32399 FE','A3 MHL KL248','C9 MBNA967','C4 KL 416/1','B1 KNEKL14','A9 WK6002','C9 FC-M00S','B7 PP 831/IP','B1 HENH481WK','A1 H481WK','C9 MBNA1502','A8 318 280','C4 32399F','A5 80445','A2 587002','A1 KL416/1','A3 BOS 0450902161','A5 144353','B1 VAI42-0007','A1 WK6032','C9 PF-2024','B1 MANWK6031','C4 WK 6002','B1 KAMF300801','A2 H107WK','B1 HENH112WK','A1 0450902161','C4 EP139PU','C9 0450902161','C4 CFF100201','A9 KL416/1','A9 FI PP831','B7 30120/JAPKO','A3 FLT PP831','C9 EP139','A2 H82WK01','B7 ST308','E3 3015670C2','B7 30909/JAPKO','A1 WFF119','A9 KL14','C9 PF-2061','B1 BOS0450902161','A8 367 157','C4 F0306DREIS','B7 PP 831/1/IP','A5 19962','B1 VAL587003','A3 BOS 0450905287','B7 ST393','A3 MHL KL60','A9 J1331021','A1 0450905919','C4 F0323DREIS','C4 WK 612/1','C4 EP210PU','A3 MHL KL416/1','A1 WK612/1','A9 FI PP831/1','B1 VAI40-0642','A2 UFI 31.948.00','B1 PUREP90C','A5 147859','A5 249752')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #