select
        distinct user0_.id as id1_14_0_,
        role4_.id as id1_18_1_,
        user6_.id as id1_14_2_,
        organizati8_.id as id1_3_3_,
        contact9_.id as id1_0_4_,
        contact10_.id as id1_0_5_,
        user12_.id as id1_14_6_,
        contact14_.id as id1_0_7_,
        user0_.active as active2_14_0_,
        user0_.avatar as avatar3_14_0_,
        user0_.birth_day as birth_da4_14_0_,
        user0_.create_date as create_d5_14_0_,
        user0_.creation_as_author_date as creation6_14_0_,
        user0_.esia_contact_id as esia_co19_14_0_,
        user0_.inn as inn7_14_0_,
        user0_.internal_contact_id as interna20_14_0_,
        user0_.last_update as last_upd8_14_0_,
        user0_.middlename as middlena9_14_0_,
        user0_.name as name10_14_0_,
        user0_.nick_name as nick_na11_14_0_,
        user0_.password as passwor12_14_0_,
        user0_.pen_name as pen_nam13_14_0_,
        user0_.probation as probati14_14_0_,
        user0_.snils as snils15_14_0_,
        user0_.status_id as status_16_14_0_,
        user0_.surname as surname17_14_0_,
        user0_.username as usernam18_14_0_,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        role4_.id_school as id_schoo2_18_1_,
        role4_.role_name as role_nam3_18_1_,
        roles3_.user_id as user_id1_17_0__,
        roles3_.role_id as role_id2_17_0__,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        user6_.active as active2_14_2_,
        user6_.avatar as avatar3_14_2_,
        user6_.birth_day as birth_da4_14_2_,
        user6_.create_date as create_d5_14_2_,
        user6_.creation_as_author_date as creation6_14_2_,
        user6_.esia_contact_id as esia_co19_14_2_,
        user6_.inn as inn7_14_2_,
        user6_.internal_contact_id as interna20_14_2_,
        user6_.last_update as last_upd8_14_2_,
        user6_.middlename as middlena9_14_2_,
        user6_.name as name10_14_2_,
        user6_.nick_name as nick_na11_14_2_,
        user6_.password as passwor12_14_2_,
        user6_.pen_name as pen_nam13_14_2_,
        user6_.probation as probati14_14_2_,
        user6_.snils as snils15_14_2_,
        user6_.status_id as status_16_14_2_,
        user6_.surname as surname17_14_2_,
        user6_.username as usernam18_14_2_,
        children5_.child_id as child_id2_16_1__,
        children5_.parent_id as parent_i1_16_1__,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        organizati8_.address as address2_3_3_,
        organizati8_.contact_id as contact12_3_3_,
        organizati8_.full_name as full_nam3_3_3_,
        organizati8_.head_person as head_per4_3_3_,
        organizati8_.inn as inn5_3_3_,
        organizati8_.kpp as kpp6_3_3_,
        organizati8_.legal_form as legal_fo7_3_3_,
        organizati8_.ogrn as ogrn8_3_3_,
        organizati8_.short_name as short_na9_3_3_,
        organizati8_.site as site10_3_3_,
        organizati8_.org_type as org_typ11_3_3_,
        organizati7_.user_id as user_id1_15_2__,
        organizati7_.organizations_id as organiza2_15_2__,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        contact9_.email as email2_0_4_,
        contact9_.phone as phone3_0_4_,
        contact10_.email as email2_0_5_,
        contact10_.phone as phone3_0_5_,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        user12_.active as active2_14_6_,
        user12_.avatar as avatar3_14_6_,
        user12_.birth_day as birth_da4_14_6_,
        user12_.create_date as create_d5_14_6_,
        user12_.creation_as_author_date as creation6_14_6_,
        user12_.esia_contact_id as esia_co19_14_6_,
        user12_.inn as inn7_14_6_,
        user12_.internal_contact_id as interna20_14_6_,
        user12_.last_update as last_upd8_14_6_,
        user12_.middlename as middlena9_14_6_,
        user12_.name as name10_14_6_,
        user12_.nick_name as nick_na11_14_6_,
        user12_.password as passwor12_14_6_,
        user12_.pen_name as pen_nam13_14_6_,
        user12_.probation as probati14_14_6_,
        user12_.snils as snils15_14_6_,
        user12_.status_id as status_16_14_6_,
        user12_.surname as surname17_14_6_,
        user12_.username as usernam18_14_6_,
        parents11_.parent_id as parent_i1_16_3__,
        parents11_.child_id as child_id2_16_3__,
        pseudonyms13_.user_id as user_id1_13_4__,
        pseudonyms13_.pseudonyms as pseudony2_13_4__,
        contact14_.email as email2_0_7_,
        contact14_.phone as phone3_0_7_
    from
        users user0_
    left outer join
        users_role_mapping roles3_
            on user0_.id=roles3_.user_id
    left outer join
        users_roles role4_
            on roles3_.role_id=role4_.id
    left outer join
        users_rel children5_
            on user0_.id=children5_.child_id
    left outer join
        users user6_
            on children5_.parent_id=user6_.id
    left outer join
        users_organizations organizati7_
            on user0_.id=organizati7_.user_id
    left outer join
        organization organizati8_
            on organizati7_.organizations_id=organizati8_.id
    left outer join
        contact contact9_
            on organizati8_.contact_id=contact9_.id
    left outer join
        contact contact10_
            on user0_.internal_contact_id=contact10_.id
    left outer join
        users_rel parents11_
            on user0_.id=parents11_.parent_id
    left outer join
        users user12_
            on parents11_.child_id=user12_.id
    left outer join
        user_pseudonyms pseudonyms13_
            on user0_.id=pseudonyms13_.user_id
    left outer join
        contact contact14_
            on user0_.esia_contact_id=contact14_.id
    where
        user0_.id in (
            select
                user1_.id
            from
                users user1_
            inner join
                contact contact2_
                    on user1_.internal_contact_id=contact2_.id
            where
                (
                    user1_.id in (
                        user0_.id
                    )
                )
                and (
                    lower(contact2_.email) like ?
                )
        )