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 ('A3 VAC V10-7505','A1 840 1006 10','B1 BOSKS01000842','D3 LE A81889','B1 BOSKS00000956','C4 VKDY 311023','C9 ELS11-0674','B1 KAM9060005','B1 BOSKS00000943','B7 D200001/DKM','C4 KS00000878','C9 KS00000956','C4 850029145T','A3 DEL DSR1197L','C4 11-0047E','A5 391092','C9 KS01000913','B1 FAG840100610','A9 SD 52135','C9 KS00000943','A1 KS01000841090/GR','A9 KS00000871','A3 FEB 22044','B7 L29145/MON','C9 KS00000870','A1 DSR1197L','C6 020637','A1 KS00000871','B1 MOZL29145','B1 GRIAU9019','B1 KAM9010073','A5 146217','B1 LIZ01.05.3095','B1 BOSKS00000922','B1 BOSKS01000840','A1 SP52352','C9 72-2898','B1 VKA44190095101','C9 KS01000882','A3 NKS 5034756','A2 JTE143','B1 GRIAU9045','C9 ELS11-0664','C9 KS00000942','A8 443 461','A3 VAC V10-0704','A3 MEY 1160208228/HD','C4 TA1908','B1 LIZ01.05.3072','A3 NKS 5034756PRO','A3 TRU 07.37.120','C9 QS3862/HQ','B1 BOSKS00000870','C4 TA1583','B1 GRIAU9025','A1 WSS125','A3 DLP TA1583','A9 44190095101','B1 FAG840053710','A3 VAC V10-7209','B1 TRU07.37.120','A9 ELT 11-0049','B1 DRI711520049','A3 VAC V10-7020','A2 S37872','B1 VAI10-7020','A2 S37477','A2 ELT 11-0047','C4 0052352','C4 54005418','C4 07.37.120','A1 SP52135','B1 DRI711520674','B1 LIZ01.05.3040','A1 WSS134','C9 KS00000922','C9 FE22044','B1 DRI711520819','A1 VO-ES-8227','C4 RW78391','A1 JRA500','A2 KS00000942','C4 0052346','B1 BOSKS00000878','C4 84005418','B1 VAI10-7209','B1 LIZ01.05.3062','C4 56004018','A1 SP52346','C6 019683','C4 52135','B1 HP109 669','C4 116 020 8228/HDMY','B7 D200003/DKM','A9 ELT 11-0047','B1 DRI711520047','A1 RU915734','B1 BOSKS01000926','C9 KS01000926','A1 DSR1182L','C9 1160200047','B1 LIZ01.05.3052','B1 VAI10-7505','A4 A-511A','C4 116 020 0047MY','B7 D130023/DKM','C4 JTE1023','A5 188415','C9 KS00000871','B1 BOSKS00000871','B1 KAM9020064','B1 GRIAU9026','C9 915781','C9 KS01000848','C6 007288','A2 JRA500','C9 5034756PRO','A8 404 817','B1 VKA44981776901','C4 52048','A1 JTE143','A8 461 406','A1 22044 FE','A1 KS00000942','A9 JTE143','A1 37000 SID','A1 KS00000912','C6 011701','A8 064 722','B1 KAM9020069','A2 KS00000871','A4 4B3 498 998','C4 JRA500','B7 915732','B1 BOSKS01000839','A2 SD 52135','A3 MON L29145','B1 LIZ01.05.3090','C9 KS00000907','B1 VAI10-0704','A2 TA1908','A1 SP52048','C4 22044F','A2 TA1583','A2 ELT 11-0664','B1 GRIAU9017','C4 52346','C4 0052048','A1 WSS546','C4 840100610','C4 86004018','B1 BOSKS00000872','A1 37630 SID','C9 MGZ-301001','A5 353941','C9 KS01000839','A2 44981773101','B1 BOSKS01000882','A1 37872 SID','C9 840100610','C4 11-0664E','A1 DSR1185L','C9 ELS11-0819','E3 A-513','B1 FEB22044','C4 0052135','A1 RU915732','B1 LIZ01.05.3076','A3 MOG VO-ES-8227','A8 401 841','B7 1144602100/JP','A1 SP52234','C6 020640','B7 1144403200/JP','A1 G1-544A','B1 ABS230021','B1 GRIAU9027','B1 BOSKS00000942','B1 LIZ01.05.3063','B7 D130239/DKM','B1 TRWJRA500','C9 07.37.120','A2 JTE1023','C4 KS01000848','B1 BOSKS01000841','A9 S37630','C6 100341','B1 VAI10-7001','A1 G1-544','A3 RUV 915781','A8 058 394','C9 KS01000841','B1 BOSKS00000912','B1 DRI711520664','B7 915781','A9 12.22.720','A9 44981773101','B7 D200002/DKM','B1 VKA24980592001','C9 KS00000912','A3 VAC V10-7001','C4 VO-ES-8227','B1 RUV915781','C9 915734','C9 KS00000872','A5 17353','C4 JTE143','B7 915734','C9 ELS11-0049','C9 KS01000840','B1 TRWJTE143','B1 LIZ01.05.3055','C9 72-4746','A3 DLP TA1908','B1 BOSKS01000912','C4 KS01000912','C9 KS01000912','B1 LIZ01.05.3054','A1 RU915781','A3 DEL DSR1185L','D2 WSS999','C6 019531','B1 TRWJTE1023','A2 12.23.720','A2 12.22.720','B1 BOSKS01000848','A1 WSS905','A9 12.23.720','C9 5034756','B1 KAM9120004','B1 BOSKS01000913','C9 KS00000878','A1 TA1583','B1 KAM9010087','B7 54005418/MTZ','C6 020638','C9 ELS11-0047','A1 TA1908','A2 S37630','C4 KS00000942','E3 A-611','A1 JTE1023','A2 44190095101','C6 020402','B1 BOSKS00000907','B1 RTS91.05966','A1 37477 SID','C9 1160208228/HD','A9 JTE1023','A9 ELT 11-0664','B7 840 1006 10','C9 KS01000842','A5 142191','A8 443 691','D3 0182041','D3 LE A82041','D3 LEF 2586301','D3 OG VOES8227','D3 SID 37630','A5 353957','C4 116 020 0008/HDMY','C4 116 020 0046MY','C4 116 030 8227/HDMY','C4 51004808','C9 1160200008/HD','C9 1160200046','C9 1160308227/HD','C9 MGZ-301002','C9 QS3095/HQ','C9 QS9208/HQ','A1 25863LMI','A2 2586301')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #