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 ('A2 BP23085','A3 ROA 285811','A1 GDB1853','A8 230 481','C9 GDB1482','A5 398235','A2 0986494070','A8 215 038','C4 GDB1654DTE','C4 GDB1482','A1 13.0460-3982.2','B1 TOM1248','A2 0986424597','B1 CIF822-321-1','B1 ABS37817','A1 598426','B1 BOS0986494132','C4 23705.180.1','C9 VAL301913','B1 BLPADL144214','C9 FDB1466','C4 KRO1654','C9 23705-17,8 EPAD','B7 0858.01/REM','B1 BREP23108','A1 FSL1466','A1 WBP707','A2 13.04603982.2','C9 GDB1654','C9 ADL144214','A2 05P1264','C9 PA-0015AF','B7 0858.30/REM','A9 BP23108','A1 GDB1590','B1 LUCGDB1654','A1 0986494132','C9 GDB1590','A1 LP2015','E7 P9583.30/W','A3 BOS 0986494132','B1 LUCGDB1482','A2 GDB1590','B1 ZIM23705.180.1','B1 ABS37280','C4 GDB1654','C9 19-0514','A1 573074D JRD','C9 19-1981','A9 GDB1654','B1 VAL301913','A8 230 367','A2 GDB1482','B7 B110185/DKM','B1 ATE13.0460-3982','A2 LP1722','A2 RH 2858.01','C4 05P1264','A8 222 498','B1 ATE13.0470-3826','B1 LUCGDB1654DTE','B1 BOS0986494113','A5 194955','E3 23705.180.1','B7 0858.11/REM','A9 GDB1590','B1 LUCGDB1590','A2 RH 2858.10','C4 FDB1466','A8 223 112','A3 BOS 0986424597','B7 23705.180.1','B1 LUCGDB1879','A1 573074JC JRD','A9 13.04603982.2','A1 13.0470-3826.2','B1 ZIM23705.980.1','A1 0986494070','C4 05P1266','A5 41137','A9 0986494132','C9 13.0470-3826.2','B1 BOS0986424597','E1 70 11 6055','A1 FDB1466','C9 0986494113','A3 DLP LP2015','C4 LP1722','A8 233 950','A1 GDB1879','B1 CIF822-321-4','A2 FE FDB1466','A2 GDB1879','A3 ROA 285810','A5 42644','A2 GDB1654','C9 GDB1654DTE','B1 BOS0986494070','B1 CIF822-321-0','A3 BOS 0986494113','A3 CIF 822-321-0','A9 GDB1482','C9 VAL872705','A9 FE FDB1466','A3 DLP LP1722','C9 0986494132','A3 FER FDB1466','A9 BP23085','A9 RH 2858.30','C9 13.0460-3982.2','C4 FSL1466','A1 0986424597','C4 KRO1482','A2 05P1266','A9 GDB1654DTE','A2 0986494113','A9 GDB1879','A2 0986494132','C9 VAL598670','A9 0986494113','A2 BP23108','A3 BOS 0986494070','B1 BREP23085','A9 0986494070','A2 RH 2858.30','A3 ROA 285830','C9 0986424597','A8 224 494','C4 603982','A3 ROA 285801','C4 0986494132','A1 GDB1482','C9 23705 00 701 10','A8 230 951','A1 0986494113','C4 0986424597','A1 LP1722','A2 RH 2858.11','C9 0986494070','D1 BP ADL144214','A3 TEX 2370581','A1 P23085','C4 0986494113','A9 0986424597','C9 GDB1879','A1 P23108','C4 GDB1590','A1 GDB1654DTE','E1 70 91 6555','A1 GDB1654','C9 VAL598426','A2 GDB1654DTE','A1 13.0460-3826.2','A1 FDB1666','A1 GDB1700','A2 GDB1700','A2 Q109-1298','A3 QUI 109-1298','A5 170141','A5 76251','A5 76374','A8 221 262','A8 230 420','A9 13.04603818.2','A9 13.04603826.2','A9 GDB1700','A9 GDB1700DTE','A9 Q109-1298','B1 ATE13.0460-3818','B1 ATE13.0460-3826','B1 ATE13.0470-3982','B1 BLPADL144201','B1 FEB16555','B1 FEB16859','B1 KAMJQ101064','B1 KAMJQ1012932','B1 LUCGDB1482DTE','B1 LUCGDB1700','B1 LUCGDB1700DTE','B1 QB109-1298','B1 VAL301426','B1 VAL301825','C4 16555F','C4 603826','C4 FDB1666','C4 GDB1700','C4 GDB1700DTE','C4 KRO1700','C9 0252370517/PD','C9 0252370517/W','C9 13.0460-3818.2','C9 13.0460-3826.2','C9 13.0470-3982.2','C9 GDB1482DTE','C9 GDB1700','C9 GDB1700DTE','C9 QB109-1298')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #