ΠΕΛΑΤΕΣ ΜΕ ΕΚΡΕΜΜΟΤΗΤΕΣ MYDATA

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