SELECT DISTINCT EliteUser.COM.NAME FROM EliteUser.IEE INNER JOIN EliteUser.COM ON EliteUser.IEE.COMID = EliteUser.COM.ID LEFT JOIN EliteUser.EBI ON EliteUser.IEE.ID = EliteUser.EBI.IEEID INNER JOIN EliteUser.IET ON EliteUser.IEE.IETID = EliteUser.IET.ID where ENTRYDATE > '2021-12-31' and ENTRYDATE < '2023-01-01' AND EliteUser.IET.KIND = 1 AND MARK IS NULL and [EliteUser].[COM].[ISACTIVE] = 1 AND IEE.ID NOT IN (SELECT [UDA].[DOMAINID] FROM [EliteUser].[UDA]) -- ΟΡΙΖΟΜΕΝΟΙ ΠΙΝΑΚΕΣ ORDER BY EliteUser.COM.NAME