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 ('E1 85 91 6800','A1 WBP505','A3 BOS 0986424566','A2 FE FDB771','C9 2151504','B1 BREP28020','A2 GDB1319','C9 21515-18,0 1 4','B1 VAL301022','A8 230 245','C9 24996-17,0','A9 21515 180 15','C9 GDB1319','A3 FER FDB771','E1 85 91 6114','B1 BOS0986424214','A9 GDB1319','A5 33396','A2 T 2151504','C4 05P922','A3 DLP LP911','A3 BOS 0986495228','B1 BOS0986424566','A2 21515 180 15','A1 16355 FE','A1 GDB496','A8 230 332','A3 BOS 0986424214','A1 GDB1319','A1 598022','C4 GDB1319','B1 BREP52020','A1 0986495018','A3 DLP LP1450','A9 FE FDB1291','A1 16800 FE','A2 LP1450','C9 0986424214','A9 13.04602803.2','B7 BP-2025/KAVO','A1 FDB771','B1 KAMJQ1011226','A9 13.04605830.2','A2 GDB3267','A2 BP52020','A1 571438J JRD','D1 BP ADJ134214','C4 LP911','E6 BP1361','A8 219 694','A3 ROA 233702','B1 ATE13.0460-5830','C9 ADH24260','B1 LUCGDB1083','E7 177.0','C4 GDB496','B1 LUCGDB3267','A1 GDB1083','A2 GDB496','A1 573203J JRD','A1 FDB613','B7 0337.02/REM','A1 LP1450','C9 GDB1083','A2 RH 2337.10','A2 RH 2490.02','A1 FSL1291','B1 LUCGDB496','A2 13.04605830.2','A3 TEX 2151503','B1 BLPADJ134214','C4 LP1450','A2 FE FDB1291','A1 16114 FE','A3 ROA 233710','A1 J3604031HB','A3 TEX 2499601','B1 FEB16800','A2 FE FDB613','D1 BP ADH24260','A1 P28020','A1 0986424214','C9 13.0460-2803.2','A3 CIF 822-174-0','B1 CIF822-174-0','A9 0986424214','B1 ATE13.0460-2803','B7 0490.02/REM','C4 602803','A1 F026000057','B1 BREP44010','C4 0986424214','A9 GDB496','A2 05P430','A2 BP44010','C9 PA-427AF','A9 GDB3267','A1 LP911','A5 152733','A1 GDB3267','A2 05P922','B7 21515.175.1','C9 VAL301022','C9 19-2940','C4 LP879','C4 KRO1319','A5 7444','B7 KBP-2006/KAVO','A1 LP879','C9 VAL598022','A1 P52020','A2 RH 2337.02','A2 13.04602803.2','B1 ZIM21515.175.1','A2 0986424214','A1 0986424566','C9 GDB3267','C4 05P430','A1 13.0460-5830.2','A3 FER FDB613','E1 22 91 6355','C9 0252151518/W','A2 BP28020','C9 0986424566','A2 LP911','C9 GDB496','B7 0337.10/REM','A2 LP879','C4 1170646','A8 201 739','A3 JAP PA-427AF','A8 209 754','C9 0252151518/PD','A1 WBP200','C9 21515 00 702 10','A1 FSL613','C9 PF0484','A3 FER FDB1291','A1 13.0460-2803.2','A9 BP44010','A2 0986495233','A1 P44010','A8 224 286','B1 BLPADH24260','B1 FEB16114','A1 0986495233','A1 0986495228','A3 ROA 249002','C9 21515-18,0','B1 LUCGDB1319','C9 2151503','B7 B110661/DKM','C9 13.0460-5830.2','A1 FDB1291','A9 BP28020','C9 FDB613','A3 TEX 2151504','C9 19-0543','B1 FEB16355','C4 16114F','C9 ADJ134214','A3 BOS 0986495018','A9 FE FDB613','B7 50427/JAPKO','B1 KAMJQ101194','A3 DLP LP879','A1 2453701 TEX','A1 P44016','A2 Q109-1276','A3 QUI 109-1214','A3 TEX 2453701','A8 225 954','A9 BP44016','A9 Q109-1276','B1 BREP44016','B1 QB109-1214','B1 QB109-1276','C4 2453701TX','C9 2453701','C9 24537-15,7 1 4','C9 QB109-1276','C9 QP3947','C9 QP3947C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #