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 VAI10-8169-1','C4 GDB1049','A2 LP1706','A1 GDB1440','A1 WBP426','C4 21849.200.1','A1 2184903 TEX','A2 RH 2390.22','A1 P85037','A3 ROA 239011','C9 FDB1055','B1 BOS0986494050','A2 GDB1440','B7 B110047/DKM','B1 VAI10-8146','B1 VAI10-8346-1','B7 0390.22/REM','C4 LP978','A3 TRU 07.35.107','C9 224742','A9 0986494050','A3 FER FDB1055','A2 21938 204 05','A3 TEX 2193881','A9 GDB1440','C9 2184903','A3 VAC V10-8169-1','B7 21938.200.1','B1 TRU07.35.107','A9 FE FDB1323','A9 0986424482','A9 RH 2390.52','C9 GDB1204','A1 13.0460-7110.2','A2 13.04607076.2','B1 LUCGDB1049','A9 0986494003','C9 13.0460-7110.2','A9 21849 206 05','A1 0986495241','B7 21848.200.1','A1 FSL1323','A3 BOS 0986494003','A3 TEX 2301881','C4 GDB1204','E3 21849.200.1','A1 598483','A1 0986494050','C4 05P612','A3 VAC V10-8144','A1 WBP719','B1 ZIM21849.200.1','E3 21848.200.1','C4 05P453','B1 ZIM23018.200.1','B1 KAM1032312','A3 DLP LP1706','A3 VAC V10-8169','A8 257 402','A1 FDB1323-PROMO','A2 13.04607143.2','A8 258 697','C9 QP1193C','A1 GDB1049','A9 21848 197 05','C9 PA-0004AF','A5 127071','A9 13.04607143.2','B1 VAI10-8346','B1 ZIM21938.200.2','A1 2301802 TEX','C9 21849-20,6','C4 LD7110','A9 GDB1307','C9 FDB1323','C9 19-0760MAX','C4 V2003V','C9 GDB1440','C6 007405','A8 230 050','A1 598067','A5 194994','B1 CIF822-181-3','A9 RH 2390.22','A3 VAC V10-8143','C9 ADV184213','A9 RH 2390.00','C9 2193801','C9 13.0470-7110.2','B1 ZIM21848.200.1','A8 230 161','D2 EO FDB1323','A5 50076','A8 205 623','A9 21938.200.1','A1 573022JC JRD','B1 KAMJQ1012646','A8 201 970','C9 PF0142','A2 21848 197 05','A2 21849 206 05','C9 0986424482','B1 ABS37239','A3 VAC V10-8143-1','B7 05P1119/SUZ','A5 142846','C4 23018.200.1','B1 LUCGDB1440','B7 1163604810/JP','A3 DLP LP978','A2 FE FDB1496','C1 RH 2390.00','C4 0986494050','A2 FE FDB1827','D3 RE 39052-AF','B1 TOM1094','C9 0986494003','C9 19-3457','A2 RH 2390.11','A1 FDB1496','A3 TEX 2301802','C9 21938 00 701 10','A9 05P1119','B1 TOM1313','C4 2193801TX','B1 VAL301483','C9 2301802','C9 23018-20,4','A3 VAC V10-8346','B1 ABS35026','A2 05P453','B1 LUCGDB1204','A2 FE FDB1323','A3 BOS 0986494050','A1 LP978','A2 GDB1049','A1 LP1407','A1 0986494003','A3 FER FDB1717','C6 103585','A9 GDB1307DTE','A9 13.04707110.2','B7 23018.200.1','C9 QP6970C','A1 0986495232','A2 BP85085','C4 FDB1496','A2 13.04607110.2','C9 21849 00 701 10','B1 CIF822-314-0','A8 254 316','C9 0252301820/PD','A3 ROA 239000','A3 TEX 2193801','C9 0986494050','C4 GDB1440','C9 19-0760SPORT','A8 227 292','A3 VAC V10-8146-1','A2 0986495232','A1 FDB1827','C4 0986495232','A2 FE FSL1323','A1 FDB1717','A1 WBP183','E3 23018.200.1','C9 VAL598067','C9 0252184919/W','A1 13.0460-7143.2','A2 RH 2390.00','A1 FDB1323','A3 FER FDB1496','C9 0252184819','C9 0252184819/PD','C9 QP6970','A5 172850','A1 LP1825','E7 AC0581238D','A2 05P1119','A2 05P1238','A5 131466','C4 21848.200.1','C9 VAL301483','A2 LP1407','A3 BOS 0986424482','C4 LP1672','C9 VAL301008','A2 0986494390','A8 200 122','C9 19-1820','B7 B110839/DKM','C9 21938-20,4 EPAD','A1 P85039','B7 1163602510/JP','C9 23018 00 701 10','C9 PF0260','A1 598489','A1 0986424482','B7 0390.52/REM','A1 LP1672','B7 V2003V','A9 FE FDB1717','A3 JAP PA-0312AF','C4 607143','C4 FSL1055','A5 113387','C9 VAL301751','A9 BP85085','C9 QP1193','A1 0986424633','C9 23018-20,4 EPAD','A9 GDB1049','A9 13.04607076.2','A8 217 259','A5 41035','A1 WBP104','A1 FDB1055','B1 KAMJQ1011180','B1 ATE13.0470-7110','B1 VKA66981105401','C9 VAL598483','A2 GDB1307','A2 GDB1307DTE','C4 05P1238','A3 DLP LP1407','A2 GDB1204','A8 205 373','A1 0986424706','C4 05P1119','B1 ABS36898','C9 19-1821','A2 LP978','A2 LP784','C9 GDB1307DTE','B1 VAL302030','A1 FSL1496','A3 DLP LP1825','B1 VAI10-8144','A1 GDB1488','A1 LP1706','C9 PF0130','B1 BREP85085X','C4 GDB1307','B1 BOS0986424482','C9 2184802','C6 019532','C9 19-0760','C4 1170020','A8 230 075','C9 FDB1717','E7 288.0','C9 PA-0312AF','E7 288.0.T','B1 ATE13.0460-7110','B7 21849.200.1','B7 B110864/DKM','C4 LP1706','C9 13.0460-7076.2','B1 VKA66980010601','A2 BP85037','A2 21938.200.1','C9 13.0460-7143.2','A1 0986494390','B1 CIF822-279-1','A8 215 786','C9 PF0143','C9 GDB1049','A2 BD S301','B1 BOS0986494003','A9 FE FDB1496','C9 QP2915C','C4 KRO1307','A8 230 107','A2 0986494003','A2 0986494050','B1 ZIM23018.900.1','B1 KAMJQ1012992','A9 BD S301','A9 FE FDB1055','A2 FE FDB1055','A3 VAC V10-8346-1','B7 21938.200.2','B1 VAL301751','A2 0986495241','A8 215 164','C9 0252301820/W','A2 LP1825','A3 DLP LP784','B7 0390.11/REM','A8 217 794','B1 ATE13.0460-7143','A1 GDB1204','A3 VAC V10-8144-1','B1 VAI10-8143','B1 LUCGDB1307DTE','A1 13.0460-7076.2','A2 T 2193881','C4 LP1407','B1 TOM1213','A3 TEX 2184903','E1 30 91 6447','A8 232 298','A1 GDB1307DTE','B1 LUCGDB1307','A8 215 149','A5 118483','A1 2193801 TEX','A3 ROA 239022','A8 217 472','C9 QP7733','A1 P85085X','A3 CIF 822-181-3','B1 BOS0986494390','B1 BREP85039','A2 BD S433','C4 0986424482','D1 BP ADV184213','A2 05P790','B1 VAI10-8146-1','C9 21938-20,4','B1 ABS37156','A1 WBP103','A9 05P612','A1 WBP561','A9 ABS37156','C9 PF0261','A2 23018 204 05','A5 48901','A5 45625','B7 SP 259','C4 21938.200.1','C4 05P790','C4 LP1825','A1 13.0470-7110.2','B1 ATE13.0460-7076','A1 WBP695','A9 BP85039','C9 21848 00 701 00','A9 13.04607110.2','A2 ABS37156','A3 DLP LP1672','C9 0252184919/PD','A3 BOS 0986494390','A1 573037JC JRD','B1 ZIM21938.200.1','A9 BP85037','A1 LP784','C4 FDB1323','A2 RH 2390.52','A1 GDB1307','B1 CIF822-279-0','C4 2301802TX','A1 P85085','A3 FER FDB1323','A9 23018 204 05','A2 BP85039','B7 B110040/DKM','C9 GDB1307','A3 TEX 2184802','A9 GDB1204','C4 FDB1717','C4 LP784','A8 234 053','B1 BREP85037X','B1 VAI10-8144-1','B7 0390.00/REM','A2 05P612','B1 VAL301008','C9 19-0652','A2 13.04707110.2','A8 203 483','C4 2184802TX','A2 T 2301881','B1 BLPADV184213','B1 KAMJQ1012110','B1 VAI10-8169','A2 FE FDB1717','A3 FER FDB1827','A9 21938 204 05','A3 VAC V10-8146','C4 607110','A3 BOS 0986495241','C9 21848-19,7','C4 KRO1488','C9 0986494390','A3 BOS 0986495232','B7 0390.02/REM','A5 194992','C4 GDB1307DTE','C9 VAL598489','A1 WBP444','A1 FSL1055','A2 LP1672','C4 0986495241','A3 ROA 239052','C9 QP7733C','A5 146529','B1 BREP85037','A2 0986424482','B1 BREP85085','C9 PA-0927AF')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #