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 ('A9 1987432204','F2 1009627894','C4 LA 464','A3 MHL LA464','B7 HC-8217/KAVO','B1 VAL715816','B1 JPN40F0501-JPN','A3 MNN CU2331','A3 MHL LAK447','B9 FLT K1314A','F4 ASH21-HY-H28','F4 BOF1987435097','F4 DECM110652A','B1 VAL715592','A8 925 961','C9 KF-6348','F2 1001775656','A2 LA447','A3 DEN DCF577P','B1 FTRK1314A','C4 CU 24 013','B1 FTRK1314','A2 FI K1314A','F4 KAOF512301','C9 37-123190007','A8 399 301','A2 UFI 53.208.00','A9 1987435097','A2 1987432204','A9 CU2331','A9 CUK24013','B7 K 1314/IP','B7 HC-8215/KAVO','F4 COR49382449','A9 LAK447','F4 MANCU24013','F4 COR49359582','C9 BCF400','C9 37-123190018','B1 DENDCF263P','A2 CP1277','B1 KAMF512301','C4 S 3208 C','A8 326 575','A2 LAK447','F4 KAVHC-8215','F2 1001096720','F4 MAD17455','C4 1987432204','C9 MS-6348','F2 1004044988','B1 CORCP1277','C4 HC-8217','F4 MANCUK24013','F4 KAOF415501','B1 MANCUK24013','F4 MAHLAK447','F4 PURAH360','C4 CU 2331','C4 CUK 24 013','F4 FILK1314','A3 FLT K1314A','B9 JAP FAA-HY28','C4 K0125DREIS','A9 LA464','F2 1000536943','B9 FLT K1314','A2 1987435097','F2 1001235209','A5 284764','F4 DECM110538','C9 FAA-HY28','C9 FE32760','A3 FLT K1314','F4 MAHLA447','F4 KAVHC-8215X','C4 LAK 447','F2 1001223449','F4 TOP821 098','C9 1987435097','A8 919 616','B1 DENDCF577P','B7 K1314/AG','C9 AH360','F2 1001692057','B1 VEM52-30-0008','A5 264748','A5 57067','F4 UFI53.208.00','A5 230498','B1 PPF4F0083','C4 N1340526','F4 KAVHC-8217C','B1 BOS1987432204','F2 1001692091','B1 CHACCF0186','F4 COR80000813','A9 N1340511','F4 DECM110538A','F4 MANCU2331','C4 TSP0325250','A2 N1340511','C4 DCF263P','A9 UFI 53.208.00','B1 MANCU24013','F4 BOF1987432204','A9 CU24013','B1 KNELA464','C9 80000814','F4 KBS50014770','B1 MANCU2331','B1 PURAHC360','C9 KF-1324C','B1 CORCC1277','C4 1987435097','A8 380 613','F4 MADFKHYD008','C9 1987432204','C9 KF-1324SC','B7 K1314A/AG','A5 250171','A2 CC1277','A5 432864','F4 PURAHC360','B1 BOS1987435097','F4 HENE3902LI','B1 KNELA447','F4 DENDCF577P','F2 1018871651','F4 COR80000814','B1 JPN40F0319-JPN','C9 37-123200007','F4 KAVHC-8217','E9 32760','A8 083 529','F2 1000987378','A8 920 555','A8 373 833','F4 MAHLA464','F4 FEB32760','A9 FI K1314','C4 LA 447','A8 301 149','F4 FILK1314A','F4 VAL715592','B7 M110538/DKM','A2 CUK24013','A9 FI K1314A','A2 FI K1314','F4 DECM110652','F4 MMABCF400','A3 JAP FAA-HY28','A8 359 782','C9 CU2331','B7 21H28/JAPKO','A3 MHL LA447','B1 FEB32760','A2 LA464','A8 371 306','A8 929 523','B1 PURAH360','C9 CUK24013','F2 1003318617','A8 930 257','C9 CU24013','B1 HENE3902LI','F2 1001122709','B7 E3902LI','F2 1018871650','B1 JPN40F9069C-JPN','A9 LA447','F4 KAO6080095','F4 KAVHC-8217X','B1 KAM6080095','F4 MADFKHYD013','A3 KAP HC-8217','A2 715592','C9 80000813','B1 PPF4F0083C','C9 KF-1324','F4 WIXWP2046','F2 1002870516','F2 1001029506','C4 E3902LI','C9 VAL715592','F4 VAL715816','A2 CU2331','A2 CU24013','F4 MMABCF400C','F4 DECM110652K','A8 920 463','C4 N1340511','F2 1000587440','C4 K0144DREIS','A3 BOS 1987432204','A8 912 354','F4 DECM110538K','B7 K 1314A/IP','F4 DENDCF263P','B1 KAMF415501')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #