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 0986494525','B1 FEB16332','A1 FQT1635','A1 0986495048','A1 0986495213','C4 FDB1398','C4 GDB1386DTE','A1 WBP296','A1 16332 FE','A9 05P692','A2 0986495048','B1 BLPADV184201','A2 FE FDS1398','B7 23131.195.1','C9 GDB1386DTE','B1 ABS37155','A5 87360','A1 571971JC JRD','E1 30 91 6446','A8 215 158','A5 42628','B1 FEB16617','C9 FDB1398','A1 13.0463-7117.2','A1 FDB1635','B1 ATE13.0470-7117','C4 FSL1635','A1 FQT1398','A3 FER FDB1398','B1 BOS0986494019','A3 TEX 2313101','B1 VAI10-8110-1','A1 16617 FE','A1 GDB1386DTE','C9 13.0460-7117.2','B1 BOS0986494524','A1 WBP296B','A9 FE FDS1398','C4 0986494524','A1 WBP698','C9 ADV184201','A2 23131 197 05','B7 0633.41/REM','C4 LD7117','A3 DLP LP1514','A1 0986424503','A2 BP85072','A2 FE FSL1398','A1 FSL1398-PROMO','C9 23131-19,0','A3 TEX 2313181','A8 220 324','A8 243 464','C4 0986495048','A2 LP1514','C9 0986494524','A2 RH 8633.01','C4 607117','C4 05P692','A9 0986494019','A2 05P692','A1 LP1514','B1 FEB16446','A2 T 2313181','A1 LP1104','C4 23131.195.1','A3 FER FDB1635','A1 FDB1398','A3 BOS 0986494525','A9 13.04707117.2','C9 23131-19,7 EPAD','A2 0986494019','A5 116698','C4 2313101TX','C9 0252313119/PD','A2 LP1104','A1 P85072','A1 0986494525','A2 0986495213','A1 0986494524','C4 0986494525','A1 13.0460-7117.2','C9 0986494019','A1 FSL1398','A8 205 370','A9 23131 197 05','C4 LP1514','B1 ATE13.0460-7117','C9 VAL598408','C4 FDB1398W','A1 13.0470-7117.2','A3 BOS 0986494524','A1 0986494019','B1 FEB16330','A1 FSL1635','B1 ZIM23131.195.1','A5 73577','C4 0986495213','A3 BOS 0986495048','C9 2313181','A2 FE FDB1635','A1 2313101 TEX','C9 224745','A3 VAC V10-8110','C4 LP1104','A9 13.04607117.2','A1 16330 FE','B1 BREP85072','E1 30 91 6332','B1 LUCGDB1386DTE','C4 16446F','A2 13.04707117.2','B1 BOS0986494525','A9 GDB1386DTE','A1 16446 FE','A5 40476','C4 FDB1635','A9 BP85072','B7 0633.21/REM','B1 VAI10-8110','A8 234 061','A1 571971D JRD','A3 BOS 0986494019','A8 232 187','A1 WBP452','A2 13.04607117.2','A1 598408','A3 DLP LP1104','A3 BOS 0986495213','C9 0252313119/W','C9 2313101','A3 VAC V10-8110-1','C9 VAL301408','A9 FE FDB1398','B7 05P692/SUZ','C9 13.0470-7117.2','C4 FDS1398','B1 VAL301408','C4 0986494019','A2 GDB1386DTE','A2 FE FDB1398','D1 BP ADV184201','A1 P85072X','A1 V10-90001','A2 BD S003S','A2 Q113-1306','A2 Q113-1306X','A2 RH 2633.21','A2 RH 2633.41','A3 CIF 822-211-2','A3 JAP PA-0043AF','A3 QUI 113-1306','A3 QUI 113-1306X','A3 ROA 263321','A3 ROA 263341','A8 203 802','A8 204 498','A9 BD S003S','A9 Q113-1306','A9 Q113-1306X','A9 RH 2633.21','A9 RH 2633.41','B1 BREP85072X','B1 CIF822-211-2','B1 KAMJQ1012796','B1 QB113-1306','B1 QB113-1306X','B1 ZIM23131.995.1','B7 B110690/DKM','C9 19-0613','C9 23131 00 702 10','C9 QB113-1306X','C9 QP2226','C9 QP2226C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #