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 ('A9 GDB1386DTE','A1 WBP698','A2 RH 2633.41','C9 GDB1386DTE','A2 BP85072','C4 GDB1658','A1 16332 FE','A8 230 140','A9 05P692','A9 23131 197 05','C9 2313101','A3 ROA 263321','C9 VAL598408','A9 FE FDB1398','C9 13.0460-7117.2','A1 GDB1658DTE','A2 LP1514','A1 16446 FE','C9 23131-19,0','A1 GDB1386','C4 KRO1658','A2 GDB1386DTE','A5 40476','C9 224745','C1 RH 2633.41','A1 571971JC JRD','A1 GDB1386DTE','A2 23131 197 05','B7 0633.21/REM','B1 FEB16332','C9 GDB1386','B1 LUCGDB1386DTE','A1 P85072','B1 ATE13.0460-7117','A9 GDB1658DTE','A1 598408','C9 GDB2108','A3 JAP PA-0043AF','A2 T 2313181','C4 0986495213','A2 05P692','A1 WBP452','A5 116698','A2 13.04607117.2','A2 RH 2633.21','A1 16617 FE','C4 16618F','B1 FEB16617','A3 ROA 263341','A5 386538','C9 FDB1398','B7 05P692/SUZ','A3 BOS 0986495213','B1 LUCGDB1658','A3 FER FDB1398','C9 23131-19,7 EPAD','B1 LUCGDB1386','A9 13.04607117.2','C9 VAL301408','A1 GDB1658','A8 234 061','A2 FE FDB1398','A8 220 324','C9 PA-0043AF','A9 GDB1658','A2 GDB1658','C4 0986494019','C4 LP1514','A1 FDB1398','A1 GDB2108','C4 0986494525','C4 2313101TX','C4 GDB1658DTE','A1 P85072X','B1 LUCGDB2108','A3 DLP LP1514','C9 0986494019','C4 KRO1386','C9 VAL598487','A9 RH 2633.21','A3 FER FDB1635','A3 BOS 0986494019','A8 215 158','C4 FDB1398','A8 240 931','A9 GDB2108','A9 GDB1386','A2 GDB1386','A2 GDB2108','B1 FEB16618','A9 BD S003S','A5 170206','C4 16446F','A1 0986494019','A1 GDB1422','B1 BREP85072X','C9 2313181','B1 FEB16446','A3 TEX 2313101','C9 GDB1658','D2 EO GDB1386','A1 571971D JRD','C4 607117','A1 16618 FE','A8 234 138','A2 0986495213','A1 FDB1635','A1 GDB1397','C9 0986494525','A2 GDB1658DTE','A1 0986494525','C4 FDB1635','A3 BOS 0986494525','A1 2313101 TEX','B1 BOS0986494019','A3 TEX 2313181','B1 VAL301408','B1 ZIM23131.995.1','C9 GDB1658DTE','A2 0986494019','B7 0633.41/REM','B1 ABS37155','A2 FE FDB1635','A1 0986495213','A5 42628','C4 FDB1398W','C4 GDB1386','A1 WBP559','B1 LUCGDB1658DTE','A9 BP85072','A1 LP1514','A2 BD S003S','A9 RH 2633.41','A8 230 398','C4 05P692','B1 BREP85072','C4 GDB1386DTE','A1 WBP296','A5 73577','C4 GDB2108','A9 0986494019','A8 205 370','B1 BOS0986494525','A1 13.0460-7117.2','A1 13.0470-7117.2','A1 GDB1984','A1 V10-90001','A2 GDB1984','A2 GDB1984DTE','A3 CIF 822-211-2','A5 194987','A5 87360','A8 230 126','A8 234 125','A9 13.04707117.2','A9 GDB1984','A9 GDB1984DTE','B1 ATE13.0470-7117','B1 BLPADV184201','B1 BLPADV184202','B1 CIF822-211-2','B1 FEB16328','B1 KAMJQ1012796','B1 LUCGDB1984','B1 LUCGDB1984DTE','B7 B110690/DKM','C4 GDB1984','C4 GDB1984DTE','C4 KRO1984','C4 LD7117','C9 13.0470-7117.2','C9 19-0613','C9 23131 00 702 10','C9 GDB1984','C9 GDB1984DTE','C9 QP2226','C9 QP2226C','D1 BP ADV184201','D1 BP ADV184202')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #