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