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 BP23108','A2 13.04603982.2','C9 VAL598670','A1 LP1722','C9 GDB1654','A1 WBP493','A8 223 113','A1 116055 FE','A3 BOS 0986494113','A8 233 728','A1 598426','B7 0858.01/REM','A5 194955','A9 0986494070','A2 GDB1654','A9 13.04603982.2','A3 BOS 0986495097','A2 GDB1482','C4 GDB1654','C9 0986494113','B1 BOS0986494113','B7 23705.180.1','A1 13.0460-3982.2','A2 0986494070','A1 LP2015','A1 13.0460-3826.2','A2 13.04603826.2','A2 13.04703982.2','B1 VAL301426','A2 07.B314.04','A2 0986495097','A5 115887','A2 05P1225','C9 13.0470-3982.2','B1 BREP23085','C9 23979 00 701 10','C9 13.0460-3826.2','B1 ZIM23705.980.1','A1 0986494070','B1 BOS0986494070','E3 23705.180.1','A3 DLP LP1722','A1 P23108','C4 KRO1482','A3 ROA 285811','B1 ZIM23705.180.1','A2 0986494113','C9 0986494070','A8 230 951','B7 0858.11/REM','C4 0986494113','A1 GDB1654','C4 GDB1482','B1 ABS37280','B1 ATE13.0460-3982','B1 BREP23108','C4 05P1225','C9 VAL301426','A1 GDB1482','A3 CIF 822-321-0','C4 0986495097','A1 13.0470-3982.2','A9 GDB1654','C4 603982','A1 GDB1853','A9 13.04603826.2','A9 BP23108','B1 ATE13.0470-3982','B1 ATE13.0460-3826','A2 LP1722','A2 RH 2858.11','A9 13.04703982.2','C9 13.0460-3982.2','A8 224 494','B1 LUCGDB1482','B1 FEB116055','C9 VAL598426','A9 GDB1482','A1 0986494113','A9 BP23085','C9 GDB1482','A8 230 481','C4 603826','A9 0986494113','A1 0986495097','B1 LUCGDB1654','A3 BOS 0986494070','A8 223 112','A2 BP23085','A1 P23085','A5 76251','C4 KRO1654','C4 LP1722','C4 23705.180.1','B1 CIF822-321-0','A3 DLP LP2015','A8 222 498','A1 573074D JRD','A1 FDB1466','A1 FDB1946','A1 GDB1700','A1 GDB1746','A1 GDB1750','A1 GDB1842','A1 GDB1891','A1 WBP402','A2 FE FDB1466','A2 GDB1700','A2 GDB1842','A2 Q109-1298','A2 RH 21100.11','A2 RH 2858.30','A2 RH 2858.32','A3 FER FDB1466','A3 FER FDB1946','A3 QUI 109-1298','A3 ROA 2110011','A3 ROA 285830','A3 ROA 285832','A5 170141','A5 285259','A5 398235','A5 42644','A8 230 420','A8 230 466','A8 241 206','A8 241 377','A9 FE FDB1466','A9 FE FDB1946','A9 GDB1654DTE','A9 GDB1700','A9 GDB1700DTE','A9 GDB1746','A9 GDB1750','A9 GDB1842','A9 GDB1891','A9 Q109-1298','A9 RH 21100.11','A9 RH 2858.30','A9 RH 2858.32','B1 BLPADL144201','B1 FEB16555','B1 FEB16876','B1 KAMJQ101064','B1 LUCGDB1482DTE','B1 LUCGDB1654DTE','B1 LUCGDB1700','B1 LUCGDB1700DTE','B1 LUCGDB1746','B1 LUCGDB1750','B1 LUCGDB1842','B1 LUCGDB1891','B1 QB109-1298','B7 0858.30/REM','B7 0858.32/REM','B7 1100.11/REM','B7 B110185/DKM','C4 05P1264','C4 16555F','C4 16876F','C4 FDB1466','C4 FDB1946','C4 GDB1654DTE','C4 GDB1700','C4 GDB1700DTE','C4 GDB1746','C4 GDB1750','C4 GDB1842','C4 GDB1891','C4 KRO1700','C9 0252370517/PD','C9 0252370517/W','C9 13.0470-3826.2','C9 19-1981','C9 ADL144214','C9 GDB1482DTE','C9 GDB1654DTE','C9 GDB1700','C9 GDB1700DTE','C9 GDB1746','C9 GDB1750','C9 GDB1842','C9 GDB1891','C9 QB109-1298','D2 GDB1746')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #