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