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