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