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