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