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 LP2015','A3 BOS 0986494113','A8 215 038','A1 FDB1466','B1 CIF822-321-1','A8 223 111','A3 ROA 285811','A1 GDB1482','B1 ATE13.0460-3826','A8 220 652','C4 0986494113','A3 TEX 2397901','B7 0858.01/REM','B1 VAL301825','A8 230 951','E7 P9583.30/W','C4 0986494132','A9 T 2397901','A9 13.04603826.2','A3 BOS 0986494070','A5 41137','B1 BLPADL144214','A1 13.0460-3826.2','A9 13.04603982.2','B1 CIF822-321-4','B1 FEB16859','C9 GDB1654','C4 FDB1946','C9 GDB1590','A3 ROA 285801','B1 BOS0986494113','C9 ADL144214','A1 0986495237','E3 23705.180.1','A1 WBP493','A2 GDB1482','A1 0986494132','A3 BOS 0986494132','C4 2370502TX','A9 GDB1654','A1 0986424597','A2 0986494070','A1 WBP707','A5 130897','A1 13.0460-3982.2','A9 GDB1879','B1 LUCGDB1482','A2 LP1722','B1 ZIM23705.980.1','B1 ATE13.0460-3818','D2 EO FDB1946','B1 BOS0986494132','A2 FE FDB1946','A2 05P763','C9 PA-0015AF','C9 0986494070','B1 ABS37817','A3 TEX 2370581','B1 ABS37280','A9 0986494070','B7 0858.11/REM','A5 76251','B1 VAL301913','A9 FE FDB1466','A2 RH 2858.10','B1 ZIM23705.180.2','C9 13.0460-3818.2','A8 222 498','A2 FE FDB1466','A9 RH 2858.30','A3 FER FDB1466','B7 0858.30/REM','C9 VAL598426','A2 05P1264','C4 LP1722','B7 23705.180.1','A2 13.04603818.2','E1 70 11 6055','B1 ATE13.0460-3982','A3 TEX 2370502','A2 GDB1590','A3 BOS 0986495097','C4 603826','C4 KRO1654','A1 598426','A9 0986494113','A3 FER FDB1946','A9 05P763','A1 LP1722','A8 207 614','A1 16859 FE','C9 FDB1946','A2 RH 2858.01','A9 13.04603818.2','A9 23705 178 15','C9 VAL301825','A8 233 950','A2 13.04603982.2','A8 230 481','E1 70 91 6859','A2 0986424597','A2 GDB1654','C9 13.0460-3826.2','B1 LUCGDB1590','A1 0986494070','A2 RH 2858.11','C4 KRO1482','C4 FDB1466','A2 T 2397901','A1 GDB1853','C9 23705-17,0','A1 GDB1590','C9 23705-17,8 EPAD','A1 FDB1946','C9 FDB1466','A1 2370502 TEX','C4 2397903TX','C9 23979-17,8','C9 GDB1879','A2 05P1266','C9 VAL872705','A3 ROA 285830','B7 23705.180.2','C4 GDB1590','C9 0986494113','B7 05P763/SUZ','C4 FSL1466','C9 2370502','A3 TEX 2397903','C9 19-1981','B1 LUCGDB1879','A2 0986495237','C9 23979-17,8 2 5','A1 GDB1654','A3 BOS 0986424597','A1 573074JC JRD','C9 0986494132','C4 05P1266','C9 23705 00 701 10','C4 603982','C4 0986495097','A2 RH 2858.30','A1 GDB1879','A9 GDB1482','A8 223 112','C9 2397901','A5 398235','A2 GDB1879','C4 05P1264','D1 BP ADL144214','A2 0986494132','C9 19-0514','A1 0986495097','B1 BOS0986424597','A2 0986495097','A8 230 367','C9 0986424597','A9 0986424597','A2 23705 178 15','C4 05P763','B1 CIF822-321-0','B1 BOS0986494070','A1 13.0460-3818.2','C9 2397903','C4 0986495237','A3 CIF 822-321-0','A8 224 494','A1 573074D JRD','A5 42644','A9 0986494132','C4 0986424597','A3 DLP LP2015','A9 FE FDB1946','C9 GDB1482','A9 GDB1590','B1 LUCGDB1654','A2 0986494113','C9 VAL598670','A5 194955','A3 ROA 285810','C4 GDB1482','C9 13.0460-3982.2','A2 13.04603826.2','C9 VAL301913','A1 0986494113','B1 ZIM23705.180.1','C4 GDB1654','C4 23705.180.1','A5 76374','A3 BOS 0986495237','A3 DLP LP1722','A1 FSL1466','E1 70 91 6555','A1 13.0460-3850.2','A1 LP1899','A1 LP2276','A1 WBP329','A2 Q109-1298','A3 DLP LP2276','A3 QUI 109-1298','A5 80395','A9 13.04603850.2','A9 Q109-1298','B1 ATE13.0460-3850','B1 ATE13.0470-3982','B1 BLPADL144201','B1 FEB16555','B1 KAMJQ101064','B1 KAMJQ1012932','B1 LUCGDB1482DTE','B1 QB109-1298','B1 VAL301426','B7 B110185/DKM','C4 16555F','C4 603850','C4 LP1899','C4 LP2276','C9 0252370517/PD','C9 0252370517/W','C9 13.0460-3850.2','C9 13.0470-3826.2','C9 13.0470-3982.2','C9 GDB1482DTE','C9 QB109-1298','C9 QP5786','C9 QP5786C','C9 QP6350','C9 QP6350C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #