#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 INT 51646','A3 INT 51613','A3 ERA 330710','E2 111 394 466','A8 537 826','C9 FAE24771','B1 VEM10-73-0205','A2 EPS 1.810.152','A3 BGD BSP20764','A8 561 217','C4 0911045','A1 330710 ER','C4 7.1152','A8 504 297','C9 1-810-152','A3 INT 51552','A9 EPS 1.810.152','A1 7.1152','B1 FAE24771','B1 VEM10-73-0149','B1 EPS1.810.152','A2 7.1152','A2 ERA 330710')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#