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 04100 LPR','A2 03.01370268.2','B1 ZIM10990.100.3','A1 BK-5071','C9 19-0236','A2 FE FSB150','A2 LS1625','A1 S85508','C9 84018301','A2 BC 05730','B1 ATE03.0137-0268','A8 213 585','C4 10990.100.3','A3 NKS 2747345','A1 361260J JRD','A3 NKS 2799520','A9 66980004101','A3 FER FSB191','B7 20990.108.7','B1 ZIM20990.110.4','B7 B120160/DKM','B1 CIF153-468','B7 1163900210/JP','A9 0204114546','C9 0986487270','A2 GSK1512','B1 ZIM20990.127.4','A1 562020','C4 KRO-BS8526','B1 ABS8778','A1 FMK566','C9 1145330003/K','A8 216 628','B7 10990.100.3','C4 00140','B7 4046.00/REM','A1 FMK215','A8 231 941','C9 1140420601','B1 KAMJQ213003','A1 361216J JRD','E7 124.274','A3 TEX 91044700','C9 84044705','A2 66980004001','B1 BREK85036','B1 BOS0204114690','A2 LPP05730','C4 LS1625','C9 1145330004/K','A1 KP850','B1 TOM2023','C1 RH 4046.00','B1 ABS8772','C4 FMK215','B1 CIF151-085','A2 LS1277','C6 000008','C9 84044703','B7 20990.100.1','B1 TOM2070','A9 S530','A2 BC 06830','B1 BRES85508','A5 128334','A2 CF 151-084','A2 98101 0183 04','A2 LPP00140','A9 RH 4046.00','A2 0986487270','C9 BSS6625','B1 KAMJQ202004','A9 GSK1404','A2 FE FSB622','A1 0204114690','C9 1140420502','A5 127945','A2 RH 4045.00','A1 K85036','C9 83018300','B1 CIF153-465','C9 84044707','B1 ZIM10990.100.2','A2 LPP06830','E1 30 90 7013','C4 650146','A2 RH 4046.00','B7 SS 504','A5 42763','B1 TOM2086','A3 DLP LS1276','B7 20990.105.2','C4 91044700TX','C9 D3867A','A3 BOS 0986487270','B1 VAI10-0451','B7 B120089/DKM','A3 FER FSB150','A2 S345','A9 RH 4397.00','B1 VAI10-0450','B1 BLPADBP410028','B7 SS 503','B1 BOS0986487270','A1 S85507','B1 ZIM20990.113.5','A2 0204114546','A1 GS8526','A2 98101 0447 04','C9 84044701','A2 LPP04100','B7 10990.102.4','C4 650268','C9 1145330012','A9 S340','A3 MEZ MG571','A1 361578J JRD','A3 VAC V10-0452','A2 RH 4046.01','B1 ZIM20990.108.7','C4 FSB408','A8 243 874','B1 TOM2024','A3 MAR 360219230259','A8 211 321','A9 GSK1512','B1 KAMJQ202007','A8 201 990','C4 GSK1512','C9 2747530','C9 84018302','B7 B120087/DKM','B1 ZIM20990.100.1','C9 83044704','A1 GS8092','B1 ABS8871','A8 213 378','C9 19-0234','B1 BRES85507','C4 GS8092','C4 8DB 355 003-721','A5 0086','B7 20990.109.9','A3 NKS 2747530','A3 VAC V10-0450','C9 84044702','C4 05730','A2 D3-867A','B1 CIF151-084','A8 249 330','C9 03.0137-0268.2','C9 VAL562020','A1 LS1276','A5 18853','E7 124.274.T','A3 TEX 91018300','A1 562080','A5 440422','C9 1145330008','A1 LS1277','C9 BSS6276','A1 FSB150','B7 4046.01/REM','C9 ADBP410028','C4 06830','C4 GS8526','A9 0986487270','A9 98101 0447 04','C4 MG 571V1','C9 19-0223','C4 0204114546','C9 1145330010','C9 84044706','A1 0204114546','A3 ROA 419800','C9 BSW0259','A2 RH 4397.00','C9 VAL562080','A1 0986487270','C9 83044701','C4 GSK1404','C9 GS8526','B1 VAI10-0452','A3 MEZ MG571V','A2 S520','B1 BOS0204114546','C4 MG 571V','A3 ROA 439700','A8 228 781','A9 66980004001','A3 DLP LS1277','A3 BOS 0204114546','C9 91044700','A1 03.0137-0146.2','A8 206 503','A1 FSB622','A9 RH 4045.00','A2 GS8526','B1 CIF153-462','A2 FE FSB408','B1 AFND3867A','C9 84044708','C9 19-0224','B1 BRES85511','B7 SS 511','A3 FER FSB408','A9 GS8092','B7 4048.00/REM','C9 GSK1512','C9 98101-0183','A3 FER FSB622','B1 LUCGS8526','B1 LUCGSK1404','A2 GS8092','A1 WBS100','A1 LS1625','A3 DLP LS1625','A1 GSK1404','A9 FE FSB191','C9 1145330007','A3 MEZ MG343','B1 ABS111404','A3 ROA 404600','B1 BREK85038','A8 213 539','B1 ZIM20990.109.9','A2 S340','A8 231 944','B1 LUCGSK1512','C9 0204114690','B1 KAMJQ213006','B1 KAM1070008','A9 GS8526','A1 S85511','A1 562081','A2 GSK1404','B7 1163900110/JP','A2 OEK326','B7 10990.100.2','C4 LS1276','A3 ROA 404500','C9 BSS2088','A1 K85038','A2 03.01370146.2','A3 ROA 404601','C4 FSB191','A1 WBS199','A5 274105','C9 GSK1404','B7 20990.106.0','A9 FE FSB408','A8 263 033','A9 FE FSB150','A3 MEZ MG343V','A1 FSB191','A1 FMK424','C9 BSS6277','A2 BC 04100','A2 CF 151-085','A1 KP851','A2 BC 00140','A1 FSB191M','B1 LUCGS8092','C4 LS1277','C6 007284','A2 LS1276','C9 0204114546','B7 20990.113.5','A1 03.0137-0268.2','C4 D-3867A','C4 MG 571','A9 03.01370146.2','B1 ZIM20990.105.2','B1 ATE03.0137-0146','C9 GS8092','A3 VAC V10-0451','C9 84044700','C9 27-0366','A2 66980004101','B1 ZIM10990.102.4','A2 FE FSB191','A1 GSK1512','C4 0986487270','A9 03.01370268.2','A1 FSB408','B1 KAMJQ202002','B7 20990.110.4','A5 76371','C9 98101-0447','A1 BK-5187','A2 S530','B7 B120088/DKM','A9 D3-867A','B1 ZIM20990.106.0')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #