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 ('A1 FSL1635','A3 TEX 2313101','A3 VAC V10-8110-1','C4 607117','A1 P85072','A1 WBP452','C4 LP1104','A9 FE FDB1398','A3 BOS 0986494019','C9 2313101','A9 23131 197 05','C9 GDB1386DTE','C9 ADV184201','A2 13.04607117.2','C4 GDB1386DTE','C9 23131-19,0','C4 0986495048','B1 FEB16446','A9 0986494019','A3 BOS 0986494525','A2 BP85072','C4 0986494525','C4 0986494524','A3 DLP LP1514','A9 GDB1386DTE','A1 WBP296','A9 05P692','A8 232 187','A3 TEX 2313181','A8 243 464','A2 13.04707117.2','A1 LP1104','B7 23131.195.1','C9 13.0470-7117.2','A3 BOS 0986494524','C9 0986494019','E1 30 91 6446','C4 FDS1398','A1 16617 FE','A8 220 324','C4 LP1514','B1 VAI10-8110','A1 FSL1398','A1 0986494019','B1 FEB16330','A8 215 158','E1 30 91 6332','C4 0986494019','B7 05P692/SUZ','A1 FDB1398','A1 598408','A5 42628','A9 13.04707117.2','B1 FEB16332','A1 16446 FE','C9 0986494525','A1 16330 FE','A1 13.0463-7117.2','A2 GDB1386DTE','A1 0986495048','A1 571971D JRD','A1 WBP698','A3 BOS 0986495213','A2 LP1514','C4 FDB1635','A9 13.04607117.2','B1 BOS0986494525','B7 0633.41/REM','C9 FDB1398','A3 BOS 0986495048','A1 0986495213','A2 23131 197 05','A9 BP85072','B1 BOS0986494524','C9 13.0460-7117.2','B1 LUCGDB1386DTE','A2 0986495048','B1 VAI10-8110-1','A2 05P692','C9 224745','A2 LP1104','A1 GDB1386DTE','A3 VAC V10-8110','A1 0986494525','C9 0252313119/PD','A5 116698','C9 23131-19,7 EPAD','A2 0986494019','A2 FE FDB1635','A5 40476','A2 0986495213','C4 23131.195.1','C4 FSL1635','A1 FQT1635','A1 571971JC JRD','A1 13.0470-7117.2','C4 05P692','A1 13.0460-7117.2','A3 FER FDB1635','A1 16332 FE','A1 WBP296B','C9 0252313119/W','C9 VAL301408','A2 RH 8633.01','C4 2313101TX','A1 FSL1398-PROMO','D1 BP ADV184201','A1 0986494524','B1 ATE13.0460-7117','C4 LD7117','C4 0986495213','A3 FER FDB1398','A8 205 370','A1 LP1514','A5 73577','A9 FE FDS1398','A2 T 2313181','B7 0633.21/REM','B1 FEB16617','B1 ATE13.0470-7117','B1 BOS0986494019','A1 0986424503','A3 DLP LP1104','A1 FDB1635','A1 FQT1398','C4 FDB1398W','B1 VAL301408','B1 BREP85072','A5 87360','C9 0986494524','A1 2313101 TEX','B1 ZIM23131.195.1','A8 234 061','C4 16446F','A2 FE FDS1398','A2 FE FDB1398','C9 2313181','A2 FE FSL1398','B1 ABS37155','C4 FDB1398','B1 BLPADV184201','C9 VAL598408','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)) #