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