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 ('B1 LUCGDB1307','A1 FDB1323','A3 FER FDB1717','C9 VAL598483','B1 VAI10-8146','C4 2193801TX','B1 BREP85037','C9 23018-20,4','A9 FE FDB1323','C9 2301802','B1 BOS0986424482','B7 SP 259','A8 230 107','C9 0252301820/W','A3 BOS 0986494050','C9 FDB1323','A2 23018 204 05','C4 05P790','C9 FDB1717','C4 0986424482','C4 16447F','B1 VAI10-8144','A2 GDB1307','C4 FDB1323','A3 ROA 239022','B1 VAI10-8181','C9 GDB1307','A3 TEX 2301802','A9 BD S088','A1 FQT1717','A9 FE FDB1717','B1 BOS0986494050','B1 ABS37156','A1 0986494050','A2 FE FSL1323','A9 RH 2390.52','A1 598483','C9 VAL598779','A1 P85085','C4 KRO1307','A3 ROA 239052','C9 224742','C9 0986494050','C9 FE16447','A3 TEX 2301881','A9 BP85085','B1 FEB16447','C9 FE16060','A1 FSL1323','A9 23018 204 05','A2 0986494050','A1 16448 FE','A2 BD S088','A3 TEX 2193801','C9 VAL598751','A9 ABS37156','A1 2301802 TEX','B1 FEB16060','C9 23018-20,4 EPAD','C4 FSL1717','A9 RH 2390.22','C4 FDS1323','A1 WBP426','B1 CIF822-314-0','C9 2193801','A3 BOS 0986424482','A1 16447 FE','A1 GDB1307','B1 VAI10-8146-1','A1 FDB1323-PROMO','C9 VAL598750','A3 VAC V10-8144','A9 GDB1307','A2 ABS37156','B1 FEB16448','A1 FQT1323','B1 CIF822-181-3','A2 05P790','A5 113387','A3 VAC V10-8181','A8 215 149','A1 0986424482','A3 FER FDB1323','A2 RH 2390.52','A1 2193801 TEX','A2 BP85085','A5 50076','D3 RE 39052-AF','A5 194994','A2 BP85037','A8 215 164','A2 21938 204 05','C4 FDB1717','C9 FE16448','A9 BP85037','A8 203 483','D2 EO FDB1323','A3 CIF 822-181-3','C9 0986424482','B1 BREP85085','A8 205 373','C4 2301802TX','A8 227 292','A1 WBP561','A9 0986494050','A1 FDB1717','A2 0986424482','A5 41035','A2 T 2301881','A1 FSL1717','C4 0986494050','A2 RH 2390.22','A1 P85037','A3 VAC V10-8146','A3 VAC V10-8146-1','A1 16060 FE','A9 21938 204 05','C4 GDB1307','A2 FE FDB1717','B1 ZIM23018.900.1','A9 0986424482','C9 21938-20,4','A1 0986424706','A2 FE FDB1323','A3 DLP LP1672','A4 025 230 1820/W','B7 0390.22/REM','D3 05P453','D3 05P790','D3 2RES390.22/G','D3 RE 39022-AF','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 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','A2 LP1672','C4 05P1119','C4 LP1672','E1 30 91 6447')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #