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 ('C4 GDB1330DTE','A3 VAC V10-8178','C4 05P853','A9 13.04602877.2','C9 0986494598','A1 0986495239','C9 VAL598674','B1 ZIM20961.172.1','A2 13.04702877.2','B1 TOM1615','A2 FE FDB1645','A1 0986494923','A1 13.0470-2877.2','C9 0986461769','C9 GDB1475','D1 BP ADV184234','B7 23554.170.3','A9 13.04602864.2','A8 239 355','B1 BOS0986494598','A1 GDB1267','A3 BOS 0986461769','B1 ABS37334','A8 200 292','A2 FE FDB1788','B7 B111104/DKM','A3 BOS 0986424813','A1 0986461769','C9 23823-17,2','C4 05P634','A1 FDB1083-PROMO','A2 0986461769','A1 P85066','B7 23829.170.1','A2 LP1815','C4 2382301TX','A2 LP565','A5 113386','B7 05P634/SUZ','C4 602864','C4 23554.170.3','A1 LP1815','A3 ROA 226305','B7 0263.03/REM','C9 19-0430','A3 TEX 2382301','A8 236 249','A1 FSL1083','A5 347529','A3 VAC V10-8174-1','C9 0986494621','E1 30 91 6639','A1 FDB1645','C9 0252382317/W','B1 BLPADV184234','A1 FDB1788','B1 CIF822-100-1','C4 602877','B1 ATE13.0460-2877','A5 206852','B1 TRU07.35.105','A1 GDB1475','A1 FSL1645','A2 RH 2263.05','A5 289249','A5 50426','A9 05P634','C9 PP-0018AF','B7 23554.170.1','A3 VAC V10-8168','B1 VAI10-8178-1','A1 FDB1083','C4 23829.170.1','A2 GDB1475','A3 FER FDB1788','B1 BOS0986494596','A3 DLP LP565','C9 23823 10 704 10','A5 42596','C9 FDB1788','C4 20961.172.1','B1 BOS0986494923','C4 0986461769','A3 FER FDB1645','B1 VAI10-8178','C1 RH 2263.41','C9 0986424813','A1 573032JC JRD','A1 598674','C4 LP1815','B1 VAL301463','B1 KAMJQ1012166','A9 0986424813','A3 DLP LP1815','C4 0986424813','A2 0986495239','C4 FDB1645','A9 BP85066','B1 ZIM20961.972.1','C9 0252096117','A8 236 862','B7 20961.172.1','C9 23554 10 704 10','A2 23823 172 15','B1 ZIM23554.170.1','C9 13.0460-2864.2','A2 0986424813','B1 LUCGDB1330DTE','A1 FDB1788-PROMO','B1 VAI10-8174-1','A8 234 054','C4 0986495239','A1 598463','A1 13.0460-2864.2','A1 2382301 TEX','A3 CIF 822-100-1','A1 FDB1770','B1 CIF822-100-4','C4 FSL1083','C9 13.0470-2877.2','C9 2382301','B1 BREP85066','A9 GDB1475','A2 13.04602864.2','A2 13.04602877.2','A8 236 938','B1 VAL301674','C4 GDB1475','B7 1163706310/JP','A2 GDB1330DTE','A3 VAC V10-8124-1','C4 KRO1475','C4 23554.170.1','A8 217 313','E3 20961.172.1','A5 131455','A2 FE FSL1083','A3 VAC V10-8124','B7 SP 113','C9 FDB1083','C9 13.0460-2877.2','A9 0986461769','A3 VAC V10-8178-1','A3 ROA 226341','A2 RH 2263.41','C4 07.35.105','A9 FE FDB1083','A1 0986424813','C4 FDB1083W','A2 RH 2263.03','A9 RH 2263.41','A2 BP85066','C9 GDB1330DTE','A2 FE FDB1083','B1 ATE13.0460-2864','B7 0263.05/REM','A8 236 860','A1 GDB1467','C4 FDB1083','C9 VAL598463','B1 LUCGDB1475','C9 0252096117/PD','A9 GDB1330DTE','A1 GDB1330DTE','B1 ZIM23554.170.3','C9 QP8041C','C4 LP565','A1 13.0460-2877.2','B1 ATE13.0470-2877','A3 FER FDB1770','C9 QP8041','A2 23554.170.1','C9 0986494923','A9 FE FDB1788','C9 0986494596','C9 PF0442','A2 FE FDB1770','C4 FDB1788','A2 05P634','A1 WBP351','C9 VAL301463','A3 ROA 226303','B1 BOS0986424813','C9 VAL301674','B1 BOS0986461769','B7 0263.41/REM','A3 TRU 07.35.105','B1 ZIM23829.170.1','A9 13.04702877.2','B7 B110041/DKM','A2 05P853','A1 LP565','A3 FER FDB1083','B1 BOS0986494621','B1 VAI10-8168','A1 571906D JRD','A1 571906JC JRD')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #