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 ('A5 50076','A2 13.04707110.2','A9 BP85037','B7 0390.22/REM','A5 41035','C4 LD7110','A1 2311502 TEX','A8 207 980','C4 KRO1307','A8 227 292','A9 13.04707110.2','A1 2193801 TEX','B1 FEB16447','C9 VAL301751','B1 ATE13.0460-7110','C9 VAL301483','A9 FE FDB1323','C9 GDB1307DTE','A1 13.0460-7110.2','D3 RE 39052-AF','C9 VAL598751','A3 DLP LP1672','B1 BREP85037','A3 TEX 2193881','C4 0986495232','A5 172850','A8 215 164','C9 21938-20,4','A9 21938 204 05','B7 23018.200.1','A2 FE FDB1323','A3 TEX 2301802','A2 0986495232','A9 21938.200.1','A1 0986424482','A3 BOS 0986424482','C9 VAL598483','B1 ZIM23018.200.1','A9 GDB1307DTE','C4 2193801TX','A9 0986494050','A2 RH 2390.22','C9 23115-19,6','A9 0986424482','A9 23018 204 05','A8 203 483','A1 P85085','C9 0986424482','A3 BOS 0986495232','A9 RH 2390.22','A8 215 149','A8 230 107','C9 FDB1323','C9 2193801','B1 LUCGDB1307','A2 21938 204 05','A2 0986424482','A5 48901','B1 ZIM21938.200.1','A1 GDB1307DTE','A1 WBP426','C9 0986494050','C4 FDB1323','A3 FER FDB1323','C9 2311502','A1 0986495232','B1 BLPADV184213','A2 BP85037','A5 194994','C9 13.0460-7110.2','C9 2301802','A3 TEX 2193801','A1 FDB1323','C4 607110','A1 13.0470-7110.2','B1 BOS0986494050','C4 2301802TX','A8 232 298','A8 254 316','A1 GDB1307','B1 LUCGDB1307DTE','B1 ZIM23018.900.1','C9 224742','A2 05P790','C9 PA-0004AF','B1 VAL301751','C9 ADV184213','A1 598483','A1 WBP561','A2 0986494050','C4 23018.200.1','A3 ROA 239052','C4 GDB1307','A2 LP1672','A1 2301802 TEX','C9 23018-20,4','A2 BP85085','C9 13.0470-7110.2','A1 P85037','A2 GDB1307DTE','C4 16447F','C4 GDB1307DTE','A9 13.04607110.2','B1 BOS0986424482','C9 GDB1307','C9 21938-20,4 EPAD','C4 LP1672','B7 21938.200.2','A3 ROA 239022','B7 21938.200.1','A2 23115 196 05','A2 T 2193881','A9 BP85085','E3 23018.200.1','A1 WBP103','C4 21938.200.1','A2 GDB1307','A9 23115 196 05','A8 234 053','A1 FDB1323-PROMO','A3 BOS 0986494050','A1 LP1672','A8 205 373','C9 FE16447','B1 ATE13.0470-7110','A2 RH 2390.52','C4 0986424482','A9 GDB1307','A2 13.04607110.2','A3 TEX 2311502','A5 113387','C4 0986494050','A2 21938.200.1','A9 RH 2390.52','B1 BREP85085','B1 VAL301483','C4 05P790','D2 EO FDB1323','A1 16447 FE','A2 23018 204 05','A1 0986494050','D1 BP ADV184213','B1 ZIM21938.200.2','A1 GDB1049','A1 LP1407','A2 ABS37156','A2 GDB1049','A2 Q109-1123','A2 RH 2390.02','A2 RH 2390.40','A3 CIF 822-181-3','A3 DLP LP1407','A3 QUI 109-1123','A3 QUI WS0243B','A3 ROA 239002','A5 194992','A8 203 699','A8 230 050','A9 GDB1049','A9 Q109-1123','A9 RH 2390.40','B1 ABS37156','B1 BREP85037X','B1 CIF822-181-3','B1 FEB16455','B1 KAMJQ1012646','B1 LUCGDB1049','B1 QB109-1123','B7 0390.02/REM','B7 0390.40/REM','B7 B110839/DKM','C4 16455F','C4 GDB1049','C4 LP1407','C9 0252301820/PD','C9 0252301820/W','C9 0252376220/W','C9 19-3457','C9 21938 00 701 10','C9 23-0090','C9 23018 00 701 10','C9 GDB1049','C9 QB109-1123','C9 QBWS 0243 A','C9 QP1193C','C9 QP2915C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #