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 ('B1 TOM1444','A3 DLP LP2230','C9 23979-17,8','C4 GDB1654','A8 223 112','A1 GDB1891','A9 0986494113','A9 23706 178 15','C4 0986424597','C9 GDB1654','C4 GDB1842','B1 ZIM23705.180.1','B1 TOM12482','A3 BOS 0986494113','A3 ROA 285912','A2 0986424597','A2 GDB1654DTE','C9 GDB1654DTE','B1 CIF822-322-3','B1 BOS0986494881','A2 RH 2859.12','C9 PF0560','A2 LP2276','C9 0986494881','C9 2397901','C9 0986494113','C4 23705.180.1','A9 0986424597','A3 DLP LP2276','B1 BOS0986424597','C9 13.0460-3863.2','A5 487890','A1 GDB1842','C9 0252370517/W','C9 19-3661','A2 FE FDB1946','A3 BOS 0986424597','B1 ZIM23706.180.2','A5 42644','C4 GDB1891','A3 FER FDB1946','A2 0986494113','A5 206687','C9 FDB1466','A8 224 494','A9 FE FDB1466','A3 FER FDB1466','D2 EO FDB1946','B1 LUCGDB1891','A1 GDB1654DTE','A9 ABS37800','B1 CIF822-321-0','C4 LP2230','B1 ATE13.0460-3863','A1 FDB1466','A1 LP1722','C9 GDB2164','B7 0858.32/REM','A9 FE FDB1946','A9 GDB1654DTE','A1 573074D JRD','C9 VAL598426','A9 GDB1654','C4 FDB1946','C9 0252370918/W','B1 LUCGDB2164','A8 223 111','A3 ROA 285811','C9 FDB1946','A2 13.04603863.2','A3 DLP LP1722','C9 0986494698','A2 RH 2858.11','A2 23706 178 15','A3 CIF 822-321-0','B7 23706.180.2','C9 VAL301051','A1 598426','A2 LP1722','C9 VAL301426','C4 0986494113','A2 FE FDB1466','A2 GDB1891','E3 23705.180.1','A1 WBP707','B1 LUCGDB1654DTE','A5 439590','C9 VAL598698','A1 573074JC JRD','A5 41137','A9 T 2397901','C9 PF0221','A3 VAC V24-0064','B1 BOS0986494698','C9 2370601','C4 16876F','E1 70 91 6876','C4 FSL1466','B1 FEB16876','B1 LUCGDB1842','A8 227 771','A3 VAC V24-0151','A3 TEX 2397901','C9 QP4293C','A2 RH 2858.32','B1 LUCGDB1654','A8 222 498','A2 GDB1654','B1 FRE901298','A2 ABS37800','C9 GDB1842','C4 GDB1654DTE','C4 KRO1654','A1 0986424597','A9 GDB1842','A3 ROA 285832','A8 230 466','A9 RH 2858.32','B1 ZIM23705.980.1','A2 T 2397901','B7 23706.180.3','B7 0858.11/REM','B1 ABS37800','C4 FDB1466','A1 0986494113','E7 AC058764AD','A9 GDB1891','B1 BOS0986494113','A1 16876 FE','C9 0252370918/PD','C4 603863','A1 LP2230','B1 CIF822-321-3','A1 598698','C9 0252370517/PD','B7 B110185/DKM','C4 LP1722','B1 VAL301426','C9 VAL598670','C4 LP2276','A1 LP2276','A3 TEX 2370601','B7 23705.180.1','B1 VAI24-0064','C9 0252370617/W','A8 233 728','B1 ZIM23706.180.3','A1 13.0460-3863.2','A1 GDB1654','B1 VAI24-0151','B1 TOM1445','C9 23979 00 701 10','A8 215 038','C9 PA-0015AF','C9 23706-17,8','A1 FSL1466','B1 BREP23141X','C9 QP4293','B1 ABS37871','A9 13.04603863.2','A1 FDB1946','A3 CIF 822-322-3','A2 GDB1842','B1 VAL302459','A8 241 206','C9 GDB1891','B1 VAL301051','C9 0986424597','A1 2370502 TEX','A1 P23085','A2 23705 178 15','A2 BP23085','A3 TEX 2370502','A8 207 614','A8 233 950','A9 23705 178 15','A9 BP23085','B1 BREP23085','C4 2370502TX','C9 19-0514','C9 2370502','C9 QP6350','C9 QP6350C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #