select this_.user_id as user1_1_3_, this_.user_domain as user7_1_3_, this_.is_locked as is2_1_3_, this_.role_id as role8_1_3_, this_.user_name as user3_1_3_, this_.user_position as user4_1_3_, this_.user_pwd as user5_1_3_, this_.user_telephone as user6_1_3_, itscdomain2_.domain_id as domain1_3_0_, itscdomain2_.domain_desc as domain2_3_0_, itscdomain2_.domain_name as domain3_3_0_, itscdomain2_.domain_type as domain4_3_0_, itscdomain2_.parent_domain as parent5_3_0_, childdomai3_.parent_domain as parent5_5_, childdomai3_.domain_id as domain1_5_, childdomai3_.domain_id as domain1_3_1_, childdomai3_.domain_desc as domain2_3_1_, childdomai3_.domain_name as domain3_3_1_, childdomai3_.domain_type as domain4_3_1_, childdomai3_.parent_domain as parent5_3_1_, itscrolein4_.role_id as role1_0_2_, itscrolein4_.role_desc as role2_0_2_, itscrolein4_.role_name as role3_0_2_ from itsc_user_info this_ left outer join itsc_domain_info itscdomain2_ on this_.user_domain=itscdomain2_.domain_id left outer join itsc_domain_info childdomai3_ on itscdomain2_.domain_id=childdomai3_.parent_domain left outer join itsc_role_info itscrolein4_ on this_.role_id=itscrolein4_.role_id where this_.user_name='aaron'
|