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