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