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 19-0666','A1 FVR4036','A2 13.04604877.2','A2 GDB1698','A1 0986494293','B1 LUCPFK1403','B1 VAL301882','A2 10 91 6710','B1 CIF822-1139-0','A3 CIF 822-671-0','B1 CIF822-671-0','A2 13.04604826.2','A8 260 532','C9 2919202','C4 2922901TX','A9 FE FVR4036','C9 2922901','A3 TEX 2919202','C9 GDB1698','C4 GDB1747','A1 FVR4469','C4 LP1982','B7 22062.210.1','A5 206699','A5 195024','C4 604877','A1 16710 FE','A2 0986494293','C4 FVR1778','B1 ATE13.0460-4877','B7 29192.210.1','C9 FVR1778','A1 LP1982','A3 DLP LP2039','C9 2919209','A9 0986494293','B1 ATE13.0460-4830','C6 106196','B1 BREP50085','C9 0252919220/PD','C4 29192.210.2','B1 BOS0986494728','C9 29192-20,9','A9 RH 21245.10','B7 1245.00/REM','A9 BP50085','C9 0986494914','B7 29192.210.2','A9 FE FVR1778','A5 123202','C4 2919202TX','A9 RH 21245.00','A5 73209','A1 GDB1747','B7 1245.10/REM','C9 QP7918','B1 BOS0986494914','B1 BOS0986494293','C4 FVR1778W','A3 JAP PA-0538AF','C4 604826','A3 ROA 2124510','A3 BOS 0986494293','A9 BD S426','B1 ZIM22062.210.1','C9 LP2039','A9 T 2919202','B1 ATE13.0460-4826','C4 KRO1698','B1 LUCGDB1698','A5 76309','B1 LUCGDB1747','A3 DLP LP1982','A9 GDB1698','A2 FE FVR1778','B1 VAI30-8196','E7 687.0.T','B1 TOM1812','C9 0986494121','A8 230 439','C4 LP2039','A1 LP2039','A2 LP2039','C9 VAL598882','C9 13.0460-4826.2','A1 0986495098','B1 ZIM29192.210.2','A5 168081','A8 222 424','C9 PA-0538AF','A2 BP50085','B1 FEB16710','C4 05P1275','A1 13.0460-4877.2','A1 WBP678','A3 VAC V30-1696','C4 FSL1778','B7 B110934/DKM','A2 0986494121','E1 10 91 6710','C9 QP7918C','A2 T 2919202','A8 236 925','A9 BD S456','A1 0986495113','B1 KAMJQ1012087','A1 0986494121','C9 PA-0014AF','A9 13.04604826.2','C9 GDB1747','A2 GDB1747','A9 13.04604877.2','A3 BOS 0986494121','C9 13.0460-4877.2','C4 29192.210.1','A3 FER FVR1778','C9 PF0298','B1 BOS0986494582','A8 227 631','C4 0986495098','A3 BOS 0986495113','A3 ROA 2124500','A2 086.325-00','A8 225 849','A3 TRU 02.35.196','A3 TEX 2922901','A1 P50085','E3 29192.210.1','C4 FVR4036','B1 TOM1425','A8 230 418','B1 ZIM29192.210.1','A3 FER FVR4036','E7 687.0','A8 261 324','A8 225 964','C4 604830','A2 FE FVR4036','A3 VAC V30-8196','A3 BOS 0986495098','A2 05P1275','C4 GDB1698','A2 13.04604830.2','C4 0986494121','C9 0986494728','A1 2919202 TEX','A9 13.04604830.2','A2 RH 21245.00','C9 VAL872192','A1 GDB1698','B1 VAI30-1696','A1 WBP419','C4 KRO1747','C9 29229-21,4','A9 0986494121','C9 0252919220','A1 13.0460-4830.2','A2 BD S456','A2 BD S426','A9 GDB1747','A1 13.0460-4826.2','C9 13.0460-4830.2','B1 BOS0986494121','A2 RH 21245.10','B1 TRU02.35.196','B1 ABS37553','A1 FVR1778','A3 FER FVR4469','C9 0986494293','C9 29192 00 703 00','C9 0986494582','C9 0252922920','C9 0252922920/PD')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #