SELECT Id, Name FROM object p WHERE p.Status='A' AND ((COALESCE(p.Branch, '')='') OR (p.`Branch`='Operative' and not exists (select 1 from `object` p2 where p2.`NameJava`=p.`NameJava` and COALESCE(p2.Branch, '')='' and p2.`Status`='A'))) AND p.GroupId IS NULL AND p.ApplicationId in ('B') ORDER BY p.Name

Data Dictionary for UniBill

Objects: