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 ('A1 LP1843','B1 ABS36998','A2 13.04607185.2','C4 2318302TX','B7 23474.195.1','B1 VAI20-4116','A2 BP06043','C9 VAL598811','C9 19-1077','A3 TEX 2096801','C9 13.0460-7185.2','A2 BP06042','A3 FER FDB577','A9 BP06012','B1 BREP06012','A2 0986424767','A3 FER FDB1073','A2 FE FDB577','A9 13.04707155.2','A1 13.0470-7155.2','B1 BOS0986490640','A1 LP1962','B7 0963.00/REM','A1 FDB577','B1 BLPADB114230','E7 AC689481D','A9 T 2318381','B1 ATE13.0460-7155','B1 CIF822-207-5','B1 KAMJQ1012146','A8 228 231','A9 13.04607155.2','C9 23474-20,3','A2 LP1843','C4 FDB1073','A1 P06043','B7 23183.195.9','A3 VAC V20-8100-1','C4 GDB1531','C4 LP602','B1 VAL301231','C9 GDB1531','A1 571880JC JRD','B7 B111110/DKM','A1 WBP122','C9 20968-20,3','C4 GDB916','A1 13.0460-7155.2','C4 05P296','C9 2318381','A3 DLP LP1962','C9 19-1076','A2 13.04707155.2','C9 GDB916','A2 LP602','B1 ZIM23183.195.9','C9 13.0460-6033.2','A3 FER FDB779B','A3 TEX 2318381','A8 229 590','A3 VAC V20-4116','C4 606033','C9 0986424767','A1 FDB1073','C4 08.34.098','A9 23183 203 05','A2 GDB1531','C9 PF0153','A3 TRU 08.34.103','B1 ATE13.0470-7155','C4 607155','A2 05P296','A2 RH 2963.00','C9 2318302','A1 WBP458','E7 P3703.00/W','B1 CIF822-207-3','B1 VAI20-8100-1','C9 23183 00 701 00','A3 TEX 2318302','A3 FER FDB779','A3 VAC V20-8101','A2 13.04606033.2','C9 2347402','A9 BP06043','A2 23474 203 05','A3 ROA 296310','B1 ATE13.0460-7185','A1 GDB1531DTE','A3 FER FSL1073','C9 0252318320','C9 23183-20,3','C9 0252318320/PD','C9 PA-0111AF','C9 2096801','B1 LUCGDB1531','A2 23183 203 05','A3 TRW GDB916','A1 571355D JRD','A2 0986490640','B1 LUCGDB1577','C9 VAL301231','A5 42594','C9 13.0460-7155.2','A9 13.04607185.2','A9 23183.195.1','A5 282151','A2 05P1251','A8 230 204','A2 T 2318381','B1 TOM1320','B1 BREP06042','C9 FDB1073','B7 20968.195.1','A2 23183.995.1','B1 VAL302067','B1 BOS0986424767','A9 BP06042','A3 CIF 822-207-3','C4 0986424767','B1 VAI20-8101','E1 20 91 6442','B7 B110065/DKM','C9 13.0470-7155.2','A3 TEX 2347402','B1 ABS36650','B1 LUCGDB916','A1 2318302 TEX','C4 FDB779','B1 LUCGDB1531DTE','A9 13.04606033.2','A2 FE FDB1073','B1 TRU08.34.103','A1 13.0460-6033.2','B1 ZIM23183.195.1','C9 23183-20,3 EPAD','A2 13.04607155.2','A3 BOS 0986490640','B1 ZIM23183.995.1','A9 23183.995.1','A1 FDB4752','C9 VAL598231','C9 GDB1531DTE','B7 0963.10/REM','C4 KRO1531','A3 TRU 08.34.098','A1 GDB916','B1 BREP06043X','A2 RH 2963.10','B1 TOM10691','A5 18293','C4 GDB1531DTE','B1 ZIM23474.195.1','C4 05P1251','A1 FSL1073','A1 GDB1577','B1 CIF822-122-0','B1 ABS37374','A2 GDB916','A3 ROA 296300','A1 598231','A1 GDB1531','D2 EO FDB1073','A9 GDB916','B1 KAM105051','A9 GDB1531','A2 GDB1531DTE','C4 LP1843','C9 0252096820','C9 FDB4752','A8 202 664','B7 1463600710/JP','A9 23474.195.1','A9 0986490640','B1 TOM1069','B1 BREP06043','A1 P06042','A5 194850','A1 P06043X','A8 200 139','A9 FE FDB1073','A9 RH 2270.00','A1 LP602','B7 23183.195.1','B1 ZIM20968.195.1','A3 DLP LP1843','A2 LP1962','B1 TRU08.34.098','A9 0986424767','C9 0986490640','A9 LP602','A5 131292','C4 23183.195.1','B1 ATE13.0460-6033','A1 P06012','C4 LD7155','A1 FDB779','A2 23474.195.1','A3 FER FDB4752','C9 QP6647','A3 DLP LP602','A1 13.0460-7185.2','C4 FSL1073','A3 BOS 0986424767','A2 BP06012','A3 ROA 227000','A1 0986490640','A5 4700','A2 RH 2270.00','A2 FE FDB779','A1 0986424767','A8 205 375','A9 GDB1531DTE','C9 QP6647C','A2 23183.195.1','B7 0270.00/REM','A9 RH 2963.00','A8 241 291','C9 20968 10 701 00','C9 GDB1577','A5 282323','A1 571994JC JRD','A1 GDB1404','A2 BD S359','A2 GDB1404','A2 RH 2270.25','A3 ROA 227025','A8 230 148','A8 236 681','A9 BD S359','A9 GDB1404','A9 GDB1404DTE','A9 RH 2270.25','B1 LUCGDB1404','B1 LUCGDB1404DTE','B7 0270.25/REM','C4 GDB1404','C4 KRO1404','C9 GDB1404','C9 GDB1404DTE')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #