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 ('A1 0986424501','B1 FEB16338','A3 VAC V10-8130','B1 CIF822-181-2','E7 188.1','E7 188.4','A9 0986494018','B1 ZIM21911.200.1','C4 GDB1200','B7 0390.01/REM','B1 VAL302493','B7 1163605110/JP','C9 PA-0941AF','B1 CIF822-181-4','C9 EBCDP41330R','B1 BOS0986424460','A2 GDB1403','A5 74905','B1 VAI10-8130','A5 206820','A1 FDB1463','A3 DLP LP1525','A3 FER FDB969','A1 13.0460-7081.2','B1 VAI10-8132','A1 598303','A2 FE FDB969','A9 0986424460','C4 607081','A1 16338 FE','A3 JAP PA-0044AF','A5 206935','C9 PA-0906AF','A3 VAC V10-8131','C4 FSL1463','A3 ROA 239001','D1 BP ADV184232','C4 1170122','C9 VAL598303','C9 GDB1200','A8 230 147','C9 13.0470-7081.2','A2 07.B314.27','A1 13.0470-7081.2','A2 BP85045','A3 ROA 239041','C4 KRO1403','B1 ATE13.0460-7122','A1 598486','A2 21911.200.1','B1 ATE13.0460-7081','B1 VAI10-8131','A2 RH 2390.20','C9 GDB1275','B7 23392.200.1','C4 607122','A2 RH 2390.41','A2 07.B314.54','A3 VAC V10-8132','A9 GDB1403','A8 234 064','A1 0986424460','B1 ATE13.0470-7122','A1 GDB1275','C9 13.0470-7122.2','A9 13.04707122.2','A1 0986494018','A8 235 318','A9 GDB1275','C9 GDB1403DTE','A1 FSL1463','E1 30 91 6338','A3 CIF 822-181-1','C4 GDB1275','A2 13.04707122.2','B1 BOS0986494018','B7 1163605210/JP','C9 21911 00 701 10','E7 AC692581D','B1 LUCGDB1200','A9 RH 2390.41','A2 05P639','A3 DLP LP1407','C4 FDB969','A9 13.04707081.2','A2 13.04707081.2','A2 13.04607081.2','B1 LUCGDB1275','A1 WBP105','E3 23392.200.1','A2 GDB1200','A2 0986424460','C4 FSL969','C4 23392.200.1','B7 1163604810/JP','A1 P85045','A1 LP1407','C4 LP1525','A8 230 091','A5 146878','C4 0986494018','B1 TOM1212','A9 BP85045','C9 13.0460-7122.2','B1 TOM10942','A9 21911.200.1','C4 LD7122','B1 CIF822-181-1','A2 LP1525','A1 FSL969','C4 LP1407','C4 FDB1463','A2 05P969','A1 0986495249','B7 0390.20/REM','A2 RH 2390.01','E1 30 91 6334','C9 0986494018','B1 LUCGDB1403','B1 BREP85035','C4 05P969','A3 FER FDB1463','B1 ZIM23392.200.1','C4 FQT1463','B1 BREP85045','B1 FEB16334','A1 FQT1463','C9 13.0460-7081.2','D2 EO LP1525','A2 13.04607122.2','D2 EO FDB1463','A8 217 267','A1 LP1525KB','A1 13.0470-7122.2','C9 FDB1463','C9 0986424460','A9 FE FDB1463','B7 B110039/DKM','C9 19-0661','A8 215 811','B7 21911.200.1','A1 LP1525','A2 LP1407','A1 571984J JRD','C9 GDB1403','A1 GDB1200','A8 220 643','B1 VAL301486','C4 GDB1403','C4 LD7081','C4 05P639','B1 BLPADV184232','A3 BOS 0986424460','B1 LUCGDB1403DTE','A2 GDB1275','A1 P85035','A2 0986494018','A2 GDB1403DTE','A1 16334 FE','A9 RH 2390.20','B1 ATE13.0470-7081','B1 ZIM23392.900.1','A8 215 802','B1 ABS37133','C9 VAL598486','A3 ROA 239020','A1 13.0460-7122.2','A2 FE FDB1463','C9 0252191119','A2 BP85035','A1 WBP361','A9 GDB1200','A1 GDB1403','A9 13.04607122.2','A9 13.04607081.2','C9 VAL301486','B7 0390.41/REM','E7 188.2','A1 GDB1403DTE','C9 23392 00 701 10','C9 PA-0044AF','A5 119308','A1 FDB969','A9 GDB1403DTE','A3 BOS 0986494018','A2 Q109-1123','A3 QUI 109-1123','A8 203 699','A9 Q109-1123','B1 KAMJQ1012926','B1 QB109-1123','C9 0252339219/PD','C9 0252339219/W','C9 QB109-1123')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #