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 ('C4 21725.170.1','C9 GDB3331','B1 ZIM21012.150.1','B1 ABS36717','B7 21012.150.1','A3 JAP PA-339AF','A9 BP30001','C4 FSL435','B1 TOM1106','A3 ROA 240402','A1 50-03-339ASK','A2 FE FDB4076','B1 VAL301574','C9 VAL598051','C4 J3604020','A1 598051','C4 2101202TX','A1 FDB4076','C9 VAL301052','A3 BOS 0986495221','B7 KBP-3033/KAVO','B1 FRE940036','A2 LP704','A8 217 243','B7 0224.02/REM','A2 13.04605872.2','A1 J3604020HB','A2 J3604020','C9 19-1763','B1 ATE13.0460-5872','A2 05P348','C4 LP704','B7 21012.150.2','A2 RH 2404.02','A2 05P1222','B7 21725.170.1','A2 RH 2224.22','A9 J3600539','A1 WBP201','C9 QP0745','C4 GDB3331','B7 0224.22/REM','C4 05P542','A1 GDB3331','A9 13.04605936.2','B1 ZIM21012.150.2','A1 13.0460-5872.2','A8 241 336','A2 J3600539','B1 BLPADG04202','B1 TOM1107','A2 05P364','B7 KBP-3028/KAVO','C4 05P348','A8 230 313','C4 GDB893','C4 FDB4076','A3 ROA 222422','B7 50339/JAPKO','B1 LUCGDB893','B1 BREP30001','C9 VAL598052','A8 201 185','C9 ADG04202','B1 ABS36792','A9 BP30024','A2 13.04605936.2','C9 0986494620','A2 21012 148 05','A5 201662','D2 EO 2404.02','A9 RH 2224.22','B1 CIF822-188-0','B1 TOM1105','A2 BP30024','B1 CIF822-723-0','A9 FE FDB4076','A9 0986461127','A3 ROA 218202','A2 05P542','C9 0252101214/W','B7 KBP-3001/KAVO','C9 PF0459','A3 TEX 2101202','A1 0986461127','D1 BP ADG04202','A2 05P579','B1 ZIM21725.170.1','A8 256 617','A3 DLP LP704','A5 31279','A2 RH 2224.02','C9 0986461127','A3 TRW GDB373','C4 J3600539','B7 BP-3004/KAVO','A3 CIF 822-188-0','A2 21012 148 04','A9 13.04605872.2','A1 FDB435','A9 05P364','B1 ABS36172','B1 ATE13.0460-5936','A3 ROA 222400','B1 BOS0986494620','B7 B110304/DKM','A2 LP593','A2 0986495035','A3 ROA 214700','A3 TEX 2101204','A1 P30024','A2 0986461127','A1 WBP352','E1 90 91 6683','B1 KAMJQ101870','A9 J3600515','A9 21012 148 05','B1 BOS0986461127','A5 34843','A1 LP593','A2 GDB893','C9 PA-339AF','A3 CIF 822-081-1','A1 J3600515HB','C9 GDB373','A2 J3600515','C9 21012 00 701 00','B1 LUCGDB3331','C9 GDB893','A1 0986495035','A3 VAC V52-0012','A1 0986495221','A9 GDB3331','C4 FDB435','C4 2101204TX','A9 GDB893','A1 LP704','A1 P30001','B7 BP-3001/KAVO','A8 207 862','A5 32375','A3 FER FDB4076','A1 GDB893','C9 0252172517/W','C9 19-0538','C9 13.0460-5872.2','B1 VAL301052','A9 21012 148 04','C4 J3600515','A2 05P083','C9 VAL301574','A3 ROA 222402','A2 GDB3331','A5 206722','B1 LUCGDB373','A2 FE FDB435','B1 VAI52-0012','B7 0224.00/REM','C9 21012-14,8 0 4','E7 P3243.02/W','C9 2101202','A1 0986424135','A3 BOS 0986461127','B1 CIF822-081-1','B7 SP 207','A1 GDB373','A3 FER FDB435','A1 FSL435','A3 DLP LP593','A1 598052','A8 236 861','C9 21012-14,8','C9 0252101214','A1 13.0460-5936.2','A3 BOS 0986495035','C4 05P1222','B1 BREP30024','A2 BP30001','C9 PA-142AF')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #