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 ('C9 0252313119/W','A9 GDB1658','B1 ATE13.0460-7117','D3 RE 63331-AF','C9 QP2226','A3 ROA 263321','B7 0633.20/REM','A9 FE FDB1094','A1 0986495213','A3 BOS 0986494019','B7 0633.41/REM','A2 GDB1658DTE','A9 GDB1658DTE','A5 386538','C6 000321','A2 FE FDB1094','C9 23130-19,7','A9 13.04607117.2','C9 2313101','A8 220 324','B1 LUCGDB1386','B1 VAI10-8110-1','B1 ATE13.0470-7117','B1 FEB16446','A2 GDB1658','A1 FDB1094','A1 13.0470-7117.2','B1 BREP85072X','C9 0986494524','A8 234 061','C9 PF0132','A1 FDB1635','A5 42628','A1 2313101 TEX','A1 WBP452','A3 TEX 2313081','A3 BOS 0986494525','A5 116698','A9 RH 2633.31','C9 13.0460-7117.2','A3 FER FDB1094','C9 FDB1398','B1 BOS0986424364','B1 TRU07.35.103','A5 87360','C4 16446F','A2 GDB1386','C9 19-0613','A9 23130 197 05','A1 0986494019','B7 SP 136','A9 T 2313081','C4 GDB1658','A8 230 398','A2 0986495213','B1 VKA66981691001','A9 BP85072','A1 2313001 TEX','A1 GDB1422','C4 FSL1635','A2 RH 2633.21','C4 FDB1398W','A2 0986424364','A9 0986424364','C4 23131.195.1','C9 VAL598408','A1 WBP296','A3 TEX 2313181','C4 KRO1386','A8 215 158','A3 FER FDB1398','A1 P85072X','A1 FSL1398','C4 LP1514','C9 VAL301408','C9 13.0470-7117.2','A3 DLP LP1514','A9 FE FDB1398','C4 KRO1658','B1 BOS0986494019','A1 WBP698','A9 GDB1386DTE','A8 215 144','C1 RH 2633.41','A9 GDB1386BTE','A9 GDB1386','C4 0986495213','A5 40494','B1 CIF822-211-2','A2 23130 197 05','B1 ZIM23130.195.1','B1 VAI10-8110','A2 GDB1386BTE','A1 WBP298','A3 JAP PA-0043AF','A2 LP1436','B1 ZIM23131.995.1','C9 2313081','A1 598408','A3 BOS 0986495213','A2 RH 8633.01','A1 FSL1398-PROMO','B1 ABS37155','B7 1163601010/JP','A2 GDB2108','A2 05P692','C9 224745','C4 0986494525','A2 FE FDB1635','A8 230 140','C9 PA-0043AF','A3 FER FDB1635','C4 0986424364','C4 23130.195.1','A1 13.0460-7117.2','A1 FSL1635','A1 LP1436','A1 WBP559','C9 GDB1386','C4 LP1436','A9 23131 197 05','A8 240 931','A9 RH 2633.20','C9 GDB2108','C9 VAL598487','A2 RH 2633.41','A1 571971D JRD','C4 FDB1398','B1 KAMJQ1012796','B1 BOS0986494525','C9 GDB1658DTE','A3 TEX 2313101','C4 GDB1386','C4 2313101TX','A1 0986494525','A1 GDB2108','C9 0986424364','A8 205 630','A9 GDB2108','A1 0986495048','A2 LP1514','B1 ZIM23131.195.1','A3 DLP LP1436','C4 FDB1094','A3 CIF 822-211-2','C4 GDB1386DTE','B1 LUCGDB2108','C9 0252313119/PD','A3 VAC V10-8110','A1 571971JC JRD','C9 23131 00 702 10','A3 VAC V10-8110-1','A9 RH 2633.21','C4 FDB1635','A1 LP1514','A2 RH 2633.31','A2 FE FDB1398','A2 T 2313181','A3 BOS 0986495048','A1 GDB1386DTE','A1 FDB1398','A1 16446 FE','A3 ROA 263341','C4 2313001TX','A2 FE FSL1398','A5 73577','B1 BREP85072','C9 FDB1094','B1 VAL301408','A2 T 2313081','A3 ROA 263320','B7 0633.31/REM','C4 607117','A8 205 370','C9 2313181','C9 2313001','B7 0633.21/REM','B1 LUCGDB1658','B1 ZIM23130.995.1','A9 13.04707117.2','A1 GDB1658DTE','C4 05P692','A9 BD S003S','A2 13.04607117.2','A8 232 187','C9 GDB1386DTE','A3 BOS 0986424364','E1 30 91 6446','A1 GDB1658','C4 GDB1658DTE','C9 23131-19,7 EPAD','B7 B110690/DKM','C9 GDB1658','A9 05P692','B1 LUCGDB1386DTE','A2 0986494019','C4 0986495048','A2 13.04707117.2','A1 0986424364','A3 BOS 0986494524','B7 23131.195.1','C9 0986494525','A2 RH 2633.20','C9 23130-19,7 EPAD','A2 0986495048','A5 40476','A3 TRU 07.35.103','C9 QP2226C','D2 EO GDB1386','A5 170206','C4 LD7117','A1 GDB1386','A1 P85072','A2 BP85072','A1 0986494524','C4 0986494019','C4 GDB2108','C9 0986494019','A1 FDB1094-PROMO','A9 RH 2633.41','B1 TOM1211','A3 ROA 263331','B1 LUCGDB1658DTE','C4 0986494524','C9 23131-19,0','A2 BD S003S','B1 BOS0986494524','B7 23130.195.1','B7 05P692/SUZ','A8 234 138','A3 TEX 2313001','A2 GDB1386DTE','B1 LUCGDB1386BTE','A2 23131 197 05','A9 0986494019','A1 V10-90001')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #