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