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 ('A2 BP68048','A1 16435 FE','A2 LP1714','A3 DLP LP1104','C4 24535.180.1','B1 LUCGDB1787','E3 24535.180.1','A2 13.04707221.2','C4 2313001TX','A2 BD S004S','C4 607111','A2 13.04607111.2','A2 0986494439','A3 BOS 0986494439','C9 GDB1787','A9 23130 197 05','A9 RH 2962.00','A2 LP2252','A1 13.0460-7111.2','C4 607221','A5 282066','A1 16672 FE','A8 205 630','A8 227 870','A1 FSL1440','A9 FE FDB1866','A9 BP68029','B1 ATE13.0460-7248','C9 FDB1866','B7 24535.180.1','A2 RH 2962.00','C4 23215.180.1','E7 344.1','A1 GDB1787','A2 RH 8633.02','E3 23215.180.1','A5 143180','A9 GDB1787','A5 206734','A9 13.04607111.2','A3 ROA 296210','B1 BREP85041','B1 ATE13.0470-7221','A2 LP1104','A3 ROA 263320','A2 FE FDB1866','C9 13.0460-7221.2','B1 ATE13.0460-7221','A9 BD S853P','C4 986494439','A2 RH 2633.00','C4 05P898','A2 FE FDB1440','A2 RH 8633.04','A2 23215 183 15','B1 BREP68048','B1 ZIM24535.180.1','B1 ZIM23215.180.1','B1 FEB16672','A2 T 2453501','C4 16435F','A1 LP1104','A2 GDB1787','A3 FER FDB1866','C4 LP1714','A2 13.04607221.2','A1 13.0460-7221.2','A3 TEX 2321502','B1 BREP68048X','A1 LP2252','A2 RH 8633.00','B1 ABS37217','A1 13.0470-7221.2','A9 BP85041','A8 241 556','B1 BOS0986494439','C9 VAL601012','C9 23130-19,7','A3 TEX 2453501','A9 FE FDB1440','A9 23215 183 15','A5 118304','C4 2453501TX','C9 24535-18,3','A9 0986494439','C4 GDB1787','C9 13.0460-7248.2','A2 RH 8633.03','E7 P8623.00/W','C4 05P1279','A9 BD S004S','A3 ROA 296200','C9 2321502','A1 P85041','C9 FE16672','A9 13.04607248.2','A9 RH 2633.00','A2 BP85041','A2 RH 2633.20','C4 LP1104','A5 78020','A1 WBP743','C4 FDB1440','C4 FDB1866W','A9 13.04707221.2','C9 13.0460-7111.2','C4 LP2252','A5 16459','B7 23215.180.1','A3 DLP LP1714','A8 207 985','C9 2313001','A2 05P1279','A2 RH 2962.10','C9 23215-18,3','A1 FDB1866','A9 BP68048','A3 DLP LP2252','A1 13.0463-7117.2','A1 13.0460-7248.2','B1 BREP68029','B1 FEB16435','A1 FDB1440','B1 ABS37155','A1 P68029','C9 2453501','A1 WBP405','C9 13.0470-7221.2','C9 0986494439','A1 0986494439','A2 05P898','B1 ATE13.0460-7111','C4 0986494439','B7 0962.10/REM','B1 ABS37008','A1 P68048','A2 23130 197 05','A1 2313001 TEX','A2 BD S853P','B7 0962.00/REM','A3 FER FDB1440','A3 ROA 263300','A3 TEX 2313001','A9 RH 2633.20','A8 224 298','A1 LP1714','C4 FDB1866','A9 T 2453501','A2 BP68029','A9 13.04607221.2','A2 13.04607248.2','A1 571985JC JRD','A1 FDB1094','A1 GDB1687','A1 GDB1984','A2 FE FDB1094','A2 GDB1687','A2 GDB1984','A2 GDB1984DTE','A3 CIF 822-335-1','A3 FER FDB1094','A3 JAP PA-0044AF','A5 170180','A5 194987','A8 230 126','A8 230 412','A8 234 125','A8 234 141','A9 FE FDB1094','A9 GDB1687','A9 GDB1687DTE','A9 GDB1984','A9 GDB1984DTE','B1 BLPADR164209','B1 KAMJQ1012880','B1 LUCGDB1687','B1 LUCGDB1984','B1 LUCGDB1984DTE','B7 B110918/DKM','C4 FDB1094','C4 GDB1687','C4 GDB1687DTE','C4 GDB1984','C4 GDB1984DTE','C4 KRO1687','C4 KRO1984','C9 0252453518','C9 19-2090','C9 GDB1687','C9 GDB1687DTE','C9 GDB1984','C9 GDB1984DTE','C9 PA-0044AF','C9 QP2960','C9 QP2960C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #