SELECT t1.ID, t1.ADDRESS, t1.BASE_END, t1.BASE_NUMBER, t1.BASE_SER, t1.BASE_START, t1.BASE_WHOM, t1.BASIS, t1.BIRTHDATE, t1.BIRTHPLACE, t1.CITIZENSHIP_RF, t1.DMS_EXPIRE, t1.DMS_ISSUED, t1.DMS_NUM, t1.EMPLOYEE_FIO, t1.INN, t1.IS_LOCK, t1.LASTNAME, t1.MIDDLENAME, t1.MIGRATION_CARD_DATE_START, t1.MIGRATION_CARD_EXPIRE, t1.MIGRATION_CARD_NUM, t1.MIGRATION_CARD_SER, t1.NAME, t1.NO_PATRONIMIC, t1.PASS_DATE_TO, t1.PASS_ADDRESS, t1.PASS_CODE, t1.PASS_D, t1.PASS_ISSUED, t1.PASS_N, t1.PASS_S, t1.PHONE, t1.PHONE2, t1.REGISTRATION_DATE_FROM, t1.REGISTRATION_EXPIRE, t1.RESIDENT, t1.SALARY_EXPORT1C, t1.SEX, t1.SNILS, t1.WORK_START_DATE, t1.BONUS_CARD_ID, t1.CITIZENSHIP_ID, t1.EMP_STATUS_ID, t1.EMPLOYEE_TYPE_ID, t1.PAYROLL_SCHEDULE_ID, t1.SALARY_CARD_ID, t1.EMPLOYEE_FACT_ADDRESS_ID, t1.EMPLOYEE_REGISTRY_ADDRESS_ID, t0.ID, t0.LASTNAME, t0.MIDDLENAME, t0.NAME, t0.NUMBER_, t0.PRIORITY, t0.BANK_ID, t0.SALARY_PROJECT_COMPANY_ID, t0.THIRD_PERSON_STATEMENT_ID, t2.ID, t2.NAME, t3.ID, t3.INN, t3.KPP, t3.NAME, t4.ID, t4.CREATE_DATE, t4.DELETE_TS, t4.DELETED_BY, t4.EXT, t4.NAME, t4.VERSION, t5.ID, t5.CODE, t5.NAME, t6.ID, t6.NAME, t7.ID, t7.BUILDING, t7.FLAT, t7.HOUSE, t7.INDEX_, t7.STREET, t7.BUILDING_TYPE_ID, t7.FLAT_TYPE_ID, t7.HOUSE_TYPE_ID, t7.SETTLEMENT_ID, t8.ID, t8.NAME, t8.SHORT_NAME, t9.ID, t9.NAME, t9.SHORT_NAME, t10.ID, t10.NAME, t10.SHORT_NAME, t11.ID, t11.AREA, t11.AREA_PREFIX, t11.CITY, t11.CITY2, t11.CITY2_PREFIX, t11.CITY_PREFIX, t11.REGION_ID, t12.ID, t12.CODE, t12.PRETTY_NAME, t13.ID, t13.BUILDING, t13.FLAT, t13.HOUSE, t13.INDEX_, t13.STREET, t13.BUILDING_TYPE_ID, t13.FLAT_TYPE_ID, t13.HOUSE_TYPE_ID, t13.SETTLEMENT_ID, t14.ID, t14.NAME, t14.SHORT_NAME, t15.ID, t15.NAME, t15.SHORT_NAME, t16.ID, t16.NAME, t16.SHORT_NAME, t17.ID, t17.AREA, t17.AREA_PREFIX, t17.CITY, t17.CITY2, t17.CITY2_PREFIX, t17.CITY_PREFIX, t17.REGION_ID, t18.ID, t18.CODE, t18.PRETTY_NAME, t19.ID, t19.CODE, t19.NAME, t20.ID, t20.NAME, t21.ID, t21.LASTNAME, t21.MIDDLENAME, t21.NAME, t21.NUMBER_, t21.PRIORITY, t21.BANK_ID, t21.SALARY_PROJECT_COMPANY_ID, t21.THIRD_PERSON_STATEMENT_ID, t22.ID, t22.NAME, t23.ID, t23.INN, t23.KPP, t23.NAME, t24.ID, t24.CREATE_DATE, t24.DELETE_TS, t24.DELETED_BY, t24.EXT, t24.NAME, t24.VERSION
    FROM WLD_EMPLOYEE t1
        LEFT OUTER JOIN WLD_CARD t0 ON (t0.ID = t1.BONUS_CARD_ID)
            LEFT OUTER JOIN WLD_BANK t2 ON (t2.ID = t0.BANK_ID)
                LEFT OUTER JOIN WLD_COMPANY t3 ON (t3.ID = t0.SALARY_PROJECT_COMPANY_ID)
                    LEFT OUTER JOIN SYS_FILE t4 ON (t4.ID = t0.THIRD_PERSON_STATEMENT_ID)
                        LEFT OUTER JOIN WLD_EMPLOYEE_CITIZENSHIP t5 ON (t5.ID = t1.CITIZENSHIP_ID)
                            LEFT OUTER JOIN WLD_EMPLOYEE_ADDRESS t7 ON (t7.ID = t1.EMPLOYEE_FACT_ADDRESS_ID)
                                LEFT OUTER JOIN WLD_ADDRESS_BUILDING_TYPE t8 ON (t8.ID = t7.BUILDING_TYPE_ID)
                                    LEFT OUTER JOIN WLD_ADDRESS_FLAT_TYPE t9 ON (t9.ID = t7.FLAT_TYPE_ID)
                                        LEFT OUTER JOIN WLD_ADDRESS_HOUSE_TYPE t10 ON (t10.ID = t7.HOUSE_TYPE_ID)
                                            LEFT OUTER JOIN WLD_SETTLEMENT t11 ON (t11.ID = t7.SETTLEMENT_ID)
                                                LEFT OUTER JOIN WLD_REGION t12 ON (t12.ID = t11.REGION_ID)
                                                    LEFT OUTER JOIN WLD_EMPLOYEE_ADDRESS t13 ON (t13.ID = t1.EMPLOYEE_REGISTRY_ADDRESS_ID)
                                                        LEFT OUTER JOIN WLD_ADDRESS_BUILDING_TYPE t14 ON (t14.ID = t13.BUILDING_TYPE_ID)
                                                            LEFT OUTER JOIN WLD_ADDRESS_FLAT_TYPE t15 ON (t15.ID = t13.FLAT_TYPE_ID)
                                                                LEFT OUTER JOIN WLD_ADDRESS_HOUSE_TYPE t16 ON (t16.ID = t13.HOUSE_TYPE_ID)
                                                                    LEFT OUTER JOIN WLD_SETTLEMENT t17 ON (t17.ID = t13.SETTLEMENT_ID)
                                                                        LEFT OUTER JOIN WLD_REGION t18 ON (t18.ID = t17.REGION_ID)
                                                                            LEFT OUTER JOIN WLD_EMPLOYEE_TYPE t19 ON (t19.ID = t1.EMPLOYEE_TYPE_ID)
                                                                                LEFT OUTER JOIN WLD_PAYROLL_SCHEDULE t20 ON (t20.ID = t1.PAYROLL_SCHEDULE_ID)
                                                                                    LEFT OUTER JOIN WLD_CARD t21 ON (t21.ID = t1.SALARY_CARD_ID)
                                                                                        LEFT OUTER JOIN WLD_BANK t22 ON (t22.ID = t21.BANK_ID)
                                                                                            LEFT OUTER JOIN WLD_COMPANY t23 ON (t23.ID = t21.SALARY_PROJECT_COMPANY_ID)
                                                                                                LEFT OUTER JOIN SYS_FILE t24 ON (t24.ID = t21.THIRD_PERSON_STATEMENT_ID),
 WLD_EMPLOYEE_STATUS t6 WHERE
 (((t1.EMP_STATUS_ID = 4) OR t1.ID IN (SELECT t25.ID FROM WLD_EMPLOYEE t25, WLD_FACILITY t28, WLD_EMPLOYEE_USER t27, WLD_FACILITY_EMPLOYEE t26 WHERE ((t27.USER_ID = 'CEB35A9B-1628-E3C9-9F50-92267D837D0E') AND (((t28.ID = t26.FACILITY_ID) AND (t27.ID = t28.MANAGER_ID)) AND (t25.ID = t26.EMPLOYEE_ID))))) AND (t6.ID = t1.EMP_STATUS_ID))