SELECT
  user0_.id                      AS id1_14_,
  user0_.version                 AS version2_14_,
  user0_.account_locked          AS account_3_14_,
  user0_.approved                AS approved4_14_,
  user0_.arhived                 AS arhived5_14_,
  user0_.city                    AS city6_14_,
  user0_.date_end                AS date_end7_14_,
  user0_.date_reg                AS date_reg8_14_,
  user0_.datestartpractice       AS datestar9_14_,
  user0_.dicision                AS dicisio10_14_,
  user0_.email                   AS email11_14_,
  user0_.email_valid             AS email_v12_14_,
  user0_.email_validation_code   AS email_v13_14_,
  user0_.enabled                 AS enabled14_14_,
  user0_.finish                  AS finish15_14_,
  user0_.functional_direction_id AS functio16_14_,
  user0_.mentor_id               AS mentor_17_14_,
  user0_.n_hours                 AS n_hours18_14_,
  user0_.name                    AS name19_14_,
  user0_."password"              AS passwor20_14_,
  user0_.password_expired        AS passwor21_14_,
  user0_.patronymic              AS patrony22_14_,
  user0_.practise_status         AS practis23_14_,
  user0_.resume_id               AS resume_24_14_,
  user0_.sec_name                AS sec_nam25_14_,
  user0_.skype                   AS skype26_14_,
  user0_.telephone               AS telepho27_14_,
  user0_.test_group_id           AS test_gr28_14_
FROM users user0_
WHERE (user0_.id IN (SELECT user1_.id
                     FROM users user1_ INNER JOIN user_to_role roles2_ ON user1_.id = roles2_.user_id
                       CROSS JOIN ROLE role3_
                     WHERE roles2_.role_id = role3_.id AND roles2_.user_id = user1_.id AND role3_.authority <> ?
                     ORDER BY user1_.name, user1_.sec_name, user1_.patronymic)) AND (SELECT COUNT(tests4_.user_id)
                                                                                     FROM user_test tests4_
                                                                                     WHERE user0_.id = tests4_.user_id)
                                                                                    <> 0;

SELECT
  tests0_.user_id    AS user_id6_14_0_,
  tests0_.id         AS id1_12_0_,
  tests0_.tests_idx  AS tests_id8_0_,
  tests0_.id         AS id1_12_1_,
  tests0_.version    AS version2_12_1_,
  tests0_.date_start AS date_sta3_12_1_,
  tests0_.ended      AS ended4_12_1_,
  tests0_.RESULT     AS result5_12_1_,
  tests0_.user_id    AS user_id6_12_1_,
  tests0_.valuer_id  AS valuer_i7_12_1_
FROM user_test tests0_
WHERE tests0_.user_id = ?
ORDER BY tests0_.date_start ASC;

SELECT
  tests0_.user_id    AS user_id6_14_0_,
  tests0_.id         AS id1_12_0_,
  tests0_.tests_idx  AS tests_id8_0_,
  tests0_.id         AS id1_12_1_,
  tests0_.version    AS version2_12_1_,
  tests0_.date_start AS date_sta3_12_1_,
  tests0_.ended      AS ended4_12_1_,
  tests0_.RESULT     AS result5_12_1_,
  tests0_.user_id    AS user_id6_12_1_,
  tests0_.valuer_id  AS valuer_i7_12_1_
FROM user_test tests0_
WHERE tests0_.user_id = ?
ORDER BY tests0_.date_start ASC;