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 ('C4 650268','A3 VAC V10-0450','C4 650146','A9 RH 4046.00','A2 03.01370268.2','C9 0204114690','C9 2747530','A3 FER FSB150','B1 ATE03.0137-0146','C9 91044700','A2 0986487270','A1 FMK424','A1 03.0137-0146.2','B1 ZIM20990.110.4','C9 0986487536','A9 03.01370146.2','A1 FSB408','B1 ABS8871','A1 0986487270','C9 1145330003/K','A3 BOS 0986487270','B1 TOM2086','C9 98101-0183','B1 KAMJQ202007','B7 1163900110/JP','A9 S340','B7 10990.102.4','A9 GS8092','A2 S340','C9 GS8526','C9 BSS6277','A3 TEX 91044700','C4 06830','C4 91044700TX','C9 84044707','E7 124.274','A8 249 330','C9 84044706','A8 263 033','C9 GS8092','C4 GS8526','C1 RH 4046.00','A3 VAC V10-0451','B1 ATE03.0137-0268','B1 CIF151-085','C9 0986487270','A8 201 990','B1 ZIM20990.108.7','A1 WBS100','B7 B120088/DKM','E7 124.274.T','A1 FMK566','A3 TEX 91018300','B1 ABS8778','B1 ZIM20990.109.9','B1 BREK85038','C9 1145330008','C9 98101-0447','A2 RH 4046.01','A2 98101 0447 04','A1 0204114690','A2 BC 06830','B1 ZIM20990.106.0','B7 10990.100.2','C9 84044701','A1 K85038','B7 20990.100.1','A1 04100 LPR','E1 30 93 7547','A1 LS1277','A9 GS8526','B1 ZIM20990.113.5','B7 4046.00/REM','A3 NKS 2799520','A9 66980004101','C9 84044700','A2 GS8092','A9 FE FSB408','C9 1145330007','A9 0986487270','A1 361260J JRD','B7 20990.108.7','A3 NKS 2747345','A1 S85508','A1 361578J JRD','C9 BSS2088','A5 42763','A9 03.01370268.2','C4 GS8092','A1 03.0137-0268.2','B1 LUCGS8526','B7 B120089/DKM','B1 BOS0204114690','A2 LPP05730','A9 0986487536','B1 ZIM20990.127.4','C4 0986487270','B7 20990.109.9','A2 LPP04100','B7 20990.106.0','B7 20990.110.4','A1 LS1625','C9 19-0224','A2 66980004101','A3 NKS 2747530','C9 84018302','A1 GS8092','C9 84044702','C4 KRO-BS8526','A1 GS8526','C9 84018300','B1 ZIM10990.102.4','A2 LS1625','B1 CIF153-465','A2 FE FSB150','B1 KAMJQ202002','A1 562080','B7 1163900210/JP','B1 ZIM20990.105.2','B1 ZIM20990.100.1','B7 SS 503','B1 VAI10-0451','A8 213 539','A3 ROA 404600','C6 000008','A2 FE FSB408','A5 440422','B1 VAI10-0450','C4 FSB408','C9 19-0236','A1 FSB150','A2 BC 05730','A2 LS1277','A2 0986487536','A1 WBS199','B1 LUCGS8092','B7 SS 511','C4 LS1277','C9 84044708','A8 213 585','B7 20990.105.2','A2 03.01370146.2','C9 1145330010','A5 18853','A5 76371','A1 0986487536','A2 S345','B1 KAMJQ213003','B1 BOS0986487270','C4 LS1625','C4 10990.100.3','A3 ROA 404601','B1 TOM2024','A2 LPP06830','A3 MEZ MG571','A2 CF 151-085','A9 FE FSB150','A3 DLP LS1625','A5 127945','A5 0086','A5 274105','B7 4046.01/REM','C6 007284','A2 GS8526','B1 BRES85508','C9 BSS6625','C4 MG 571','A8 206 503','A2 S520','B7 20990.113.5','C9 84044705','B1 BOS0986487536','C9 1140420601','A3 MEZ MG571V','A3 DLP LS1277','B1 CIF153-462','C4 05730','A9 98101 0447 04','A2 RH 4046.00','A9 66980004001','A2 BC 04100','C9 83044701','B1 BRES85511','C9 03.0137-0268.2','A8 216 628','B1 CIF153-468','B1 ZIM10990.100.2','C9 84044703','A8 211 321','C9 VAL562080','B7 10990.100.3','C4 MG 571V','C9 84018301','A1 S85511','B1 TOM2070','B7 4198.00/REM','C9 83044704','A2 98101 0183 04','A3 BOS 0986487536','C9 83018300','A3 FER FSB408','A2 66980004001','B1 ZIM10990.100.3','A1 0986487002','A3 NKS 2747340','A8 220 018','A9 0986487002','B1 BOS0986487002','C4 0986487002','C9 0986487002')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #