select
  identityim0_.id as id1_23_0_,
  userimpl1_.user_id as user_id1_168_1_,
  identityim0_.version as version2_23_0_,
  identityim0_.creationdate as creationdate3_23_0_,
  identityim0_.lastlogin as lastlogin4_23_0_,
  identityim0_.external_id as external_id5_23_0_,
  identityim0_.name as name6_23_0_,
  identityim0_.status as status7_23_0_,
  identityim0_.deleteddate as deleteddate8_23_0_,
  identityim0_.deletedroles as deletedroles9_23_0_,
  identityim0_.deletedby as deletedby10_23_0_,
  userimpl1_.u_birthday as u_birthday2_168_1_,
  userimpl1_.u_city as u_city3_168_1_,
  userimpl1_.u_country as u_country4_168_1_,
  userimpl1_.u_countrycode as u_countrycode5_168_1_,
  userimpl1_.creationdate as creationdate6_168_1_,
  userimpl1_.u_degree as u_degree7_168_1_,
  userimpl1_.u_department as u_department8_168_1_,
  userimpl1_.u_edupersonaffiliation as u_edupersonaffilia9_168_1_,
  userimpl1_.u_email as u_email10_168_1_,
  userimpl1_.u_emaildisabled as u_emaildisabled11_168_1_,
  userimpl1_.u_emchangekey as u_emchangekey12_168_1_,
  userimpl1_.u_employeenumber as u_employeenumber13_168_1_,
  userimpl1_.u_extendedaddress as u_extendedaddress14_168_1_,
  userimpl1_.u_extendedofficeaddress as u_extendedofficea15_168_1_,
  userimpl1_.u_firstname as u_firstname16_168_1_,
  userimpl1_.u_gender as u_gender17_168_1_,
  userimpl1_.u_genericcheckboxproperty as u_genericcheckbox18_168_1_,
  userimpl1_.u_genericcheckboxproperty2 as u_genericcheckbox19_168_1_,
  userimpl1_.u_genericcheckboxproperty3 as u_genericcheckbox20_168_1_,
  userimpl1_.u_genericemailproperty1 as u_genericemailpro21_168_1_,
  userimpl1_.u_genericselectionproperty as u_genericselectio22_168_1_,
  userimpl1_.u_genericselectionproperty2 as u_genericselectio23_168_1_,
  userimpl1_.u_genericselectionproperty3 as u_genericselectio24_168_1_,
  userimpl1_.u_generictextproperty as u_generictextprop25_168_1_,
  userimpl1_.u_generictextproperty2 as u_generictextprop26_168_1_,
  userimpl1_.u_generictextproperty3 as u_generictextprop27_168_1_,
  userimpl1_.u_generictextproperty4 as u_generictextprop28_168_1_,
  userimpl1_.u_generictextproperty5 as u_generictextprop29_168_1_,
  userimpl1_.u_genericuniquetextproperty as u_genericuniquete30_168_1_,
  userimpl1_.u_genericuniquetextproperty2 as u_genericuniquete31_168_1_,
  userimpl1_.u_genericuniquetextproperty3 as u_genericuniquete32_168_1_,
  userimpl1_.u_graduation as u_graduation33_168_1_,
  userimpl1_.u_homepage as u_homepage34_168_1_,
  userimpl1_.u_icq as u_icq35_168_1_,
  userimpl1_.fk_identity as fk_identity81_168_1_,
  userimpl1_.u_institutionalemail as u_institutionalem36_168_1_,
  userimpl1_.u_institutionalname as u_institutionalna37_168_1_,
  userimpl1_.u_institutionaluseridentifier as u_institutionalus38_168_1_,
  userimpl1_.u_lastname as u_lastname39_168_1_,
  userimpl1_.u_msn as u_msn40_168_1_,
  userimpl1_.u_officecity as u_officecity41_168_1_,
  userimpl1_.u_officecountry as u_officecountry42_168_1_,
  userimpl1_.u_officemobilephone as u_officemobilepho43_168_1_,
  userimpl1_.u_officepobox as u_officepobox44_168_1_,
  userimpl1_.u_officestreet as u_officestreet45_168_1_,
  userimpl1_.u_officezipcode as u_officezipcode46_168_1_,
  userimpl1_.u_orgunit as u_orgunit47_168_1_,
  userimpl1_.u_organizationalunit as u_organizationalu48_168_1_,
  userimpl1_.u_pobox as u_pobox49_168_1_,
  userimpl1_.u_position as u_position50_168_1_,
  userimpl1_.fontsize as fontsize51_168_1_,
  userimpl1_.informsessiontimeout as informsessiontime52_168_1_,
  userimpl1_.language as language53_168_1_,
  userimpl1_.notification_interval as notification_inte54_168_1_,
  userimpl1_.presencemessagespublic as presencemessagesp55_168_1_,
  userimpl1_.receiverealmail as receiverealmail56_168_1_,
  userimpl1_.u_privateemail as u_privateemail57_168_1_,
  userimpl1_.u_rank as u_rank58_168_1_,
  userimpl1_.u_region as u_region59_168_1_,
  userimpl1_.u_skype as u_skype60_168_1_,
  userimpl1_.u_smstelmobile as u_smstelmobile61_168_1_,
  userimpl1_.u_socialsecuritynumber as u_socialsecurityn62_168_1_,
  userimpl1_.u_street as u_street63_168_1_,
  userimpl1_.u_studysubject as u_studysubject64_168_1_,
  userimpl1_.u_swissedupersonhomeorg as u_swissedupersonh65_168_1_,
  userimpl1_.u_swissedupersonhomeorgtype as u_swissedupersonh66_168_1_,
  userimpl1_.u_swissedupersonstaffcategory as u_swissedupersons67_168_1_,
  userimpl1_.u_swissedupersonstudybranch1 as u_swissedupersons68_168_1_,
  userimpl1_.u_swissedupersonstudybranch2 as u_swissedupersons69_168_1_,
  userimpl1_.u_swissedupersonstudybranch3 as u_swissedupersons70_168_1_,
  userimpl1_.u_swissedupersonstudylevel as u_swissedupersons71_168_1_,
  userimpl1_.u_telmobile as u_telmobile72_168_1_,
  userimpl1_.u_teloffice as u_teloffice73_168_1_,
  userimpl1_.u_telprivate as u_telprivate74_168_1_,
  userimpl1_.u_typeofuser as u_typeofuser75_168_1_,
  userimpl1_.u_userinterests as u_userinterests76_168_1_,
  userimpl1_.u_usersearchedinterests as u_usersearchedint77_168_1_,
  userimpl1_.version as version78_168_1_,
  userimpl1_.u_xing as u_xing79_168_1_,
  userimpl1_.u_zipcode as u_zipcode80_168_1_
from
  o_bs_identity identityim0_
  inner join o_user userimpl1_ on identityim0_.id = userimpl1_.fk_identity
where
  identityim0_.status < 100
order by
  identityim0_.id fetch first :1 rows only
