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 13.04703982.2','C9 23705-17,8 EPAD','D2 EO FDB1946','A3 FER FDB1666','C9 QP5786','C4 GDB1654DTE','A3 TEX 2397903','A1 GDB1482','A3 DLP LP2015','C9 13.0460-3818.2','C9 0252370718','C9 VAL301426','B1 TOM1444','A3 CIF 822-321-0','B1 BOS0986494132','A9 FE FDB1466','C9 VAL301913','B1 LUCGDB1654DTE','C9 PF0430','A1 13.0470-3826.2','B1 BOS0986494070','A1 13.0460-3818.2','C9 2370502','A1 P23140','A9 13.04703982.2','A1 WBP493','A1 LP2015','A2 13.04603818.2','A1 GDB1482DTE','E3 23705.180.1','A2 LP1722','A3 FER FDB1466','B7 05P763/SUZ','C9 0252370617/W','A8 230 367','A2 0986494113','A2 LP2276','A1 GDB1891','A1 573074D JRD','A2 23706 178 15','A3 BOS 0986494132','C4 LP1722','C9 GDB1891','A9 FE FDB1946','A9 0986494113','A2 0986494070','C4 FDB1946','C4 KRO1654','A8 223 113','C4 0986495102','A3 BOS 0986495102','A2 13.04603863.2','A1 LP1722','A1 GDB1654DTE','C9 0252370517/PD','B1 VAI24-0099','A1 13.0460-3982.2','A1 GDB1590','C9 PF0456','A2 GDB1590','C9 19-3661','A9 GDB1842','C9 GDB1590','A9 23705 178 15','B1 ATE13.0460-3810','A2 T 2370503','B7 23705.180.1','C9 0986494113','D1 BP ADL144201','B1 KAMJQ101064','C9 2370601','C4 FDB1666','B1 BREP23085','C4 603982','C4 0986424597','A3 DLP LP1722','A1 0986494070','C9 GDB1482','A1 GDB1842','A3 DLP LP1899','A1 0986424597','A2 RH 2858.32','A1 573074JC JRD','C4 05P1264','B1 ABS37280','A5 487890','A3 CIF 822-159-1','C4 2397903TX','A5 76251','C4 GDB1842','A2 0986424597','B7 B110185/DKM','B7 0858.32/REM','A8 230 481','B7 0858.01/REM','A2 FE FDB1666','C9 VAL872705','C9 0252370517/W','C4 05P1225','A2 23705 178 15','A5 194955','A9 05P763','C4 GDB1482','B7 B111242/DKM','A2 GDB1654DTE','A1 0986495102','A5 41137','C4 23705.180.1','C4 GDB1590','C9 0986494132','C9 23706-17,8','C9 PF0123','A2 05P1264','A8 230 466','A1 13.0460-3863.2','B1 ZIM23705.180.2','A2 13.04603982.2','A8 223 111','B1 BOS0986494113','B1 ATE13.0460-3863','C4 0986494132','A3 ROA 285832','A9 BP23108','C9 13.0470-3826.2','A5 76374','C9 VAL598426','A9 13.04603863.2','B1 LUCGDB1891','E1 70 91 6555','B1 VAL301051','C9 23979-17,8','A8 233 728','C4 LP1899','B1 KAMJQ1012932','A8 222 498','A3 VAC V24-0064','A5 206687','C9 2397903','A8 215 038','C9 VAL301051','C4 FDB1466','A1 LP2276','B1 LUCGDB1482','C9 23979 00 701 10','B1 CIF822-321-1','C9 PF0126','A2 T 2397901','A8 233 950','B1 BOS0986424597','C4 FSL1466','C9 0986494881','A1 P23085','C4 GDB1891','A9 GDB1482','C9 GDB1654DTE','A1 13.0460-3826.2','B1 BREP23140','A2 GDB1891','C9 0986424597','C9 FDB1666','B1 BOS0986494698','B1 TOM12483','C9 GDB1842','A8 221 262','A9 BP23085','A3 TEX 2370503','B7 0858.11/REM','B1 ATE13.0460-3982','A1 FSL1466','A8 241 206','A3 FER FDB1946','B1 LUCGDB1482DTE','B1 ATE13.0470-3982','C9 QP4293','C4 2370502TX','C9 13.0460-3863.2','C9 13.0470-3982.2','C9 19-0514','A2 13.04603826.2','B1 ZIM23705.180.1','B1 ATE13.0470-3826','A2 FE FDB1466','A9 RH 2858.32','A1 13.0470-3982.2','A1 P23141','B1 VAL301426','C4 GDB1654','A2 05P1266','C9 23705 00 701 10','A1 GDB1853','A8 227 771','C4 0986494113','B1 TOM1248','B1 BREP23108','B7 23705.180.2','A3 BOS 0986494070','A2 05P763','B1 BOS0986494881','C9 23705-17,8 1 4','C9 0986494070','A2 GDB1842','A2 0986494132','C9 23979-17,8 2 5','A9 GDB1891','C9 QP6350C','B1 CIF822-321-0','A8 207 614','A1 FDB1946','A3 TEX 2370502','A9 23706 178 15','A2 GDB1654','A3 DLP LP2276','A3 BOS 0986494113','C9 QP6350','A1 13.0460-3810.2','A8 224 494','A5 115887','A8 230 951','B1 LUCGDB1590','C9 13.0460-3826.2','C9 FDB1946','A2 GDB1482','B1 ATE13.0460-3818','A9 BP23140','C4 LP2276','B1 ABS37594','A5 398235','B1 LUCGDB1842','C9 PA-0248AF','B1 VAI24-0064','C9 GDB1482DTE','A2 BP23108','A2 13.04603810.2','A1 P23108','A1 WBP329','A2 05P1225','A9 GDB1654','B1 ZIM23705.980.1','C9 13.0460-3982.2','A8 220 652','A3 TEX 2370601','A2 BP23140','C9 23705-17,0','A5 42644','A8 223 112','A3 ROA 285801','A1 LP1899','A5 130897','C4 05P1266','C9 19-1981','C9 500038712','A3 ROA 285811','A9 0986494132','C4 05P763','A3 VAC V24-0099','A1 FDB1466','C9 2397901','A1 0986494113','A1 598426','C9 QP4293C','B1 VAL301913','C4 KRO1482','C9 13.0460-3810.2','A2 FE FDB1946','A9 T 2397901','C9 GDB1654','C9 FDB1466','A2 RH 2858.11','A1 2370502 TEX','B1 BREP23141','B1 CIF822-321-3','A9 13.04603818.2','A1 0986494132','B1 ATE13.0460-3826','A3 TEX 2397901','A1 GDB1654','A2 RH 2858.01','A3 BOS 0986424597','A3 TEX 2370581','B1 BLPADL144201','E6 BP1971','A9 13.04603982.2','C9 QP5786C','A9 GDB1590','C9 PA-0015AF','C9 ADL144201','C9 0986494698','A9 13.04603810.2','A9 GDB1654DTE','B1 LUCGDB1654','C4 603826','A9 13.04603826.2','A9 0986424597','C9 23982 00 702 10','A9 0986494070','B1 CIF822-159-1','C4 603863','A1 FDB1666','A2 BP23085','B1 BREP23141X','A1 WBP707')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #