select first 1000  S.ID, S.SURNAME, S.NAME, S.SECNAME, S.CODE_NAME, S.SEX,
       (select RESULT
        from translate('SEX' || S.SEX)) as SEX_NAME, S.BIRTH_DATE, S.FIRST_VISIT, S.VISITS_CNT, S.COUNTRY, S.DOC_TYPE,
       S.DOC_NUM, S.DOC_DATE, S.DOC_ISSUED, S.PHOTO, S.INDX, S.REGION, S.CITY, S.ADDRESS, S.COMPANY, S.PHONE,
       S.CELLPHONE, S.EMAIL, S.WWW, S.CARD_NUM, S.ADV_SOURCE_ID, A.NAME as ADV_SOURCE, S.DESCR, S.IS_SEND_SMS,
       S.IS_SEND_EMAIL, S.IS_SEND_WEB, S.LOGIN as LOGIN_ID, S.PASS as PASS_ID, S.ORG_ID, O.CODE_NAME as ORG,
       S.TYPE_PRICE_ID, P.NAME as TYPE_PRICE, S.TYPE_BONUSES_ID, B.NAME as TYPE_BONUS, S.SUBDIVISION_ID,
       DS.NAME as SUBDIVISION, S.DISCONT_PRC, S.BONUS_PRC, S.TYPE_CLIENT_ID, DD.VAL as CL_TYPE,
       case
         when S.ACC_SUM_ID > 0 then S.ACC_SUM_ID
         else 0
       end as ACC_SUM,
       case
         when S.ACC_SUM_ADD > 0 then S.ACC_SUM_ADD
         else 0
       end as ACC_SUM_ADD,
       S.DEPARTMENT_ID, DEP.VAL as DEPART, S.ADDRESS_ID, S.BIRTH_YEAR, S.JOB_TITLE_ID, JT.NAME as JOB_TITLE,
       S.MANAGER_ID, M.CODE_NAME as MANAGER, S.MANAGER_PRC
from DIC_CLIENTS S
left join DIC_ADV_SOURCES A on A.ID = S.ADV_SOURCE_ID
left join DIC_ORG O on O.ID = S.ORG_ID
left join DIC_TYPE_PRICES P on P.ID = S.TYPE_PRICE_ID
left join DIC_TYPE_BONUSES B on B.ID = S.TYPE_BONUSES_ID
left join DIC_SUBDIVISIONS DS on DS.ID = S.SUBDIVISION_ID
left join DIC_DICS DD on DD.ID = S.TYPE_CLIENT_ID
left join DIC_DICS DEP on DEP.ID = S.DEPARTMENT_ID
left join DIC_EMPLOYEE M on M.ID = S.MANAGER_ID
left join DIC_JOB_TITLES JT on JT.ID = S.JOB_TITLE_ID
where (upper(S.CODE_NAME) like upper(cast(NULL as FULL_NAME)) or (cast(NULL as FULL_NAME) is null)) and
      ((S.SEX = cast(NULL as ID)) or (cast(NULL as ID) is null)) and
      ((S.PHONE like '%' || cast(NULL as NAME) || '%') or (S.CELLPHONE like '%' || cast(NULL as NAME) || '%') or (cast(NULL as NAME) is null)) and
      (((S.ORG_ID > 0) and
      (cast(NULL as ID) = 1)) or ((S.ORG_ID is null) and
      (cast(NULL as ID) = 0)) or (cast(NULL as ID) is null)) and
      ((upper(S.SURNAME) like '%' || upper(cast('фамилия' as NAME)) || '%') or (cast('фамилия' as NAME) is null)) and
      ((upper(S.NAME) like '%' || upper(cast(NULL as NAME)) || '%') or (cast(NULL as NAME) is null)) and
      ((upper(S.SECNAME) like '%' || upper(cast(NULL as NAME)) || '%') or (cast(NULL as NAME) is null)) and
      ((S.CARD_NUM = cast(NULL as NAME)) or (cast(NULL as NAME) is null)) and
      ((upper(S.CITY) like '%' || upper(cast(NULL as NAME)) || '%') or (cast(NULL as NAME) is null)) and
      ((upper(S.ADDRESS) like '%' || upper(cast(NULL as NAME)) || '%') or (cast(NULL as NAME) is null)) and
      ((S.ORG_ID = cast(NULL as ID)) or (cast(NULL as ID) is null)) and
      ((S.MANAGER_ID = cast(NULL as ID)) or (cast(NULL as ID) is null)) and
      ((S.TYPE_CLIENT_ID = cast(NULL as ID)) or (cast(NULL as ID) is null)) and
      ((exists(select first 1 1
               from JOR_CHECKS CH
               where (CH.CLIENT_ID = S.ID) and
                     ((CH.DATE_TIME >= cast(NULL as date)) or (cast(NULL as date) is null)) and
                     ((CH.DATE_TIME <= cast(NULL as date) + 1) or (cast(NULL as date) is null)))) or (cast(NULL as date) is null and
      cast(NULL as date) is null))   
order by BIRTH_DATE