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 ('C9 WK613/1','B1 MANWK613/1','A9 UFI 31.611.00','C9 WK410','A3 JAP FC-111S','C9 ADN12329','B1 FTRPP830','C4 0450905280','A8 307 084','A9 0450905280','A3 JAP FC-198S','D2 L225','C4 0450902151','B1 BLPADV182339','A1 0280160210','A3 BOS 0450902151','A1 WK613','A1 30-01-111ASK','A9 UFI 31.529.00','A2 0450905326','A2 0280160210','A3 JAP FC-909S','A5 30218','A2 587003','A3 MHL KL60','A9 WK613/1','B7 PP830/AG','A9 KL60','A9 UFI 31.512.00','C9 ADN12316','A9 0450905002','C4 S 1510 B','C4 KL 14','C9 0280160210','A8 313 622','D1 BP ADN12316','A8 928 035','C4 450905280','A9 KL86','C4 KL 60','C9 0450905002','B1 MANWK410','B1 BOS0450905280','A8 318 280','A2 UFI 31.611.00','A8 315 275','C9 MBNA022','A1 WK45/1','A8 919 598','B1 BLPADN12329','C4 WK 613','A2 FI PP830','A9 KL14','D2 L201','A1 0450902151','C9 H321WK','B1 MANWK613','A9 WK410','C9 0450905280','A1 0450905002','C9 ADV182339','B1 VAL587003','A1 WK410','A1 EP139PU','A3 FLT PP831','A5 35985','A1 KL60','B7 H321WK','A2 KL86','A8 313 621','A3 BOS 0450905002','A2 0450905280','A1 L213','B1 BOS0450905002','A3 MHL KL86','C4 WK 410','C9 H82WK01','C4 S 1611 B','A1 KL 60','C4 F0323DREIS','A3 MHL KL14','A2 0450902151','A2 WK613','A1 WFF119','A1 KL86','A1 WFF234','A8 300 128','A1 0450905326','C9 MB950','A2 KL24/1','C9 FC-111S','A1 L215','A8 303 526','C4 0450905002','A1 WFF239','B1 BLPADN12316','A9 FI PP831','B7 PP 830/IP','B7 H153WK','A5 23632','A1 J1331025HB','A1 KL14','A1 KL24/1','A5 80473','A8 367 157','C4 EP139PU','C9 MBNA970','B1 BOS0450902151','A9 0450902151','C9 H153WK','A8 314 167','B1 VAL587012','A2 WK410','A1 0450905936','A2 KL60','C9 EP139','A9 UFI 31.510.00','A8 367 161','C4 450902151','B1 BOS0450905326','A2 0450905002','B1 VAL587009','D1 BP ADV182339','A1 WFF207','A9 0450905326','A3 MNN WK410','A3 BOS 0450905326','C9 WK613','A2 FI PP831','A2 587009','C9 FC-909S','A1 30-09-909ASK','A2 H82WK01','C9 FC-198S','C4 H82WK01','C4 S 3900 B','A2 UFI 31.529.00','A3 FLT PP830','A1 0450905280','A2 0S 3900 B','B1 FTRPP831','B1 FTRPP831A','D1 BP ADN12329','B7 PP 831/IP','E6 FF1151','C4 WK 613/1','B7 H82WK01','A5 43691','A3 MNN WK613','A8 313 609','C9 MBNA950','C9 0450902151','A9 WK613','C4 450905002','A1 L201','A9 FI PP830','C9 0450905326','B1 HENH82WK01','A3 MNN WK613/1','B1 PUREP139','B7 PP831/AG','C9 MBNA964','A2 UFI 31.510.00','A1 WK613/1','A2 UFI 31.512.00','A1 WFF432','A3 BOS 0280160210','A2 WK613/1','A8 318 398','A3 BOS 0450905280','A1 WFF272','A2 KL14','A1 32399 FE','A1 J1331043HB','A2 N1330913','A2 SF PF7015','A9 SF PF7015','B1 BLPADN12324','B1 CHACFF100201','B1 CHACFF100215','B1 DELEFP214','B1 FEB17637','B1 FEB21626','B1 FEB32399','B1 HP201 621','B1 KAMF300801','B1 KNEKL60','B1 KNEKL86','B7 A110004/DKM','B7 ST308','C4 32399F','C9 1003230012','C9 6148180002','C9 ADN12324','C9 FE32399','C9 PF-2024','C9 SP-2024','D1 BP ADN12324')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #