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