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 ('C9 0986494018','A1 13.0470-7081.2','C9 PF0137','A9 23392 206 05','C9 13.0460-7122.2','A2 GDB1403','C9 PF0146','A2 BP85045','E7 188.2','B1 CIF822-181-4','A9 0986424460','B7 1163605110/JP','C9 D02520','B1 BOS0986424460','C6 007243','C4 1170122','C9 PA-0941AF','C9 VAL598486','B7 B110043/DKM','C9 2191102','B7 0390.01/REM','B1 ABS36898','B1 KAMJQ101193','A5 119308','C9 0986424482','A9 13.04607122.2','A9 D0-2520','A3 VAC V10-8132-1','C9 EBCDP41330R','A1 571984J JRD','A8 217 267','A5 206935','B7 0390.41/REM','C9 21911 00 701 10','A9 FE FDB1463','C4 FDB1463','A3 ROA 239041','C4 05P639','A1 FDB1463','C4 23392.200.1','A1 0986495232','A8 215 802','A8 203 482','A2 05P639','C4 D-02520','C9 0252339219/PD','A1 GDB1200','B1 ATE13.0460-7081','A1 FSL1463','C9 QP5013C','A5 41035','C9 VAL301486','A9 21911 206 05','A1 598303','A2 FE FDB1463','C9 GDB1275','B1 VAL302493','A1 0986424460','B1 KAMJBC0005','B1 BOS0986494018','A1 GDB1403DTE','A1 LP1525','A5 146878','A2 21911.200.1','A8 232 526','A1 0986494018','A1 WBP361','E7 188.4','B1 CIF822-181-2','A3 DLP LP978','A1 GDB1275','C9 GDB1200','A1 13.0470-7122.2','C9 GDB1403DTE','D2 EO LP1525','A1 LP1407','C4 GDB1200','A2 LP1525','A1 WBP695','C4 FSL1463','B7 1163605210/JP','B1 VKA66980008801','D2 EO FDB1463','B1 BOS0986424482','A3 TRU 07.35.104','A5 206820','A8 205 371','B1 VAI10-8132','C9 13.0470-7122.2','C9 FDB1463','A5 74905','A8 235 318','A2 0986424460','A2 0986494018','A3 VAC V10-8132','C9 13.0460-7081.2','C9 0252191119','A8 220 643','A8 234 064','B1 AFND02520','A2 LP1407','A1 0986424501','A3 BOS 0986495232','A2 GDB1275','A9 21911.200.1','A9 13.04607081.2','A9 13.04707122.2','A2 05P669','E7 AC692581D','A2 23392 206 05','C9 23392-20,6','B1 ATE13.0470-7122','A2 13.04607081.2','E1 30 91 6334','C4 05P969','C9 21911-20,6','B1 ZIM23392.200.1','A2 13.04607122.2','C9 23392 00 701 10','A1 13.0460-7081.2','A9 GDB1200','A2 05P969','C4 LP1525','A3 BOS 0986424460','B1 TRU07.35.104','C4 LD7122','C4 LP1407','B7 21911.200.1','C9 QP5013','A8 215 811','A3 BOS 0986494018','A9 0986494018','B1 ATE13.0460-7122','A1 0986424482','A1 2339201 TEX','C4 FDB969','B1 KAMJBC0006','C4 607081','B1 ZIM23392.900.1','C4 FSL969','B1 ZIM21911.200.1','A3 ROA 239001','A1 LP1525KB','A9 RH 2390.20','A3 TEX 2339201','B1 LUCGDB1200','B1 KAMJQ1012926','B1 LUCGDB1403DTE','A1 LP978','C4 2339201TX','A2 0986424482','A2 21911 206 05','A3 VAC V10-8131','C9 PA-0906AF','C4 KRO1403','A3 TEX 2191102','A9 13.04707081.2','B7 B110039/DKM','E3 23392.200.1','B1 BLPADV184232','A2 13.04707122.2','C4 0986494018','A2 GDB1403DTE','C9 0252339219/W','C4 GDB1403','C9 QP8417C','D1 BP ADV184232','A3 ROA 239020','C4 0986424482','B1 LUCGDB1403','A1 598486','B1 TOM10942','B1 LUCGDB1275','B1 VAI10-8131-1','B1 VAI10-8130','A2 LP978','B7 23392.200.1','A3 DLP LP1407','A3 BOS 0986424482','A3 DLP LP1525','A8 215 149','C9 VAL598303','B1 ABS37133','C9 0986424460','A2 RH 2390.20','C9 QP8417','A3 VAC V10-8131-1','C9 19-0650','B1 ATE13.0470-7081','A9 0986424482','A5 151925','C9 19-0661','A2 13.04707081.2','A1 0986495249','B1 VAI10-8131','A9 BP85045','B7 1163604810/JP','A2 D0-2520','B7 SP 259','C9 13.0470-7081.2','B1 TOM1212','A2 FE FDB969','A1 P85045','C4 05P669','C4 0986495232','A1 WBP105','C4 LD7081','C9 0252191119/PD','A2 GDB1200','A9 GDB1403','A1 FDB969','A2 RH 2390.01','A3 FER FDB1463','C9 2339201','A1 13.0460-7122.2','B7 0390.20/REM','A8 230 091','A1 FSL969','A9 RH 2390.41','B1 BREP85045','B1 VAI10-8132-1','A3 FER FDB969','A9 GDB1403DTE','A2 RH 2390.41','C9 GDB1403','A2 0986495232','C9 PF0136','A8 230 147','C4 LP978','C4 607122','C4 GDB1275','A1 GDB1403','B1 VAL301486','A9 GDB1275','A3 VAC V10-8130')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #