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 LP1436','B1 BOS0986424797','A2 RH 8633.04','C9 VAL301026','A3 TEX 2313081','C9 GDB1984DTE','A2 0986424364','C9 0252088719','B7 SP 136','A9 13.04607111.2','D1 BP ADV184203','A1 571971JC JRD','A1 0986424364','A8 243 470','A1 GDB1984DTE','C9 2313001','A1 598332','A3 DLP LP1104','A9 FE FDB1094','C9 VAL598487','A1 13.0463-7117.2','C4 0986424364','A3 BOS 0986495004','A8 234 125','B1 ATE13.0460-7111','C4 23130.195.1','B1 ABS37008','A1 598128','A2 T 2313081','A2 FE FDB1094','E1 30 91 6328','C9 13.0470-7111.2','A1 FSL1094-PROMO','C4 LP1436','C9 2568101','A1 571985JC JRD','A1 573128J JRD','C9 0986424364','A1 GDB1357','A8 249 154','A5 40494','B1 LUCGDB1984DTE','A8 205 630','A2 13.04707111.2','A2 RH 8633.03','B1 VAL301332','C4 FSL1094','C9 23130-19,7','C9 13.0460-7111.2','A1 0986495004','A2 LP1436','A1 WBP563','B1 BREP85041','A1 0986424797','B1 BLPADV184203','A3 BOS 0986424797','B1 BOS0986494505','D1 BP ADV184202','C4 GDB1984DTE','A2 05P668','A3 FER FDB1094','A5 116723','B7 0633.20/REM','B1 VAL301026','B1 FEB16486','B1 BREP85121','C9 0252313019/PD','A3 VAC V10-8109','C4 LP1104','C9 2313081','A9 T 2313081','A9 05P730','A2 0986495004','C9 VAL301332','B7 0633.00/REM','A1 FDB1094-PROMO','C4 2313001TX','A2 BP85041','A3 BOS 0986494505','A1 0986494505','A1 13.0470-7111.2','A9 BP85041','A9 0986424797','C9 ADV184202','A3 TEX 2358781','A8 219 796','C9 FDB1094','A8 228 197','A9 13.04707111.2','A1 LP1104','A2 GDB1984DTE','A1 571971D JRD','C9 224740','C9 25681-18,0','A5 66270','C9 0252088719/PD','C9 0986424797','A2 RH 8633.02','A1 FDB1094','A2 RH 8633.00','A2 FE FSL1094','A2 23130 197 05','A9 0986424364','C4 16328F','A8 217 293','A1 WBP298','C9 VAL598332','B1 ATE13.0470-7111','A3 BOS 0986424364','B1 BOS0986424364','B1 BLPADV184202','A1 P85041','A1 F026000063','A2 LP1104','C4 LD7111','A1 573128JC JRD','A1 FQT1094','B1 VAI10-8109','A2 0986424797','A1 2313001 TEX','A1 WBP1041','C9 F026000063','A8 209 897','C9 23587-20,3 EPAD','A1 13.0460-7111.2','A5 16459','A3 DLP LP1436','A9 GDB1984DTE','A1 16328 FE','B1 ZIM23130.195.1','C9 VAL598128','A2 T 2358781','C9 0252088715','A1 FSL1094','C4 0986424797','A9 23130 197 05','C4 2358781TX','C4 607111','C9 0986494505','B1 FEB16328','C4 986424364','B7 0633.31/REM','B7 23130.195.1','A1 P85121','A8 215 144','C4 05P668','A3 TEX 2313001','C4 FDB1094','C9 23130-19,7 EPAD','C9 FE16328','B7 0121.10/REM','A2 05P730','C9 0252313019/A','A2 13.04607111.2','A1 P85041X','A2 Q113-1306','A2 Q113-1306X','A3 CIF 822-211-1','A3 JAP PA-0044AF','A3 QUI 113-1306','A3 QUI 113-1306X','A8 203 802','A8 204 498','A9 Q113-1306','A9 Q113-1306X','B1 BREP85041X','B1 CIF822-211-1','B1 KAMJQ101838','B1 QB113-1306','B1 QB113-1306X','B1 VAL302029','B1 ZIM21974.195.1','B1 ZIM23131.195.1','B7 23131.195.1','B7 B110695/DKM','B7 B110697/DKM','C4 21974.195.1','C4 23131.195.1','C9 19-0614','C9 23130 00 702 00','C9 PA-0044AF','C9 QB113-1306X','C9 QP6531','C9 QP6531C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #