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 ('A9 BP85037','C9 23018-20,4 EPAD','A2 GDB1307','A9 BP85085','A3 VAC V10-8146','A1 0986494050','A3 BOS 0986494050','B1 ABS37156','B1 VAI10-8144','A8 215 164','A1 P85085','A2 BP85037','A2 FE FDB1717','A2 RH 2390.22','C4 16447F','A5 113387','A9 RH 2390.22','C4 FSL1717','A3 TEX 2301881','B1 LUCGDB1307','A1 2193801 TEX','B1 CIF822-181-3','A8 203 483','A2 05P790','A1 WBP426','C4 FDB1323','C9 FE16447','C9 FE16448','A2 0986424482','B1 VAI10-8181','A1 FSL1717','A1 GDB1307','A1 598483','C9 FDB1717','C4 0986424482','C4 FDS1323','A1 FDB1323','A9 0986494050','B7 SP 259','C9 VAL598483','A1 FQT1323','A9 RH 2390.52','B1 FEB16060','A1 FDB1323-PROMO','B1 BREP85037','C4 KRO1307','A1 0986424706','B1 VAI10-8146','A3 VAC V10-8181','A3 ROA 239022','C9 2301802','A1 16447 FE','A3 CIF 822-181-3','A2 BD S088','C9 21938-20,4','C4 FDB1717','A8 215 149','A1 FSL1323','A2 23018 204 05','A2 T 2301881','A9 FE FDB1717','A8 205 373','A9 21938 204 05','B1 BOS0986494050','A1 0986424482','A2 FE FDB1323','B1 ZIM23018.900.1','A2 21938 204 05','A3 FER FDB1717','C9 0986494050','C9 23018-20,4','D3 RE 39052-AF','A5 41035','C9 GDB1307','A2 FE FSL1323','A2 RH 2390.52','A1 WBP561','A3 VAC V10-8146-1','A3 VAC V10-8144','A2 0986494050','C4 05P790','A1 FQT1717','A2 BP85085','A5 194994','A5 50076','B1 BOS0986424482','A9 GDB1307','A2 ABS37156','C9 FDB1323','B1 CIF822-314-0','A3 TEX 2301802','C9 224742','C9 0252301820/W','C9 VAL598751','C9 VAL598750','A1 P85037','A3 ROA 239052','B1 VAI10-8146-1','A9 FE FDB1323','A1 2301802 TEX','A1 16060 FE','A9 0986424482','B1 BREP85085','A3 TEX 2193801','C4 GDB1307','A1 16448 FE','A3 BOS 0986424482','A1 FDB1717','C9 2193801','A9 23018 204 05','C9 0986424482','A8 230 107','D2 EO FDB1323','A9 ABS37156','C4 2193801TX','A9 BD S088','C9 VAL598779','A3 FER FDB1323','B1 FEB16448','C4 0986494050','B1 FEB16447','C4 2301802TX','C9 FE16060','A8 227 292','A1 0986495232','A1 13.0460-7110.2','A1 13.0470-7110.2','A1 GDB1049','A1 P85085X','A2 0986495232','A2 13.04607110.2','A2 13.04707110.2','A2 BD S301','A2 GDB1049','A2 Q109-1123','A2 RH 2390.02','A3 BOS 0986495232','A3 QUI 109-1123','A3 ROA 239002','A5 172850','A5 194992','A5 48901','A8 203 699','A8 230 050','A8 234 053','A9 13.04607110.2','A9 13.04707110.2','A9 BD S301','A9 GDB1049','A9 GDB1307DTE','A9 Q109-1123','B1 ATE13.0460-7110','B1 ATE13.0470-7110','B1 BLPADV184213','B1 BREP85037X','B1 BREP85085X','B1 KAMJQ1012646','B1 LUCGDB1049','B1 LUCGDB1307DTE','B1 QB109-1123','B1 VAL301483','B1 VAL301751','B1 ZIM21938.200.1','B1 ZIM21938.200.2','B1 ZIM23018.200.1','B7 0390.02/REM','B7 0390.22/REM','B7 21938.200.1','B7 23018.200.1','B7 B110839/DKM','C4 0986495232','C4 21938.200.1','C4 23018.200.1','C4 607110','C4 GDB1049','C4 GDB1307DTE','C4 LD7110','C9 0252301820/PD','C9 13.0460-7110.2','C9 13.0470-7110.2','C9 19-0652','C9 19-3457','C9 21938 00 701 10','C9 23018 00 701 10','C9 GDB1049','C9 GDB1307DTE','C9 PA-0927AF','C9 QB109-1123','C9 QP1193C','C9 QP2915C','C9 QP6970','C9 QP6970C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #