| SQL Id | SQL Text |
|---|
| 003bq55d0rc1t |
select institutio0_.id as id42_20_, institutio0_.f_code as f2_42_20_, institutio0_.f_content as f3_42_20_, institutio0_.f_createDate as f4_42_20_, institutio0_.f_createUser_id as f10_42_20_, institutio0_.f_enabled as f5_42_20_, institutio0_.f_inslevel as f6_42_20_, institutio0_.f_name as f7_42_20_, institutio0_.f_commonFiled_id as f11_42_20_, institutio0_.f_sort as f8_42_20_, institutio0_.f_type as f9_42_20_, user1_.id as id70_0_, user1_.f_account as f2_70_0_, user1_.f_createDate as f3_70_0_, user1_.f_createRole as f4_70_0_, user1_.f_createrName as f5_70_0_, user1_.f_enabled as f6_70_0_, user1_.f_institution_id as f19_70_0_, user1_.f_name as f7_70_0_, user1_.f_password as f8_70_0_, user1_.f_rights as f9_70_0_, user1_.f_role as f10_70_0_, user1_.f_role1 as f11_70_0_, user1_.f_role2 as f12_70_0_, user1_.f_role3 as f13_70_0_, user1_.f_role4 as f14_70_0_, user1_.f_stopReason as f15_70_0_, user1_.f_updateDate as f16_70_0_, user1_.f_updateName as f17_70_0_, user1_.f_useState as f18_70_0_, institutio2_.id as id42_1_, institutio2_.f_code as f2_42_1_, institutio2_.f_content as f3_42_1_, institutio2_.f_createDate as f4_42_1_, institutio2_.f_createUser_id as f10_42_1_, institutio2_.f_enabled as f5_42_1_, institutio2_.f_inslevel as f6_42_1_, institutio2_.f_name as f7_42_1_, institutio2_.f_commonFiled_id as f11_42_1_, institutio2_.f_sort as f8_42_1_, institutio2_.f_type as f9_42_1_, includegra3_.unitid as unitid22_, includegra4_.id as includeid22_
, includegra4_.id as id52_2_, includegra4_.f_adminNum as f2_52_2_, includegra4_.f_batchSetName as f3_52_2_, includegra4_.f_grade as f4_52_2_, includegra4_.f_includeCount as f5_52_2_, includegra4_.f_postName as f6_52_2_, includegra4_.f_type as f7_52_2_, includegra4_.f_unitId as f8_52_2_, includegra4_.f_unitName as f9_52_2_, includegra4_.f_unitNature as f10_52_2_, commonfile5_.id as id75_3_, commonfile5_.f_address as f2_75_3_, commonfile5_.f_code as f3_75_3_, commonfile5_.f_name as f4_75_3_, commonfile5_.f_type as f5_75_3_, commonfile5_.f_updateDate as f6_75_3_, commonfile5_.f_user_id as f7_75_3_, user6_.id as id70_4_, user6_.f_account as f2_70_4_, user6_.f_createDate as f3_70_4_, user6_.f_createRole as f4_70_4_, user6_.f_createrName as f5_70_4_, user6_.f_enabled as f6_70_4_, user6_.f_institution_id as f19_70_4_, user6_.f_name as f7_70_4_, user6_.f_password as f8_70_4_, user6_.f_rights as f9_70_4_, user6_.f_role as f10_70_4_, user6_.f_role1 as f11_70_4_, user6_.f_role2 as f12_70_4_, user6_.f_role3 as f13_70_4_, user6_.f_role4 as f14_70_4_, user6_.f_stopReason as f15_70_4_, user6_.f_updateDate as f16_70_4_, user6_.f_updateName as f17_70_4_, user6_.f_useState as f18_70_4_, specialize7_.userid as userid23_, examspecia8_.id as speciali2_23_, examspecia8_.id as id59_5_, examspecia8_.f_audit as f2_59_5_, examspecia8_.f_begin as f3_59_5_, examspecia8_.f_code as f4_59_5_, examspecia8_.f_examLevel_id as f7_59_5_, examspecia8_.f_isApply as f5_5
9_5_, examspecia8_.f_name as f6_59_5_, examlevel9_.id as id33_6_, examlevel9_.f_amount as f2_33_6_, examlevel9_.f_code as f3_33_6_, examlevel9_.f_exam_id as f6_33_6_, examlevel9_.f_name as f4_33_6_, examlevel9_.f_scroll as f5_33_6_, exam10_.id as id32_7_, exam10_.f_abbreviation as f2_32_7_, exam10_.f_applyDateEnd as f3_32_7_, exam10_.f_applyDateStart as f4_32_7_, exam10_.f_audit as f5_32_7_, exam10_.f_auditDateEnd as f6_32_7_, exam10_.f_auditDateStart as f7_32_7_, exam10_.f_code as f8_32_7_, exam10_.f_examName as f9_32_7_, exam10_.f_examYear as f10_32_7_, exam10_.f_notice as f11_32_7_, exam10_.f_operateDate as f12_32_7_, exam10_.f_payMentDateEnd as f13_32_7_, exam10_.f_payMentDateStart as f14_32_7_, exam10_.f_payType as f15_32_7_, exam10_.f_regularAmount as f16_32_7_, exam10_.f_rule as f17_32_7_, exam10_.f_type as f18_32_7_, discountpa11_.id as id18_8_, discountpa11_.f_discountRate as f2_18_8_, discountpa11_.f_discountScroll as f3_18_8_, discountpa11_.f_discountScrollRate as f4_18_8_, discountpa11_.f_discountType as f5_18_8_, discountpa11_.f_exam_id as f11_18_8_, discountpa11_.f_mode as f6_18_8_, discountpa11_.f_modeScrollValue as f7_18_8_, discountpa11_.f_modeValue as f8_18_8_, discountpa11_.f_payMentType as f9_18_8_, discountpa11_.f_scrollPayMentType as f10_18_8_, examsubjec12_.f_exam_id as f11_24_, examsubjec12_.id as id24_, examsubjec12_.id as id43_9_, examsubjec12_.f_admissionCard_id as f10_43_9_, examsubjec12_.f_amount as f2_43_9
_, examsubjec12_.code as code43_9_, examsubjec12_.endTime as endTime43_9_, examsubjec12_.f_exam_id as f11_43_9_, examsubjec12_.examDate as examDate43_9_, examsubjec12_.gatherDate as gatherDate43_9_, examsubjec12_.f_name as f7_43_9_, examsubjec12_.f_score as f8_43_9_, examsubjec12_.startTime as startTime43_9_, admissionc13_.id as id37_10_, admissionc13_.f_cardCode as f2_37_10_, admissionc13_.f_createDate as f3_37_10_, admissionc13_.f_examArea as f4_37_10_, admissionc13_.f_examLevel as f5_37_10_, admissionc13_.f_examLevelCode as f6_37_10_, admissionc13_.f_examName as f7_37_10_, admissionc13_.f_examPlaceCode as f8_37_10_, admissionc13_.f_examPoint as f9_37_10_, admissionc13_.f_examSpecialty as f10_37_10_, admissionc13_.f_examSpecialtyCode as f11_37_10_, admissionc13_.f_examSubject as f12_37_10_, admissionc13_.f_examSubjectCode as f13_37_10_, admissionc13_.f_examYear as f14_37_10_, admissionc13_.f_idCard as f15_37_10_, admissionc13_.f_seatCode as f16_37_10_, admissionc13_.f_userName as f17_37_10_, applyinfos14_.subjectid as subjectid25_, applyinfo15_.id as applyId25_, applyinfo15_.id as id4_11_, applyinfo15_.f_applyCode as f2_4_11_, applyinfo15_.f_applyDate as f3_4_11_, applyinfo15_.f_applyMode as f4_4_11_, applyinfo15_.f_applySerial as f5_4_11_, applyinfo15_.f_auditDate as f6_4_11_, applyinfo15_.f_auditName as f7_4_11_, applyinfo15_.f_auditRevocationDate as f8_4_11_, applyinfo15_.f_auditer_id as f20_4_11_, applyinfo15_.f_confirm as f9_4_11_,
applyinfo15_.f_exam_id as f21_4_11_, applyinfo15_.f_examLevel_id as f22_4_11_, applyinfo15_.f_examSpecializedField_id as f23_4_11_, applyinfo15_.f_gatheringDate as f10_4_11_, applyinfo15_.f_gatheringUser_id as f24_4_11_, applyinfo15_.f_paymentAmount as f11_4_11_, applyinfo15_.f_paymentComeSerial as f12_4_11_, applyinfo15_.f_paymentDate as f13_4_11_, applyinfo15_.f_paymentMode as f14_4_11_, applyinfo15_.f_paymentOrderCode as f15_4_11_, applyinfo15_.f_rejectDate as f16_4_11_, applyinfo15_.f_rejectReason as f17_4_11_, applyinfo15_.f_state as f18_4_11_, applyinfo15_.f_stauts as f19_4_11_, user16_.id as id70_12_, user16_.f_account as f2_70_12_, user16_.f_createDate as f3_70_12_, user16_.f_createRole as f4_70_12_, user16_.f_createrName as f5_70_12_, user16_.f_enabled as f6_70_12_, user16_.f_institution_id as f19_70_12_, user16_.f_name as f7_70_12_, user16_.f_password as f8_70_12_, user16_.f_rights as f9_70_12_, user16_.f_role as f10_70_12_, user16_.f_role1 as f11_70_12_, user16_.f_role2 as f12_70_12_, user16_.f_role3 as f13_70_12_, user16_.f_role4 as f14_70_12_, user16_.f_stopReason as f15_70_12_, user16_.f_updateDate as f16_70_12_, user16_.f_updateName as f17_70_12_, user16_.f_useState as f18_70_12_, exam17_.id as id32_13_, exam17_.f_abbreviation as f2_32_13_, exam17_.f_applyDateEnd as f3_32_13_, exam17_.f_applyDateStart as f4_32_13_, exam17_.f_audit as f5_32_13_, exam17_.f_auditDateEnd as f6_32_13_, exam17_.f_auditDateStart as f7_32_13_, e
xam17_.f_code as f8_32_13_, exam17_.f_examName as f9_32_13_, exam17_.f_examYear as f10_32_13_, exam17_.f_notice as f11_32_13_, exam17_.f_operateDate as f12_32_13_, exam17_.f_payMentDateEnd as f13_32_13_, exam17_.f_payMentDateStart as f14_32_13_, exam17_.f_payType as f15_32_13_, exam17_.f_regularAmount as f16_32_13_, exam17_.f_rule as f17_32_13_, exam17_.f_type as f18_32_13_, examlevel18_.id as id33_14_, examlevel18_.f_amount as f2_33_14_, examlevel18_.f_code as f3_33_14_, examlevel18_.f_exam_id as f6_33_14_, examlevel18_.f_name as f4_33_14_, examlevel18_.f_scroll as f5_33_14_, examspecia19_.id as id59_15_, examspecia19_.f_audit as f2_59_15_, examspecia19_.f_begin as f3_59_15_, examspecia19_.f_code as f4_59_15_, examspecia19_.f_examLevel_id as f7_59_15_, examspecia19_.f_isApply as f5_59_15_, examspecia19_.f_name as f6_59_15_, user20_.id as id70_16_, user20_.f_account as f2_70_16_, user20_.f_createDate as f3_70_16_, user20_.f_createRole as f4_70_16_, user20_.f_createrName as f5_70_16_, user20_.f_enabled as f6_70_16_, user20_.f_institution_id as f19_70_16_, user20_.f_name as f7_70_16_, user20_.f_password as f8_70_16_, user20_.f_rights as f9_70_16_, user20_.f_role as f10_70_16_, user20_.f_role1 as f11_70_16_, user20_.f_role2 as f12_70_16_, user20_.f_role3 as f13_70_16_, user20_.f_role4 as f14_70_16_, user20_.f_stopReason as f15_70_16_, user20_.f_updateDate as f16_70_16_, user20_.f_updateName as f17_70_16_, user20_.f_useState as f18_70_16_
, regristuse21_.id as id16_17_, regristuse21_.f_account as f2_16_17_, regristuse21_.f_address as f3_16_17_, regristuse21_.f_applyAddress as f4_16_17_, regristuse21_.f_applyInfo_id as f37_16_17_, regristuse21_.f_area as f5_16_17_, regristuse21_.f_birthday as f6_16_17_, regristuse21_.f_educationalLevel as f7_16_17_, regristuse21_.f_englishLevel as f8_16_17_, regristuse21_.f_examineeFile as f9_16_17_, regristuse21_.f_graduationDate as f10_16_17_, regristuse21_.f_idCard as f11_16_17_, regristuse21_.f_marriageState as f12_16_17_, regristuse21_.f_moblePhone as f13_16_17_, regristuse21_.f_name as f14_16_17_, regristuse21_.f_nationality as f15_16_17_, regristuse21_.f_password as f16_16_17_, regristuse21_.f_personalPhoto as f17_16_17_, regristuse21_.f_phone as f18_16_17_, regristuse21_.f_politicsStatus as f19_16_17_, regristuse21_.f_post as f20_16_17_, regristuse21_.f_postStuation as f21_16_17_, regristuse21_.f_postbox as f22_16_17_, regristuse21_.f_profession as f23_16_17_, regristuse21_.f_professionLevel as f24_16_17_, regristuse21_.f_registeredResidence as f25_16_17_, regristuse21_.f_school as f26_16_17_, regristuse21_.f_schoolRecord as f27_16_17_, regristuse21_.f_sex as f28_16_17_, regristuse21_.f_source as f29_16_17_, regristuse21_.f_specializedField as f30_16_17_, regristuse21_.f_technicaTitles as f31_16_17_, regristuse21_.f_unit as f32_16_17_, regristuse21_.f_unitNature as f33_16_17_, regristuse21_.f_userId as f34_16_17_, regristuse21_.f_work
Date as f35_16_17_, regristuse21_.f_workYear as f36_16_17_, writeachie22_.unitid as unitid26_, writeachie23_.id as waid26_, writeachie23_.id as id46_18_, writeachie23_.f_batchSetName as f2_46_18_, writeachie23_.f_policy as f3_46_18_, writeachie23_.f_scale as f4_46_18_, writeachie23_.suitType as suitType46_18_, condtions24_.f_writeAchievementBonusPoint as f7_27_, condtions24_.id as id27_, condtions24_.id as id61_19_, condtions24_.f_batchName as f2_61_19_, condtions24_.f_condtion as f3_61_19_, condtions24_.f_relation as f4_61_19_, condtions24_.f_scale as f5_61_19_, condtions24_.f_value as f6_61_19_, condtions24_.f_writeAchievementBonusPoint as f7_61_19_ from institution institutio0_ left outer join users user1_ on institutio0_.f_createUser_id=user1_.id left outer join institution institutio2_ on user1_.f_institution_id=institutio2_.id left outer join include_grade_unit includegra3_ on institutio2_.id=includegra3_.unitid left outer join include_grade_set includegra4_ on includegra3_.includeid=includegra4_.id left outer join common_filed commonfile5_ on institutio2_.f_commonFiled_id=commonfile5_.id left outer join users user6_ on commonfile5_.f_user_id=user6_.id left outer join specializedField_auditer specialize7_ on user6_.id=specialize7_.userid left outer join exam_specializedField examspecia8_ on specialize7_.specializedField=examspecia8_.id left outer join exam_level examlevel9_ on examspecia8_.f_examLevel_id=examlevel9_.id left outer join exams exam10_ on e
xamlevel9_.f_exam_id=exam10_.id left outer join discount_payment discountpa11_ on exam10_.id=discountpa11_.f_exam_id left outer join exam_subject examsubjec12_ on examspecia8_.id=examsubjec12_.f_exam_id left outer join adminssion_card admissionc13_ on examsubjec12_.f_admissionCard_id=admissionc13_.id left outer join applyInfo_exsubject applyinfos14_ on examsubjec12_.id=applyinfos14_.subjectid left outer join apply_info applyinfo15_ on applyinfos14_.applyId=applyinfo15_.id left outer join users user16_ on applyinfo15_.f_auditer_id=user16_.id left outer join exams exam17_ on applyinfo15_.f_exam_id=exam17_.id left outer join exam_level examlevel18_ on applyinfo15_.f_examLevel_id=examlevel18_.id left outer join exam_specializedField examspecia19_ on applyinfo15_.f_examSpecializedField_id=examspecia19_.id left outer join users user20_ on applyinfo15_.f_gatheringUser_id=user20_.id left outer join user_apply_info regristuse21_ on applyinfo15_.id=regristuse21_.f_applyInfo_id left outer join BonusPoint_unit writeachie22_ on institutio2_.id=writeachie22_.unitid left outer join write_Achie_BPoint writeachie23_ on writeachie22_.waid=writeachie23_.id left outer join write_Achie_BPoint_condition condtions24_ on writeachie23_.id=condtions24_.f_writeAchievementBonusPoint where institutio0_.id=:1 order by examsubjec12_.id ASC
|
| 04jamhnwc3p1b | select * from ( select row_.*, rownum rownum_ from ( SELECT * from VIEW_EXAMADMITPLAN where f_state<>1 and f_type='1' ) row_ where rownum <= :1) where rownum_ > :2 |
| 0822gj4rp3qpj | select * from ( select row_.*, rownum rownum_ from ( SELECT * from VIEW_APPLYVIEW where f_state <> 3 and f_reportUnit_id=393275 and f_postName like '%书记员%' and f_postName like '%书记员%' and f_state like '%2%' order by id desc ) row_ where rownum <= :1) where rownum_ > :2 |
| 0r85dzprg9m1z |
select regristeus0_.id as id107_0_, regristeus0_.f_account as f2_107_0_, regristeus0_.f_address as f3_107_0_, regristeus0_.f_applyAddress as f4_107_0_, regristeus0_.f_area as f5_107_0_, regristeus0_.f_birthday as f6_107_0_, regristeus0_.f_educationalLevel as f7_107_0_, regristeus0_.f_email as f8_107_0_, regristeus0_.f_englishLevel as f9_107_0_, regristeus0_.f_examineeFile as f10_107_0_, regristeus0_.f_graduationDate as f11_107_0_, regristeus0_.f_idCard as f12_107_0_, regristeus0_.f_loginDate as f13_107_0_, regristeus0_.f_marriageState as f14_107_0_, regristeus0_.f_moblePhone as f15_107_0_, regristeus0_.f_name as f16_107_0_, regristeus0_.f_nationality as f17_107_0_, regristeus0_.f_password as f18_107_0_, regristeus0_.f_personalPhoto as f19_107_0_, regristeus0_.f_phone as f20_107_0_, regristeus0_.f_politicsStatus as f21_107_0_, regristeus0_.f_post as f22_107_0_, regristeus0_.f_postStuation as f23_107_0_, regristeus0_.f_postbox as f24_107_0_, regristeus0_.f_profession as f25_107_0_, regristeus0_.f_registeredResidence as f26_107_0_, regristeus0_.f_regristDate as f27_107_0_, regristeus0_.f_remark as f28_107_0_, regristeus0_.f_resume as f29_107_0_, regristeus0_.f_school as f30_107_0_, regristeus0_.f_schoolRecord as f31_107_0_, regristeus0_.f_sex as f32_107_0_, regristeus0_.f_source as f33_107_0_, regristeus0_.f_specializedField as f34_107_0_, regristeus0_.f_technicaTitles as f35_107_0_, regristeus0_.f_unit as f36_107_0_, regristeus0_.f_unitNature
as f37_107_0_, regristeus0_.f_useState as f38_107_0_, regristeus0_.f_workDate as f39_107_0_, regristeus0_.f_workYear as f40_107_0_ from regrist_user regristeus0_ where regristeus0_.id=:1 |
| 0spgm5sapkv18 | select writeachie0_.unitid as unitid1_, writeachie0_.waid as waid1_, writeachie1_.id as id46_0_, writeachie1_.f_batchSetName as f2_46_0_, writeachie1_.f_policy as f3_46_0_, writeachie1_.f_scale as f4_46_0_, writeachie1_.suitType as suitType46_0_ from BonusPoint_unit writeachie0_ left outer join write_Achie_BPoint writeachie1_ on writeachie0_.waid=writeachie1_.id where writeachie0_.unitid=:1 |
| 10q77r864136m |
select commonfile0_.id as id72_20_, commonfile0_.f_address as f2_72_20_, commonfile0_.f_code as f3_72_20_, commonfile0_.f_name as f4_72_20_, commonfile0_.f_type as f5_72_20_, commonfile0_.f_updateDate as f6_72_20_, commonfile0_.f_user_id as f7_72_20_, user1_.id as id8_0_, user1_.f_account as f2_8_0_, user1_.f_createDate as f3_8_0_, user1_.f_createRole as f4_8_0_, user1_.f_createrName as f5_8_0_, user1_.f_enabled as f6_8_0_, user1_.f_institution_id as f19_8_0_, user1_.f_name as f7_8_0_, user1_.f_password as f8_8_0_, user1_.f_rights as f9_8_0_, user1_.f_role as f10_8_0_, user1_.f_role1 as f11_8_0_, user1_.f_role2 as f12_8_0_, user1_.f_role3 as f13_8_0_, user1_.f_role4 as f14_8_0_, user1_.f_stopReason as f15_8_0_, user1_.f_updateDate as f16_8_0_, user1_.f_updateName as f17_8_0_, user1_.f_useState as f18_8_0_, institutio2_.id as id65_1_, institutio2_.f_code as f2_65_1_, institutio2_.f_content as f3_65_1_, institutio2_.f_createDate as f4_65_1_, institutio2_.f_createUser_id as f10_65_1_, institutio2_.f_enabled as f5_65_1_, institutio2_.f_inslevel as f6_65_1_, institutio2_.f_name as f7_65_1_, institutio2_.f_commonFiled_id as f11_65_1_, institutio2_.f_sort as f8_65_1_, institutio2_.f_type as f9_65_1_, user3_.id as id8_2_, user3_.f_account as f2_8_2_, user3_.f_createDate as f3_8_2_, user3_.f_createRole as f4_8_2_, user3_.f_createrName as f5_8_2_, user3_.f_enabled as f6_8_2_, user3_.f_institution_id as f19_8_2_, user3_.f_name as f7_8_2_, use
r3_.f_password as f8_8_2_, user3_.f_rights as f9_8_2_, user3_.f_role as f10_8_2_, user3_.f_role1 as f11_8_2_, user3_.f_role2 as f12_8_2_, user3_.f_role3 as f13_8_2_, user3_.f_role4 as f14_8_2_, user3_.f_stopReason as f15_8_2_, user3_.f_updateDate as f16_8_2_, user3_.f_updateName as f17_8_2_, user3_.f_useState as f18_8_2_, specialize4_.userid as userid22_, examspecia5_.id as speciali1_22_, examspecia5_.id as id34_3_, examspecia5_.f_audit as f2_34_3_, examspecia5_.f_begin as f3_34_3_, examspecia5_.f_code as f4_34_3_, examspecia5_.f_examLevel_id as f7_34_3_, examspecia5_.f_isApply as f5_34_3_, examspecia5_.f_name as f6_34_3_, examlevel6_.id as id42_4_, examlevel6_.f_amount as f2_42_4_, examlevel6_.f_code as f3_42_4_, examlevel6_.f_exam_id as f6_42_4_, examlevel6_.f_name as f4_42_4_, examlevel6_.f_scroll as f5_42_4_, exam7_.id as id80_5_, exam7_.f_abbreviation as f2_80_5_, exam7_.f_applyDateEnd as f3_80_5_, exam7_.f_applyDateStart as f4_80_5_, exam7_.f_audit as f5_80_5_, exam7_.f_auditDateEnd as f6_80_5_, exam7_.f_auditDateStart as f7_80_5_, exam7_.f_code as f8_80_5_, exam7_.f_examName as f9_80_5_, exam7_.f_examYear as f10_80_5_, exam7_.f_notice as f11_80_5_, exam7_.f_operateDate as f12_80_5_, exam7_.f_payMentDateEnd as f13_80_5_, exam7_.f_payMentDateStart as f14_80_5_, exam7_.f_payType as f15_80_5_, exam7_.f_regularAmount as f16_80_5_, exam7_.f_rule as f17_80_5_, exam7_.f_type as f18_80_5_, discountpa8_.id as id92_6_, discountpa8_.f_d
iscountRate as f2_92_6_, discountpa8_.f_discountScroll as f3_92_6_, discountpa8_.f_discountScrollRate as f4_92_6_, discountpa8_.f_discountType as f5_92_6_, discountpa8_.f_exam_id as f11_92_6_, discountpa8_.f_mode as f6_92_6_, discountpa8_.f_modeScrollValue as f7_92_6_, discountpa8_.f_modeValue as f8_92_6_, discountpa8_.f_payMentType as f9_92_6_, discountpa8_.f_scrollPayMentType as f10_92_6_, examsubjec9_.f_exam_id as f11_23_, examsubjec9_.id as id23_, examsubjec9_.id as id73_7_, examsubjec9_.f_admissionCard_id as f10_73_7_, examsubjec9_.f_amount as f2_73_7_, examsubjec9_.code as code73_7_, examsubjec9_.endTime as endTime73_7_, examsubjec9_.f_exam_id as f11_73_7_, examsubjec9_.examDate as examDate73_7_, examsubjec9_.gatherDate as gatherDate73_7_, examsubjec9_.f_name as f7_73_7_, examsubjec9_.f_score as f8_73_7_, examsubjec9_.startTime as startTime73_7_, admissionc10_.id as id58_8_, admissionc10_.f_cardCode as f2_58_8_, admissionc10_.f_createDate as f3_58_8_, admissionc10_.f_examArea as f4_58_8_, admissionc10_.f_examLevel as f5_58_8_, admissionc10_.f_examLevelCode as f6_58_8_, admissionc10_.f_examName as f7_58_8_, admissionc10_.f_examPlaceCode as f8_58_8_, admissionc10_.f_examPoint as f9_58_8_, admissionc10_.f_examSpecialty as f10_58_8_, admissionc10_.f_examSpecialtyCode as f11_58_8_, admissionc10_.f_examSubject as f12_58_8_, admissionc10_.f_examSubjectCode as f13_58_8_, admissionc10_.f_examYear as f14_58_8_, admissionc10_.f_idCard as f15_58
_8_, admissionc10_.f_seatCode as f16_58_8_, admissionc10_.f_userName as f17_58_8_, applyinfos11_.subjectid as subjectid24_, applyinfo12_.id as applyId24_, applyinfo12_.id as id25_9_, applyinfo12_.f_applyCode as f2_25_9_, applyinfo12_.f_applyDate as f3_25_9_, applyinfo12_.f_applyMode as f4_25_9_, applyinfo12_.f_applySerial as f5_25_9_, applyinfo12_.f_auditDate as f6_25_9_, applyinfo12_.f_auditName as f7_25_9_, applyinfo12_.f_auditRevocationDate as f8_25_9_, applyinfo12_.f_auditer_id as f20_25_9_, applyinfo12_.f_confirm as f9_25_9_, applyinfo12_.f_exam_id as f21_25_9_, applyinfo12_.f_examLevel_id as f22_25_9_, applyinfo12_.f_examSpecializedField_id as f23_25_9_, applyinfo12_.f_gatheringDate as f10_25_9_, applyinfo12_.f_gatheringUser_id as f24_25_9_, applyinfo12_.f_paymentAmount as f11_25_9_, applyinfo12_.f_paymentComeSerial as f12_25_9_, applyinfo12_.f_paymentDate as f13_25_9_, applyinfo12_.f_paymentMode as f14_25_9_, applyinfo12_.f_paymentOrderCode as f15_25_9_, applyinfo12_.f_rejectDate as f16_25_9_, applyinfo12_.f_rejectReason as f17_25_9_, applyinfo12_.f_state as f18_25_9_, applyinfo12_.f_stauts as f19_25_9_, user13_.id as id8_10_, user13_.f_account as f2_8_10_, user13_.f_createDate as f3_8_10_, user13_.f_createRole as f4_8_10_, user13_.f_createrName as f5_8_10_, user13_.f_enabled as f6_8_10_, user13_.f_institution_id as f19_8_10_, user13_.f_name as f7_8_10_, user13_.f_password as f8_8_10_, user13_.f_rights as f9_8_10_, user13_.f_role
as f10_8_10_, user13_.f_role1 as f11_8_10_, user13_.f_role2 as f12_8_10_, user13_.f_role3 as f13_8_10_, user13_.f_role4 as f14_8_10_, user13_.f_stopReason as f15_8_10_, user13_.f_updateDate as f16_8_10_, user13_.f_updateName as f17_8_10_, user13_.f_useState as f18_8_10_, exam14_.id as id80_11_, exam14_.f_abbreviation as f2_80_11_, exam14_.f_applyDateEnd as f3_80_11_, exam14_.f_applyDateStart as f4_80_11_, exam14_.f_audit as f5_80_11_, exam14_.f_auditDateEnd as f6_80_11_, exam14_.f_auditDateStart as f7_80_11_, exam14_.f_code as f8_80_11_, exam14_.f_examName as f9_80_11_, exam14_.f_examYear as f10_80_11_, exam14_.f_notice as f11_80_11_, exam14_.f_operateDate as f12_80_11_, exam14_.f_payMentDateEnd as f13_80_11_, exam14_.f_payMentDateStart as f14_80_11_, exam14_.f_payType as f15_80_11_, exam14_.f_regularAmount as f16_80_11_, exam14_.f_rule as f17_80_11_, exam14_.f_type as f18_80_11_, examlevel15_.id as id42_12_, examlevel15_.f_amount as f2_42_12_, examlevel15_.f_code as f3_42_12_, examlevel15_.f_exam_id as f6_42_12_, examlevel15_.f_name as f4_42_12_, examlevel15_.f_scroll as f5_42_12_, examspecia16_.id as id34_13_, examspecia16_.f_audit as f2_34_13_, examspecia16_.f_begin as f3_34_13_, examspecia16_.f_code as f4_34_13_, examspecia16_.f_examLevel_id as f7_34_13_, examspecia16_.f_isApply as f5_34_13_, examspecia16_.f_name as f6_34_13_, user17_.id as id8_14_, user17_.f_account as f2_8_14_, user17_.f_createDate as f3_8_14_, user17_.f_create
Role as f4_8_14_, user17_.f_createrName as f5_8_14_, user17_.f_enabled as f6_8_14_, user17_.f_institution_id as f19_8_14_, user17_.f_name as f7_8_14_, user17_.f_password as f8_8_14_, user17_.f_rights as f9_8_14_, user17_.f_role as f10_8_14_, user17_.f_role1 as f11_8_14_, user17_.f_role2 as f12_8_14_, user17_.f_role3 as f13_8_14_, user17_.f_role4 as f14_8_14_, user17_.f_stopReason as f15_8_14_, user17_.f_updateDate as f16_8_14_, user17_.f_updateName as f17_8_14_, user17_.f_useState as f18_8_14_, regristuse18_.id as id82_15_, regristuse18_.f_account as f2_82_15_, regristuse18_.f_address as f3_82_15_, regristuse18_.f_applyAddress as f4_82_15_, regristuse18_.f_applyInfo_id as f37_82_15_, regristuse18_.f_area as f5_82_15_, regristuse18_.f_birthday as f6_82_15_, regristuse18_.f_educationalLevel as f7_82_15_, regristuse18_.f_englishLevel as f8_82_15_, regristuse18_.f_examineeFile as f9_82_15_, regristuse18_.f_graduationDate as f10_82_15_, regristuse18_.f_idCard as f11_82_15_, regristuse18_.f_marriageState as f12_82_15_, regristuse18_.f_moblePhone as f13_82_15_, regristuse18_.f_name as f14_82_15_, regristuse18_.f_nationality as f15_82_15_, regristuse18_.f_password as f16_82_15_, regristuse18_.f_personalPhoto as f17_82_15_, regristuse18_.f_phone as f18_82_15_, regristuse18_.f_politicsStatus as f19_82_15_, regristuse18_.f_post as f20_82_15_, regristuse18_.f_postStuation as f21_82_15_, regristuse18_.f_postbox as f22_82_15_, regristuse18_.f_professi
on as f23_82_15_, regristuse18_.f_professionLevel as f24_82_15_, regristuse18_.f_registeredResidence as f25_82_15_, regristuse18_.f_school as f26_82_15_, regristuse18_.f_schoolRecord as f27_82_15_, regristuse18_.f_sex as f28_82_15_, regristuse18_.f_source as f29_82_15_, regristuse18_.f_specializedField as f30_82_15_, regristuse18_.f_technicaTitles as f31_82_15_, regristuse18_.f_unit as f32_82_15_, regristuse18_.f_unitNature as f33_82_15_, regristuse18_.f_userId as f34_82_15_, regristuse18_.f_workDate as f35_82_15_, regristuse18_.f_workYear as f36_82_15_, includegra19_.unitid as unitid25_, includegra20_.id as includeid25_, includegra20_.id as id22_16_, includegra20_.f_adminNum as f2_22_16_, includegra20_.f_batchSetName as f3_22_16_, includegra20_.f_grade as f4_22_16_, includegra20_.f_includeCount as f5_22_16_, includegra20_.f_postName as f6_22_16_, includegra20_.f_type as f7_22_16_, includegra20_.f_unitId as f8_22_16_, includegra20_.f_unitName as f9_22_16_, includegra20_.f_unitNature as f10_22_16_, commonfile21_.id as id72_17_, commonfile21_.f_address as f2_72_17_, commonfile21_.f_code as f3_72_17_, commonfile21_.f_name as f4_72_17_, commonfile21_.f_type as f5_72_17_, commonfile21_.f_updateDate as f6_72_17_, commonfile21_.f_user_id as f7_72_17_, writeachie22_.unitid as unitid26_, writeachie23_.id as waid26_, writeachie23_.id as id69_18_, writeachie23_.f_batchSetName as f2_69_18_, writeachie23_.f_policy as f3_69_18_, writeachie23_.f_scale a
s f4_69_18_, writeachie23_.suitType as suitType69_18_, condtions24_.f_writeAchievementBonusPoint as f7_27_, condtions24_.id as id27_, condtions24_.id as id57_19_, condtions24_.f_batchName as f2_57_19_, condtions24_.f_condtion as f3_57_19_, condtions24_.f_relation as f4_57_19_, condtions24_.f_scale as f5_57_19_, condtions24_.f_value as f6_57_19_, condtions24_.f_writeAchievementBonusPoint as f7_57_19_ from common_filed commonfile0_ left outer join users user1_ on commonfile0_.f_user_id=user1_.id left outer join institution institutio2_ on user1_.f_institution_id=institutio2_.id left outer join users user3_ on institutio2_.f_createUser_id=user3_.id left outer join specializedField_auditer specialize4_ on user3_.id=specialize4_.userid left outer join exam_specializedField examspecia5_ on specialize4_.specializedField=examspecia5_.id left outer join exam_level examlevel6_ on examspecia5_.f_examLevel_id=examlevel6_.id left outer join exams exam7_ on examlevel6_.f_exam_id=exam7_.id left outer join discount_payment discountpa8_ on exam7_.id=discountpa8_.f_exam_id left outer join exam_subject examsubjec9_ on examspecia5_.id=examsubjec9_.f_exam_id left outer join adminssion_card admissionc10_ on examsubjec9_.f_admissionCard_id=admissionc10_.id left outer join applyInfo_exsubject applyinfos11_ on examsubjec9_.id=applyinfos11_.subjectid left outer join apply_info applyinfo12_ on applyinfos11_.applyId=applyinfo12_.id left outer join users user13_ on applyinfo12_.f_auditer_id=use
r13_.id left outer join exams exam14_ on applyinfo12_.f_exam_id=exam14_.id left outer join exam_level examlevel15_ on applyinfo12_.f_examLevel_id=examlevel15_.id left outer join exam_specializedField examspecia16_ on applyinfo12_.f_examSpecializedField_id=examspecia16_.id left outer join users user17_ on applyinfo12_.f_gatheringUser_id=user17_.id left outer join user_apply_info regristuse18_ on applyinfo12_.id=regristuse18_.f_applyInfo_id left outer join include_grade_unit includegra19_ on institutio2_.id=includegra19_.unitid left outer join include_grade_set includegra20_ on includegra19_.includeid=includegra20_.id left outer join common_filed commonfile21_ on institutio2_.f_commonFiled_id=commonfile21_.id left outer join BonusPoint_unit writeachie22_ on institutio2_.id=writeachie22_.unitid left outer join write_Achie_BPoint writeachie23_ on writeachie22_.waid=writeachie23_.id left outer join write_Achie_BPoint_condition condtions24_ on writeachie23_.id=condtions24_.f_writeAchievementBonusPoint where commonfile0_.id=:1 order by examsubjec9_.id ASC |
| 15g1mrrqfz5cf | select * from ( select count(servantapp0_.id) as col_0_0_ from servantApplyInfos servantapp0_ where servantapp0_.f_examAdmitPlan_id=458977 and servantapp0_.f_state='2' ) where rownum <= :1 |
| 4q7v748h89btt | select includegra0_.unitid as unitid1_, includegra0_.includeid as includeid1_, includegra1_.id as id52_0_, includegra1_.f_adminNum as f2_52_0_, includegra1_.f_batchSetName as f3_52_0_, includegra1_.f_grade as f4_52_0_, includegra1_.f_includeCount as f5_52_0_, includegra1_.f_postName as f6_52_0_, includegra1_.f_type as f7_52_0_, includegra1_.f_unitId as f8_52_0_, includegra1_.f_unitName as f9_52_0_, includegra1_.f_unitNature as f10_52_0_ from include_grade_unit includegra0_ left outer join include_grade_set includegra1_ on includegra0_.includeid=includegra1_.id where includegra0_.unitid=:1 |
| 4tj0gq2hzh4h6 | select distinct categorysu0_.f_typename as col_0_0_ from category_subject categorysu0_ where categorysu0_.f_type='S' |
| 626abtkrmr7p3 |
select examadmitp0_.id as id87_30_, examadmitp0_.f_admitNum as f2_87_30_, examadmitp0_.f_admitUnit_id as f27_87_30_, examadmitp0_.admitUnitName as admitUni3_87_30_, examadmitp0_.f_batchSet_id as f28_87_30_, examadmitp0_.f_batchSetName as f4_87_30_, examadmitp0_.f_categorySubject_id as f29_87_30_, examadmitp0_.examType as examType87_30_, examadmitp0_.hometown as hometown87_30_, examadmitp0_.maxRestrictionAge as maxRestr7_87_30_, examadmitp0_.minRestrictionAge as minRestr8_87_30_, examadmitp0_.f_otherCondition as f9_87_30_, examadmitp0_.f_physicalTest as f10_87_30_, examadmitp0_.f_postId as f11_87_30_, examadmitp0_.f_postName as f12_87_30_, examadmitp0_.f_rejectInfo as f13_87_30_, examadmitp0_.f_remark as f14_87_30_, examadmitp0_.f_repealInfo as f15_87_30_, examadmitp0_.f_reportUnit_id as f30_87_30_, examadmitp0_.reportUnitName as reportU16_87_30_, examadmitp0_.f_requireAge as f17_87_30_, examadmitp0_.f_requireEductionLevel as f18_87_30_, examadmitp0_.f_requireHometown as f19_87_30_, examadmitp0_.f_requireNation as f20_87_30_, examadmitp0_.f_requireSchoolRecord as f21_87_30_, examadmitp0_.f_requireSex as f22_87_30_, examadmitp0_.f_requireSpecialty as f23_87_30_, examadmitp0_.f_state as f24_87_30_, examadmitp0_.f_updateDate as f25_87_30_, examadmitp0_.f_updateInfo as f26_87_30_, examadmitp0_.f_user_id as f31_87_30_, institutio1_.id as id42_0_, institutio1_.f_code as f2_42_0_, institutio1_.f_content as f3_42_0_, institutio1_.f_createDate as f4_42
_0_, institutio1_.f_createUser_id as f10_42_0_, institutio1_.f_enabled as f5_42_0_, institutio1_.f_inslevel as f6_42_0_, institutio1_.f_name as f7_42_0_, institutio1_.f_commonFiled_id as f11_42_0_, institutio1_.f_sort as f8_42_0_, institutio1_.f_type as f9_42_0_, user2_.id as id70_1_, user2_.f_account as f2_70_1_, user2_.f_createDate as f3_70_1_, user2_.f_createRole as f4_70_1_, user2_.f_createrName as f5_70_1_, user2_.f_enabled as f6_70_1_, user2_.f_institution_id as f19_70_1_, user2_.f_name as f7_70_1_, user2_.f_password as f8_70_1_, user2_.f_rights as f9_70_1_, user2_.f_role as f10_70_1_, user2_.f_role1 as f11_70_1_, user2_.f_role2 as f12_70_1_, user2_.f_role3 as f13_70_1_, user2_.f_role4 as f14_70_1_, user2_.f_stopReason as f15_70_1_, user2_.f_updateDate as f16_70_1_, user2_.f_updateName as f17_70_1_, user2_.f_useState as f18_70_1_, institutio3_.id as id42_2_, institutio3_.f_code as f2_42_2_, institutio3_.f_content as f3_42_2_, institutio3_.f_createDate as f4_42_2_, institutio3_.f_createUser_id as f10_42_2_, institutio3_.f_enabled as f5_42_2_, institutio3_.f_inslevel as f6_42_2_, institutio3_.f_name as f7_42_2_, institutio3_.f_commonFiled_id as f11_42_2_, institutio3_.f_sort as f8_42_2_, institutio3_.f_type as f9_42_2_, includegra4_.unitid as unitid32_, includegra5_.id as includeid32_, includegra5_.id as id52_3_, includegra5_.f_adminNum as f2_52_3_, includegra5_.f_batchSetName as f3_52_3_, includegra5_.f_grade as f4_52_3_, inclu
degra5_.f_includeCount as f5_52_3_, includegra5_.f_postName as f6_52_3_, includegra5_.f_type as f7_52_3_, includegra5_.f_unitId as f8_52_3_, includegra5_.f_unitName as f9_52_3_, includegra5_.f_unitNature as f10_52_3_, commonfile6_.id as id75_4_, commonfile6_.f_address as f2_75_4_, commonfile6_.f_code as f3_75_4_, commonfile6_.f_name as f4_75_4_, commonfile6_.f_type as f5_75_4_, commonfile6_.f_updateDate as f6_75_4_, commonfile6_.f_user_id as f7_75_4_, user7_.id as id70_5_, user7_.f_account as f2_70_5_, user7_.f_createDate as f3_70_5_, user7_.f_createRole as f4_70_5_, user7_.f_createrName as f5_70_5_, user7_.f_enabled as f6_70_5_, user7_.f_institution_id as f19_70_5_, user7_.f_name as f7_70_5_, user7_.f_password as f8_70_5_, user7_.f_rights as f9_70_5_, user7_.f_role as f10_70_5_, user7_.f_role1 as f11_70_5_, user7_.f_role2 as f12_70_5_, user7_.f_role3 as f13_70_5_, user7_.f_role4 as f14_70_5_, user7_.f_stopReason as f15_70_5_, user7_.f_updateDate as f16_70_5_, user7_.f_updateName as f17_70_5_, user7_.f_useState as f18_70_5_, specialize8_.userid as userid33_, examspecia9_.id as speciali2_33_, examspecia9_.id as id59_6_, examspecia9_.f_audit as f2_59_6_, examspecia9_.f_begin as f3_59_6_, examspecia9_.f_code as f4_59_6_, examspecia9_.f_examLevel_id as f7_59_6_, examspecia9_.f_isApply as f5_59_6_, examspecia9_.f_name as f6_59_6_, examlevel10_.id as id33_7_, examlevel10_.f_amount as f2_33_7_, examlevel10_.f_code as f3_33_7_, examlevel10_
.f_exam_id as f6_33_7_, examlevel10_.f_name as f4_33_7_, examlevel10_.f_scroll as f5_33_7_, exam11_.id as id32_8_, exam11_.f_abbreviation as f2_32_8_, exam11_.f_applyDateEnd as f3_32_8_, exam11_.f_applyDateStart as f4_32_8_, exam11_.f_audit as f5_32_8_, exam11_.f_auditDateEnd as f6_32_8_, exam11_.f_auditDateStart as f7_32_8_, exam11_.f_code as f8_32_8_, exam11_.f_examName as f9_32_8_, exam11_.f_examYear as f10_32_8_, exam11_.f_notice as f11_32_8_, exam11_.f_operateDate as f12_32_8_, exam11_.f_payMentDateEnd as f13_32_8_, exam11_.f_payMentDateStart as f14_32_8_, exam11_.f_payType as f15_32_8_, exam11_.f_regularAmount as f16_32_8_, exam11_.f_rule as f17_32_8_, exam11_.f_type as f18_32_8_, discountpa12_.id as id18_9_, discountpa12_.f_discountRate as f2_18_9_, discountpa12_.f_discountScroll as f3_18_9_, discountpa12_.f_discountScrollRate as f4_18_9_, discountpa12_.f_discountType as f5_18_9_, discountpa12_.f_exam_id as f11_18_9_, discountpa12_.f_mode as f6_18_9_, discountpa12_.f_modeScrollValue as f7_18_9_, discountpa12_.f_modeValue as f8_18_9_, discountpa12_.f_payMentType as f9_18_9_, discountpa12_.f_scrollPayMentType as f10_18_9_, examsubjec13_.f_exam_id as f11_34_, examsubjec13_.id as id34_, examsubjec13_.id as id43_10_, examsubjec13_.f_admissionCard_id as f10_43_10_, examsubjec13_.f_amount as f2_43_10_, examsubjec13_.code as code43_10_, examsubjec13_.endTime as endTime43_10_, examsubjec13_.f_exam_id as f11_43_10_, examsubjec13_.examDate
as examDate43_10_, examsubjec13_.gatherDate as gatherDate43_10_, examsubjec13_.f_name as f7_43_10_, examsubjec13_.f_score as f8_43_10_, examsubjec13_.startTime as startTime43_10_, admissionc14_.id as id37_11_, admissionc14_.f_cardCode as f2_37_11_, admissionc14_.f_createDate as f3_37_11_, admissionc14_.f_examArea as f4_37_11_, admissionc14_.f_examLevel as f5_37_11_, admissionc14_.f_examLevelCode as f6_37_11_, admissionc14_.f_examName as f7_37_11_, admissionc14_.f_examPlaceCode as f8_37_11_, admissionc14_.f_examPoint as f9_37_11_, admissionc14_.f_examSpecialty as f10_37_11_, admissionc14_.f_examSpecialtyCode as f11_37_11_, admissionc14_.f_examSubject as f12_37_11_, admissionc14_.f_examSubjectCode as f13_37_11_, admissionc14_.f_examYear as f14_37_11_, admissionc14_.f_idCard as f15_37_11_, admissionc14_.f_seatCode as f16_37_11_, admissionc14_.f_userName as f17_37_11_, applyinfos15_.subjectid as subjectid35_, applyinfo16_.id as applyId35_, applyinfo16_.id as id4_12_, applyinfo16_.f_applyCode as f2_4_12_, applyinfo16_.f_applyDate as f3_4_12_, applyinfo16_.f_applyMode as f4_4_12_, applyinfo16_.f_applySerial as f5_4_12_, applyinfo16_.f_auditDate as f6_4_12_, applyinfo16_.f_auditName as f7_4_12_, applyinfo16_.f_auditRevocationDate as f8_4_12_, applyinfo16_.f_auditer_id as f20_4_12_, applyinfo16_.f_confirm as f9_4_12_, applyinfo16_.f_exam_id as f21_4_12_, applyinfo16_.f_examLevel_id as f22_4_12_, applyinfo16_.f_examSpecializedField_id as f23_4_12_,
applyinfo16_.f_gatheringDate as f10_4_12_, applyinfo16_.f_gatheringUser_id as f24_4_12_, applyinfo16_.f_paymentAmount as f11_4_12_, applyinfo16_.f_paymentComeSerial as f12_4_12_, applyinfo16_.f_paymentDate as f13_4_12_, applyinfo16_.f_paymentMode as f14_4_12_, applyinfo16_.f_paymentOrderCode as f15_4_12_, applyinfo16_.f_rejectDate as f16_4_12_, applyinfo16_.f_rejectReason as f17_4_12_, applyinfo16_.f_state as f18_4_12_, applyinfo16_.f_stauts as f19_4_12_, user17_.id as id70_13_, user17_.f_account as f2_70_13_, user17_.f_createDate as f3_70_13_, user17_.f_createRole as f4_70_13_, user17_.f_createrName as f5_70_13_, user17_.f_enabled as f6_70_13_, user17_.f_institution_id as f19_70_13_, user17_.f_name as f7_70_13_, user17_.f_password as f8_70_13_, user17_.f_rights as f9_70_13_, user17_.f_role as f10_70_13_, user17_.f_role1 as f11_70_13_, user17_.f_role2 as f12_70_13_, user17_.f_role3 as f13_70_13_, user17_.f_role4 as f14_70_13_, user17_.f_stopReason as f15_70_13_, user17_.f_updateDate as f16_70_13_, user17_.f_updateName as f17_70_13_, user17_.f_useState as f18_70_13_, exam18_.id as id32_14_, exam18_.f_abbreviation as f2_32_14_, exam18_.f_applyDateEnd as f3_32_14_, exam18_.f_applyDateStart as f4_32_14_, exam18_.f_audit as f5_32_14_, exam18_.f_auditDateEnd as f6_32_14_, exam18_.f_auditDateStart as f7_32_14_, exam18_.f_code as f8_32_14_, exam18_.f_examName as f9_32_14_, exam18_.f_examYear as f10_32_14_, exam18_.f_notice as f11_32_14_, exam
18_.f_operateDate as f12_32_14_, exam18_.f_payMentDateEnd as f13_32_14_, exam18_.f_payMentDateStart as f14_32_14_, exam18_.f_payType as f15_32_14_, exam18_.f_regularAmount as f16_32_14_, exam18_.f_rule as f17_32_14_, exam18_.f_type as f18_32_14_, examlevel19_.id as id33_15_, examlevel19_.f_amount as f2_33_15_, examlevel19_.f_code as f3_33_15_, examlevel19_.f_exam_id as f6_33_15_, examlevel19_.f_name as f4_33_15_, examlevel19_.f_scroll as f5_33_15_, examspecia20_.id as id59_16_, examspecia20_.f_audit as f2_59_16_, examspecia20_.f_begin as f3_59_16_, examspecia20_.f_code as f4_59_16_, examspecia20_.f_examLevel_id as f7_59_16_, examspecia20_.f_isApply as f5_59_16_, examspecia20_.f_name as f6_59_16_, user21_.id as id70_17_, user21_.f_account as f2_70_17_, user21_.f_createDate as f3_70_17_, user21_.f_createRole as f4_70_17_, user21_.f_createrName as f5_70_17_, user21_.f_enabled as f6_70_17_, user21_.f_institution_id as f19_70_17_, user21_.f_name as f7_70_17_, user21_.f_password as f8_70_17_, user21_.f_rights as f9_70_17_, user21_.f_role as f10_70_17_, user21_.f_role1 as f11_70_17_, user21_.f_role2 as f12_70_17_, user21_.f_role3 as f13_70_17_, user21_.f_role4 as f14_70_17_, user21_.f_stopReason as f15_70_17_, user21_.f_updateDate as f16_70_17_, user21_.f_updateName as f17_70_17_, user21_.f_useState as f18_70_17_, regristuse22_.id as id16_18_, regristuse22_.f_account as f2_16_18_, regristuse22_.f_address as f3_16_18_, regristuse22_.f_applyAd
dress as f4_16_18_, regristuse22_.f_applyInfo_id as f37_16_18_, regristuse22_.f_area as f5_16_18_, regristuse22_.f_birthday as f6_16_18_, regristuse22_.f_educationalLevel as f7_16_18_, regristuse22_.f_englishLevel as f8_16_18_, regristuse22_.f_examineeFile as f9_16_18_, regristuse22_.f_graduationDate as f10_16_18_, regristuse22_.f_idCard as f11_16_18_, regristuse22_.f_marriageState as f12_16_18_, regristuse22_.f_moblePhone as f13_16_18_, regristuse22_.f_name as f14_16_18_, regristuse22_.f_nationality as f15_16_18_, regristuse22_.f_password as f16_16_18_, regristuse22_.f_personalPhoto as f17_16_18_, regristuse22_.f_phone as f18_16_18_, regristuse22_.f_politicsStatus as f19_16_18_, regristuse22_.f_post as f20_16_18_, regristuse22_.f_postStuation as f21_16_18_, regristuse22_.f_postbox as f22_16_18_, regristuse22_.f_profession as f23_16_18_, regristuse22_.f_professionLevel as f24_16_18_, regristuse22_.f_registeredResidence as f25_16_18_, regristuse22_.f_school as f26_16_18_, regristuse22_.f_schoolRecord as f27_16_18_, regristuse22_.f_sex as f28_16_18_, regristuse22_.f_source as f29_16_18_, regristuse22_.f_specializedField as f30_16_18_, regristuse22_.f_technicaTitles as f31_16_18_, regristuse22_.f_unit as f32_16_18_, regristuse22_.f_unitNature as f33_16_18_, regristuse22_.f_userId as f34_16_18_, regristuse22_.f_workDate as f35_16_18_, regristuse22_.f_workYear as f36_16_18_, writeachie23_.unitid as unitid36_, writeachie24_.id as waid36_, writeac
hie24_.id as id46_19_, writeachie24_.f_batchSetName as f2_46_19_, writeachie24_.f_policy as f3_46_19_, writeachie24_.f_scale as f4_46_19_, writeachie24_.suitType as suitType46_19_, condtions25_.f_writeAchievementBonusPoint as f7_37_, condtions25_.id as id37_, condtions25_.id as id61_20_, condtions25_.f_batchName as f2_61_20_, condtions25_.f_condtion as f3_61_20_, condtions25_.f_relation as f4_61_20_, condtions25_.f_scale as f5_61_20_, condtions25_.f_value as f6_61_20_, condtions25_.f_writeAchievementBonusPoint as f7_61_20_, batchset26_.id as id50_21_, batchset26_.f_applyEndDate as f2_50_21_, batchset26_.f_applyStartDate as f3_50_21_, batchset26_.f_cardCode as f4_50_21_, batchset26_.f_cardNotice as f5_50_21_, batchset26_.f_chargeType as f6_50_21_, batchset26_.f_examDate as f7_50_21_, batchset26_.f_musterName as f8_50_21_, batchset26_.f_name as f9_50_21_, batchset26_.f_paymentEndDate as f10_50_21_, batchset26_.f_paymentStartDate as f11_50_21_, batchset26_.f_publicApplyCount as f12_50_21_, batchset26_.f_publicAuditCount as f13_50_21_, batchset26_.f_publicPaymentCount as f14_50_21_, batchset26_.f_state as f15_50_21_, batchset26_.f_studentNotice as f16_50_21_, batchset26_.f_tableName as f17_50_21_, batchset26_.f_timelagDate as f18_50_21_, batchset26_.f_type as f19_50_21_, batchset26_.f_unitePrice as f20_50_21_, batchset26_.f_updateDate as f21_50_21_, batchset26_.f_updateName as f22_50_21_, categorych27_.f_batchSet_id as f4_38_, categorych27_.id
as id38_, categorych27_.id as id104_22_, categorych27_.f_amount as f2_104_22_, categorych27_.f_batchSet_id as f4_104_22_, categorych27_.f_name as f3_104_22_, logs28_.f_batchSet_id as f4_39_, logs28_.id as id39_, logs28_.id as id78_23_, logs28_.f_batchSet_id as f4_78_23_, logs28_.f_operatorDate as f2_78_23_, logs28_.f_userName as f3_78_23_, paycheckqu29_.id as id72_24_, paycheckqu29_.f_batchSetname as f3_72_24_, paycheckqu29_.state as state72_24_, categorysu30_.id as id111_25_, categorysu30_.f_name as f2_111_25_, categorysu30_.f_summary as f3_111_25_, categorysu30_.f_type as f4_111_25_, categorysu30_.f_typeCode as f5_111_25_, categorysu30_.f_typename as f6_111_25_, categorysu30_.f_updateDate as f7_111_25_, categorysu30_.f_user_id as f8_111_25_, user31_.id as id70_26_, user31_.f_account as f2_70_26_, user31_.f_createDate as f3_70_26_, user31_.f_createRole as f4_70_26_, user31_.f_createrName as f5_70_26_, user31_.f_enabled as f6_70_26_, user31_.f_institution_id as f19_70_26_, user31_.f_name as f7_70_26_, user31_.f_password as f8_70_26_, user31_.f_rights as f9_70_26_, user31_.f_role as f10_70_26_, user31_.f_role1 as f11_70_26_, user31_.f_role2 as f12_70_26_, user31_.f_role3 as f13_70_26_, user31_.f_role4 as f14_70_26_, user31_.f_stopReason as f15_70_26_, user31_.f_updateDate as f16_70_26_, user31_.f_updateName as f17_70_26_, user31_.f_useState as f18_70_26_, institutio32_.id as id42_27_, institutio32_.f_code as f2_42_27_, institutio32_.
f_content as f3_42_27_, institutio32_.f_createDate as f4_42_27_, institutio32_.f_createUser_id as f10_42_27_, institutio32_.f_enabled as f5_42_27_, institutio32_.f_inslevel as f6_42_27_, institutio32_.f_name as f7_42_27_, institutio32_.f_commonFiled_id as f11_42_27_, institutio32_.f_sort as f8_42_27_, institutio32_.f_type as f9_42_27_, user33_.id as id70_28_, user33_.f_account as f2_70_28_, user33_.f_createDate as f3_70_28_, user33_.f_createRole as f4_70_28_, user33_.f_createrName as f5_70_28_, user33_.f_enabled as f6_70_28_, user33_.f_institution_id as f19_70_28_, user33_.f_name as f7_70_28_, user33_.f_password as f8_70_28_, user33_.f_rights as f9_70_28_, user33_.f_role as f10_70_28_, user33_.f_role1 as f11_70_28_, user33_.f_role2 as f12_70_28_, user33_.f_role3 as f13_70_28_, user33_.f_role4 as f14_70_28_, user33_.f_stopReason as f15_70_28_, user33_.f_updateDate as f16_70_28_, user33_.f_updateName as f17_70_28_, user33_.f_useState as f18_70_28_, ispublishe34_.id as id8_29_, ispublishe34_.batchName as batchName8_29_, ispublishe34_.examadmitplan_id as examadmi6_8_29_, ispublishe34_.isPublish as isPublish8_29_, ispublishe34_.updateDate as updateDate8_29_, ispublishe34_.updateUser as updateUser8_29_ from examAdmitPlan examadmitp0_ left outer join institution institutio1_ on examadmitp0_.f_admitUnit_id=institutio1_.id left outer join users user2_ on institutio1_.f_createUser_id=user2_.id left outer join institution institutio3_ on user2_.f_institu
tion_id=institutio3_.id left outer join include_grade_unit includegra4_ on institutio3_.id=includegra4_.unitid left outer join include_grade_set includegra5_ on includegra4_.includeid=includegra5_.id left outer join common_filed commonfile6_ on institutio3_.f_commonFiled_id=commonfile6_.id left outer join users user7_ on commonfile6_.f_user_id=user7_.id left outer join specializedField_auditer specialize8_ on user7_.id=specialize8_.userid left outer join exam_specializedField examspecia9_ on specialize8_.specializedField=examspecia9_.id left outer join exam_level examlevel10_ on examspecia9_.f_examLevel_id=examlevel10_.id left outer join exams exam11_ on examlevel10_.f_exam_id=exam11_.id left outer join discount_payment discountpa12_ on exam11_.id=discountpa12_.f_exam_id left outer join exam_subject examsubjec13_ on examspecia9_.id=examsubjec13_.f_exam_id left outer join adminssion_card admissionc14_ on examsubjec13_.f_admissionCard_id=admissionc14_.id left outer join applyInfo_exsubject applyinfos15_ on examsubjec13_.id=applyinfos15_.subjectid left outer join apply_info applyinfo16_ on applyinfos15_.applyId=applyinfo16_.id left outer join users user17_ on applyinfo16_.f_auditer_id=user17_.id left outer join exams exam18_ on applyinfo16_.f_exam_id=exam18_.id left outer join exam_level examlevel19_ on applyinfo16_.f_examLevel_id=examlevel19_.id left outer join exam_specializedField examspecia20_ on applyinfo16_.f_examSpecializedField_id=examspecia20_.id left outer join users u
ser21_ on applyinfo16_.f_gatheringUser_id=user21_.id left outer join user_apply_info regristuse22_ on applyinfo16_.id=regristuse22_.f_applyInfo_id left outer join BonusPoint_unit writeachie23_ on institutio3_.id=writeachie23_.unitid left outer join write_Achie_BPoint writeachie24_ on writeachie23_.waid=writeachie24_.id left outer join write_Achie_BPoint_condition condtions25_ on writeachie24_.id=condtions25_.f_writeAchievementBonusPoint left outer join batchSet batchset26_ on examadmitp0_.f_batchSet_id=batchset26_.id left outer join category_charge categorych27_ on batchset26_.id=categorych27_.f_batchSet_id left outer join batchSet_log logs28_ on batchset26_.id=logs28_.f_batchSet_id left outer join PayCheckQuartz paycheckqu29_ on batchset26_.id=paycheckqu29_.f_batchSetname left outer join category_subject categorysu30_ on examadmitp0_.f_categorySubject_id=categorysu30_.id left outer join users user31_ on categorysu30_.f_user_id=user31_.id left outer join institution institutio32_ on examadmitp0_.f_reportUnit_id=institutio32_.id left outer join users user33_ on examadmitp0_.f_user_id=user33_.id left outer join IsPublishExamAdmitPlan ispublishe34_ on examadmitp0_.id=ispublishe34_.examadmitplan_id where examadmitp0_.id=:1 order by examsubjec13_.id ASC |
| 6dnhd625c5gz5 |
select servantapp0_.id as id49_34_, servantapp0_.f_applyCode as f2_49_34_, servantapp0_.f_applyDate as f3_49_34_, servantapp0_.f_auditDate as f4_49_34_, servantapp0_.f_examAdmitPlan_id as f13_49_34_, servantapp0_.f_examerStiation as f5_49_34_, servantapp0_.f_paymentState as f6_49_34_, servantapp0_.f_reapply as f7_49_34_, servantapp0_.f_rejectReason as f8_49_34_, servantapp0_.f_revocationDate as f9_49_34_, servantapp0_.f_revocationName as f10_49_34_, servantapp0_.f_revocationReason as f11_49_34_, servantapp0_.f_state as f12_49_34_, examadmitp1_.id as id87_0_, examadmitp1_.f_admitNum as f2_87_0_, examadmitp1_.f_admitUnit_id as f27_87_0_, examadmitp1_.admitUnitName as admitUni3_87_0_, examadmitp1_.f_batchSet_id as f28_87_0_, examadmitp1_.f_batchSetName as f4_87_0_, examadmitp1_.f_categorySubject_id as f29_87_0_, examadmitp1_.examType as examType87_0_, examadmitp1_.hometown as hometown87_0_, examadmitp1_.maxRestrictionAge as maxRestr7_87_0_, examadmitp1_.minRestrictionAge as minRestr8_87_0_, examadmitp1_.f_otherCondition as f9_87_0_, examadmitp1_.f_physicalTest as f10_87_0_, examadmitp1_.f_postId as f11_87_0_, examadmitp1_.f_postName as f12_87_0_, examadmitp1_.f_rejectInfo as f13_87_0_, examadmitp1_.f_remark as f14_87_0_, examadmitp1_.f_repealInfo as f15_87_0_, examadmitp1_.f_reportUnit_id as f30_87_0_, examadmitp1_.reportUnitName as reportU16_87_0_, examadmitp1_.f_requireAge as f17_87_0_, examadmitp1_.f_requireEductionLevel as f18_87_0_, examad
mitp1_.f_requireHometown as f19_87_0_, examadmitp1_.f_requireNation as f20_87_0_, examadmitp1_.f_requireSchoolRecord as f21_87_0_, examadmitp1_.f_requireSex as f22_87_0_, examadmitp1_.f_requireSpecialty as f23_87_0_, examadmitp1_.f_state as f24_87_0_, examadmitp1_.f_updateDate as f25_87_0_, examadmitp1_.f_updateInfo as f26_87_0_, examadmitp1_.f_user_id as f31_87_0_, institutio2_.id as id42_1_, institutio2_.f_code as f2_42_1_, institutio2_.f_content as f3_42_1_, institutio2_.f_createDate as f4_42_1_, institutio2_.f_createUser_id as f10_42_1_, institutio2_.f_enabled as f5_42_1_, institutio2_.f_inslevel as f6_42_1_, institutio2_.f_name as f7_42_1_, institutio2_.f_commonFiled_id as f11_42_1_, institutio2_.f_sort as f8_42_1_, institutio2_.f_type as f9_42_1_, user3_.id as id70_2_, user3_.f_account as f2_70_2_, user3_.f_createDate as f3_70_2_, user3_.f_createRole as f4_70_2_, user3_.f_createrName as f5_70_2_, user3_.f_enabled as f6_70_2_, user3_.f_institution_id as f19_70_2_, user3_.f_name as f7_70_2_, user3_.f_password as f8_70_2_, user3_.f_rights as f9_70_2_, user3_.f_role as f10_70_2_, user3_.f_role1 as f11_70_2_, user3_.f_role2 as f12_70_2_, user3_.f_role3 as f13_70_2_, user3_.f_role4 as f14_70_2_, user3_.f_stopReason as f15_70_2_, user3_.f_updateDate as f16_70_2_, user3_.f_updateName as f17_70_2_, user3_.f_useState as f18_70_2_, institutio4_.id as id42_3_, institutio4_.f_code as f2_42_3_, institutio4_.f_content as f3_42_3_, institutio4_
.f_createDate as f4_42_3_, institutio4_.f_createUser_id as f10_42_3_, institutio4_.f_enabled as f5_42_3_, institutio4_.f_inslevel as f6_42_3_, institutio4_.f_name as f7_42_3_, institutio4_.f_commonFiled_id as f11_42_3_, institutio4_.f_sort as f8_42_3_, institutio4_.f_type as f9_42_3_, includegra5_.unitid as unitid36_, includegra6_.id as includeid36_, includegra6_.id as id52_4_, includegra6_.f_adminNum as f2_52_4_, includegra6_.f_batchSetName as f3_52_4_, includegra6_.f_grade as f4_52_4_, includegra6_.f_includeCount as f5_52_4_, includegra6_.f_postName as f6_52_4_, includegra6_.f_type as f7_52_4_, includegra6_.f_unitId as f8_52_4_, includegra6_.f_unitName as f9_52_4_, includegra6_.f_unitNature as f10_52_4_, commonfile7_.id as id75_5_, commonfile7_.f_address as f2_75_5_, commonfile7_.f_code as f3_75_5_, commonfile7_.f_name as f4_75_5_, commonfile7_.f_type as f5_75_5_, commonfile7_.f_updateDate as f6_75_5_, commonfile7_.f_user_id as f7_75_5_, user8_.id as id70_6_, user8_.f_account as f2_70_6_, user8_.f_createDate as f3_70_6_, user8_.f_createRole as f4_70_6_, user8_.f_createrName as f5_70_6_, user8_.f_enabled as f6_70_6_, user8_.f_institution_id as f19_70_6_, user8_.f_name as f7_70_6_, user8_.f_password as f8_70_6_, user8_.f_rights as f9_70_6_, user8_.f_role as f10_70_6_, user8_.f_role1 as f11_70_6_, user8_.f_role2 as f12_70_6_, user8_.f_role3 as f13_70_6_, user8_.f_role4 as f14_70_6_, user8_.f_stopReason as f15_70_6_, user8_.f_updateDat
e as f16_70_6_, user8_.f_updateName as f17_70_6_, user8_.f_useState as f18_70_6_, specialize9_.userid as userid37_, examspecia10_.id as speciali2_37_, examspecia10_.id as id59_7_, examspecia10_.f_audit as f2_59_7_, examspecia10_.f_begin as f3_59_7_, examspecia10_.f_code as f4_59_7_, examspecia10_.f_examLevel_id as f7_59_7_, examspecia10_.f_isApply as f5_59_7_, examspecia10_.f_name as f6_59_7_, examlevel11_.id as id33_8_, examlevel11_.f_amount as f2_33_8_, examlevel11_.f_code as f3_33_8_, examlevel11_.f_exam_id as f6_33_8_, examlevel11_.f_name as f4_33_8_, examlevel11_.f_scroll as f5_33_8_, exam12_.id as id32_9_, exam12_.f_abbreviation as f2_32_9_, exam12_.f_applyDateEnd as f3_32_9_, exam12_.f_applyDateStart as f4_32_9_, exam12_.f_audit as f5_32_9_, exam12_.f_auditDateEnd as f6_32_9_, exam12_.f_auditDateStart as f7_32_9_, exam12_.f_code as f8_32_9_, exam12_.f_examName as f9_32_9_, exam12_.f_examYear as f10_32_9_, exam12_.f_notice as f11_32_9_, exam12_.f_operateDate as f12_32_9_, exam12_.f_payMentDateEnd as f13_32_9_, exam12_.f_payMentDateStart as f14_32_9_, exam12_.f_payType as f15_32_9_, exam12_.f_regularAmount as f16_32_9_, exam12_.f_rule as f17_32_9_, exam12_.f_type as f18_32_9_, discountpa13_.id as id18_10_, discountpa13_.f_discountRate as f2_18_10_, discountpa13_.f_discountScroll as f3_18_10_, discountpa13_.f_discountScrollRate as f4_18_10_, discountpa13_.f_discountType as f5_18_10_, discountpa13_.f_exam_id as f11_18_10_, discount
pa13_.f_mode as f6_18_10_, discountpa13_.f_modeScrollValue as f7_18_10_, discountpa13_.f_modeValue as f8_18_10_, discountpa13_.f_payMentType as f9_18_10_, discountpa13_.f_scrollPayMentType as f10_18_10_, examsubjec14_.f_exam_id as f11_38_, examsubjec14_.id as id38_, examsubjec14_.id as id43_11_, examsubjec14_.f_admissionCard_id as f10_43_11_, examsubjec14_.f_amount as f2_43_11_, examsubjec14_.code as code43_11_, examsubjec14_.endTime as endTime43_11_, examsubjec14_.f_exam_id as f11_43_11_, examsubjec14_.examDate as examDate43_11_, examsubjec14_.gatherDate as gatherDate43_11_, examsubjec14_.f_name as f7_43_11_, examsubjec14_.f_score as f8_43_11_, examsubjec14_.startTime as startTime43_11_, admissionc15_.id as id37_12_, admissionc15_.f_cardCode as f2_37_12_, admissionc15_.f_createDate as f3_37_12_, admissionc15_.f_examArea as f4_37_12_, admissionc15_.f_examLevel as f5_37_12_, admissionc15_.f_examLevelCode as f6_37_12_, admissionc15_.f_examName as f7_37_12_, admissionc15_.f_examPlaceCode as f8_37_12_, admissionc15_.f_examPoint as f9_37_12_, admissionc15_.f_examSpecialty as f10_37_12_, admissionc15_.f_examSpecialtyCode as f11_37_12_, admissionc15_.f_examSubject as f12_37_12_, admissionc15_.f_examSubjectCode as f13_37_12_, admissionc15_.f_examYear as f14_37_12_, admissionc15_.f_idCard as f15_37_12_, admissionc15_.f_seatCode as f16_37_12_, admissionc15_.f_userName as f17_37_12_, applyinfos16_.subjectid as subjectid39_, applyinfo17_.id as applyId3
9_, applyinfo17_.id as id4_13_, applyinfo17_.f_applyCode as f2_4_13_, applyinfo17_.f_applyDate as f3_4_13_, applyinfo17_.f_applyMode as f4_4_13_, applyinfo17_.f_applySerial as f5_4_13_, applyinfo17_.f_auditDate as f6_4_13_, applyinfo17_.f_auditName as f7_4_13_, applyinfo17_.f_auditRevocationDate as f8_4_13_, applyinfo17_.f_auditer_id as f20_4_13_, applyinfo17_.f_confirm as f9_4_13_, applyinfo17_.f_exam_id as f21_4_13_, applyinfo17_.f_examLevel_id as f22_4_13_, applyinfo17_.f_examSpecializedField_id as f23_4_13_, applyinfo17_.f_gatheringDate as f10_4_13_, applyinfo17_.f_gatheringUser_id as f24_4_13_, applyinfo17_.f_paymentAmount as f11_4_13_, applyinfo17_.f_paymentComeSerial as f12_4_13_, applyinfo17_.f_paymentDate as f13_4_13_, applyinfo17_.f_paymentMode as f14_4_13_, applyinfo17_.f_paymentOrderCode as f15_4_13_, applyinfo17_.f_rejectDate as f16_4_13_, applyinfo17_.f_rejectReason as f17_4_13_, applyinfo17_.f_state as f18_4_13_, applyinfo17_.f_stauts as f19_4_13_, user18_.id as id70_14_, user18_.f_account as f2_70_14_, user18_.f_createDate as f3_70_14_, user18_.f_createRole as f4_70_14_, user18_.f_createrName as f5_70_14_, user18_.f_enabled as f6_70_14_, user18_.f_institution_id as f19_70_14_, user18_.f_name as f7_70_14_, user18_.f_password as f8_70_14_, user18_.f_rights as f9_70_14_, user18_.f_role as f10_70_14_, user18_.f_role1 as f11_70_14_, user18_.f_role2 as f12_70_14_, user18_.f_role3 as f13_70_14_, user18_.f_role4 as f14_70_14_, u
ser18_.f_stopReason as f15_70_14_, user18_.f_updateDate as f16_70_14_, user18_.f_updateName as f17_70_14_, user18_.f_useState as f18_70_14_, exam19_.id as id32_15_, exam19_.f_abbreviation as f2_32_15_, exam19_.f_applyDateEnd as f3_32_15_, exam19_.f_applyDateStart as f4_32_15_, exam19_.f_audit as f5_32_15_, exam19_.f_auditDateEnd as f6_32_15_, exam19_.f_auditDateStart as f7_32_15_, exam19_.f_code as f8_32_15_, exam19_.f_examName as f9_32_15_, exam19_.f_examYear as f10_32_15_, exam19_.f_notice as f11_32_15_, exam19_.f_operateDate as f12_32_15_, exam19_.f_payMentDateEnd as f13_32_15_, exam19_.f_payMentDateStart as f14_32_15_, exam19_.f_payType as f15_32_15_, exam19_.f_regularAmount as f16_32_15_, exam19_.f_rule as f17_32_15_, exam19_.f_type as f18_32_15_, examlevel20_.id as id33_16_, examlevel20_.f_amount as f2_33_16_, examlevel20_.f_code as f3_33_16_, examlevel20_.f_exam_id as f6_33_16_, examlevel20_.f_name as f4_33_16_, examlevel20_.f_scroll as f5_33_16_, examspecia21_.id as id59_17_, examspecia21_.f_audit as f2_59_17_, examspecia21_.f_begin as f3_59_17_, examspecia21_.f_code as f4_59_17_, examspecia21_.f_examLevel_id as f7_59_17_, examspecia21_.f_isApply as f5_59_17_, examspecia21_.f_name as f6_59_17_, user22_.id as id70_18_, user22_.f_account as f2_70_18_, user22_.f_createDate as f3_70_18_, user22_.f_createRole as f4_70_18_, user22_.f_createrName as f5_70_18_, user22_.f_enabled as f6_70_18_, user22_.f_institution_id as f19_70_18_, us
er22_.f_name as f7_70_18_, user22_.f_password as f8_70_18_, user22_.f_rights as f9_70_18_, user22_.f_role as f10_70_18_, user22_.f_role1 as f11_70_18_, user22_.f_role2 as f12_70_18_, user22_.f_role3 as f13_70_18_, user22_.f_role4 as f14_70_18_, user22_.f_stopReason as f15_70_18_, user22_.f_updateDate as f16_70_18_, user22_.f_updateName as f17_70_18_, user22_.f_useState as f18_70_18_, regristuse23_.id as id16_19_, regristuse23_.f_account as f2_16_19_, regristuse23_.f_address as f3_16_19_, regristuse23_.f_applyAddress as f4_16_19_, regristuse23_.f_applyInfo_id as f37_16_19_, regristuse23_.f_area as f5_16_19_, regristuse23_.f_birthday as f6_16_19_, regristuse23_.f_educationalLevel as f7_16_19_, regristuse23_.f_englishLevel as f8_16_19_, regristuse23_.f_examineeFile as f9_16_19_, regristuse23_.f_graduationDate as f10_16_19_, regristuse23_.f_idCard as f11_16_19_, regristuse23_.f_marriageState as f12_16_19_, regristuse23_.f_moblePhone as f13_16_19_, regristuse23_.f_name as f14_16_19_, regristuse23_.f_nationality as f15_16_19_, regristuse23_.f_password as f16_16_19_, regristuse23_.f_personalPhoto as f17_16_19_, regristuse23_.f_phone as f18_16_19_, regristuse23_.f_politicsStatus as f19_16_19_, regristuse23_.f_post as f20_16_19_, regristuse23_.f_postStuation as f21_16_19_, regristuse23_.f_postbox as f22_16_19_, regristuse23_.f_profession as f23_16_19_, regristuse23_.f_professionLevel as f24_16_19_, regristuse23_.f_registeredResidence as f25_16_19_,
regristuse23_.f_school as f26_16_19_, regristuse23_.f_schoolRecord as f27_16_19_, regristuse23_.f_sex as f28_16_19_, regristuse23_.f_source as f29_16_19_, regristuse23_.f_specializedField as f30_16_19_, regristuse23_.f_technicaTitles as f31_16_19_, regristuse23_.f_unit as f32_16_19_, regristuse23_.f_unitNature as f33_16_19_, regristuse23_.f_userId as f34_16_19_, regristuse23_.f_workDate as f35_16_19_, regristuse23_.f_workYear as f36_16_19_, writeachie24_.unitid as unitid40_, writeachie25_.id as waid40_, writeachie25_.id as id46_20_, writeachie25_.f_batchSetName as f2_46_20_, writeachie25_.f_policy as f3_46_20_, writeachie25_.f_scale as f4_46_20_, writeachie25_.suitType as suitType46_20_, condtions26_.f_writeAchievementBonusPoint as f7_41_, condtions26_.id as id41_, condtions26_.id as id61_21_, condtions26_.f_batchName as f2_61_21_, condtions26_.f_condtion as f3_61_21_, condtions26_.f_relation as f4_61_21_, condtions26_.f_scale as f5_61_21_, condtions26_.f_value as f6_61_21_, condtions26_.f_writeAchievementBonusPoint as f7_61_21_, batchset27_.id as id50_22_, batchset27_.f_applyEndDate as f2_50_22_, batchset27_.f_applyStartDate as f3_50_22_, batchset27_.f_cardCode as f4_50_22_, batchset27_.f_cardNotice as f5_50_22_, batchset27_.f_chargeType as f6_50_22_, batchset27_.f_examDate as f7_50_22_, batchset27_.f_musterName as f8_50_22_, batchset27_.f_name as f9_50_22_, batchset27_.f_paymentEndDate as f10_50_22_, batchset27_.f_paymentStartDate as f
11_50_22_, batchset27_.f_publicApplyCount as f12_50_22_, batchset27_.f_publicAuditCount as f13_50_22_, batchset27_.f_publicPaymentCount as f14_50_22_, batchset27_.f_state as f15_50_22_, batchset27_.f_studentNotice as f16_50_22_, batchset27_.f_tableName as f17_50_22_, batchset27_.f_timelagDate as f18_50_22_, batchset27_.f_type as f19_50_22_, batchset27_.f_unitePrice as f20_50_22_, batchset27_.f_updateDate as f21_50_22_, batchset27_.f_updateName as f22_50_22_, categorych28_.f_batchSet_id as f4_42_, categorych28_.id as id42_, categorych28_.id as id104_23_, categorych28_.f_amount as f2_104_23_, categorych28_.f_batchSet_id as f4_104_23_, categorych28_.f_name as f3_104_23_, logs29_.f_batchSet_id as f4_43_, logs29_.id as id43_, logs29_.id as id78_24_, logs29_.f_batchSet_id as f4_78_24_, logs29_.f_operatorDate as f2_78_24_, logs29_.f_userName as f3_78_24_, paycheckqu30_.id as id72_25_, paycheckqu30_.f_batchSetname as f3_72_25_, paycheckqu30_.state as state72_25_, categorysu31_.id as id111_26_, categorysu31_.f_name as f2_111_26_, categorysu31_.f_summary as f3_111_26_, categorysu31_.f_type as f4_111_26_, categorysu31_.f_typeCode as f5_111_26_, categorysu31_.f_typename as f6_111_26_, categorysu31_.f_updateDate as f7_111_26_, categorysu31_.f_user_id as f8_111_26_, user32_.id as id70_27_, user32_.f_account as f2_70_27_, user32_.f_createDate as f3_70_27_, user32_.f_createRole as f4_70_27_, user32_.f_createrName as f5_70_27_, user32_.f_enabled as f6_7
0_27_, user32_.f_institution_id as f19_70_27_, user32_.f_name as f7_70_27_, user32_.f_password as f8_70_27_, user32_.f_rights as f9_70_27_, user32_.f_role as f10_70_27_, user32_.f_role1 as f11_70_27_, user32_.f_role2 as f12_70_27_, user32_.f_role3 as f13_70_27_, user32_.f_role4 as f14_70_27_, user32_.f_stopReason as f15_70_27_, user32_.f_updateDate as f16_70_27_, user32_.f_updateName as f17_70_27_, user32_.f_useState as f18_70_27_, institutio33_.id as id42_28_, institutio33_.f_code as f2_42_28_, institutio33_.f_content as f3_42_28_, institutio33_.f_createDate as f4_42_28_, institutio33_.f_createUser_id as f10_42_28_, institutio33_.f_enabled as f5_42_28_, institutio33_.f_inslevel as f6_42_28_, institutio33_.f_name as f7_42_28_, institutio33_.f_commonFiled_id as f11_42_28_, institutio33_.f_sort as f8_42_28_, institutio33_.f_type as f9_42_28_, user34_.id as id70_29_, user34_.f_account as f2_70_29_, user34_.f_createDate as f3_70_29_, user34_.f_createRole as f4_70_29_, user34_.f_createrName as f5_70_29_, user34_.f_enabled as f6_70_29_, user34_.f_institution_id as f19_70_29_, user34_.f_name as f7_70_29_, user34_.f_password as f8_70_29_, user34_.f_rights as f9_70_29_, user34_.f_role as f10_70_29_, user34_.f_role1 as f11_70_29_, user34_.f_role2 as f12_70_29_, user34_.f_role3 as f13_70_29_, user34_.f_role4 as f14_70_29_, user34_.f_stopReason as f15_70_29_, user34_.f_updateDate as f16_70_29_, user34_.f_updateName as f17_70_29_, user34_.f_useSt
ate as f18_70_29_, ispublishe35_.id as id8_30_, ispublishe35_.batchName as batchName8_30_, ispublishe35_.examadmitplan_id as examadmi6_8_30_, ispublishe35_.isPublish as isPublish8_30_, ispublishe35_.updateDate as updateDate8_30_, ispublishe35_.updateUser as updateUser8_30_, servantuse36_.id as id98_31_, servantuse36_.f_account as f2_98_31_, servantuse36_.f_address as f3_98_31_, servantuse36_.f_applyAddress as f4_98_31_, servantuse36_.f_area as f5_98_31_, servantuse36_.f_birthday as f6_98_31_, servantuse36_.f_cardCode as f7_98_31_, servantuse36_.f_educationalLevel as f8_98_31_, servantuse36_.f_englishLevel as f9_98_31_, servantuse36_.examerIdentity as examerI10_98_31_, servantuse36_.f_examineSource as f11_98_31_, servantuse36_.f_f1 as f12_98_31_, servantuse36_.f_f2 as f13_98_31_, servantuse36_.f_f3 as f14_98_31_, servantuse36_.f_f4 as f15_98_31_, servantuse36_.f_f5 as f16_98_31_, servantuse36_.f_f6 as f17_98_31_, servantuse36_.f_f7 as f18_98_31_, servantuse36_.f_graduationDate as f19_98_31_, servantuse36_.f_idCard as f20_98_31_, servantuse36_.f_isSpecialExamineePost as f21_98_31_, servantuse36_.lastClickTime as lastCli22_98_31_, servantuse36_.f_marriageState as f23_98_31_, servantuse36_.f_moblePhone as f24_98_31_, servantuse36_.f_name as f25_98_31_, servantuse36_.f_nation as f26_98_31_, servantuse36_.f_nationality as f27_98_31_, servantuse36_.f_password as f28_98_31_, servantuse36_.f_personalPhoto as f29_98_31_, servantuse36_.f_phone as f30_
98_31_, servantuse36_.f_politicsStatus as f31_98_31_, servantuse36_.f_post as f32_98_31_, servantuse36_.f_postbox as f33_98_31_, servantuse36_.f_profession as f34_98_31_, servantuse36_.f_professionLevel as f35_98_31_, servantuse36_.f_registeredResidence as f36_98_31_, servantuse36_.f_remark as f37_98_31_, servantuse36_.f_resume as f38_98_31_, servantuse36_.f_school as f39_98_31_, servantuse36_.f_schoolRecord as f40_98_31_, servantuse36_.f_servantApplyInfo_id as f51_98_31_, servantuse36_.f_sex as f41_98_31_, servantuse36_.f_specializedField as f42_98_31_, servantuse36_.f_studentOriginBased as f43_98_31_, servantuse36_.f_technicaTitles as f44_98_31_, servantuse36_.f_unit as f45_98_31_, servantuse36_.f_unitNature as f46_98_31_, servantuse36_.f_userId as f47_98_31_, servantuse36_.f_workDate as f48_98_31_, servantuse36_.workPost as workPost98_31_, servantuse36_.f_workYear as f50_98_31_, kinrelatio37_.f_servantUserInfo_id as f7_44_, kinrelatio37_.id as id44_, kinrelatio37_.id as id40_32_, kinrelatio37_.f_name as f2_40_32_, kinrelatio37_.f_post as f3_40_32_, kinrelatio37_.f_regristeUser_id as f6_40_32_, kinrelatio37_.f_relation as f4_40_32_, kinrelatio37_.f_servantUserInfo_id as f7_40_32_, kinrelatio37_.f_unit as f5_40_32_, regristeus38_.id as id107_33_, regristeus38_.f_account as f2_107_33_, regristeus38_.f_address as f3_107_33_, regristeus38_.f_applyAddress as f4_107_33_, regristeus38_.f_area as f5_107_33_, regristeus38_.f_birthday as f6_107_33_
, regristeus38_.f_educationalLevel as f7_107_33_, regristeus38_.f_email as f8_107_33_, regristeus38_.f_englishLevel as f9_107_33_, regristeus38_.f_examineeFile as f10_107_33_, regristeus38_.f_graduationDate as f11_107_33_, regristeus38_.f_idCard as f12_107_33_, regristeus38_.f_loginDate as f13_107_33_, regristeus38_.f_marriageState as f14_107_33_, regristeus38_.f_moblePhone as f15_107_33_, regristeus38_.f_name as f16_107_33_, regristeus38_.f_nationality as f17_107_33_, regristeus38_.f_password as f18_107_33_, regristeus38_.f_personalPhoto as f19_107_33_, regristeus38_.f_phone as f20_107_33_, regristeus38_.f_politicsStatus as f21_107_33_, regristeus38_.f_post as f22_107_33_, regristeus38_.f_postStuation as f23_107_33_, regristeus38_.f_postbox as f24_107_33_, regristeus38_.f_profession as f25_107_33_, regristeus38_.f_registeredResidence as f26_107_33_, regristeus38_.f_regristDate as f27_107_33_, regristeus38_.f_remark as f28_107_33_, regristeus38_.f_resume as f29_107_33_, regristeus38_.f_school as f30_107_33_, regristeus38_.f_schoolRecord as f31_107_33_, regristeus38_.f_sex as f32_107_33_, regristeus38_.f_source as f33_107_33_, regristeus38_.f_specializedField as f34_107_33_, regristeus38_.f_technicaTitles as f35_107_33_, regristeus38_.f_unit as f36_107_33_, regristeus38_.f_unitNature as f37_107_33_, regristeus38_.f_useState as f38_107_33_, regristeus38_.f_workDate as f39_107_33_, regristeus38_.f_workYear as f40_107_33_ from servantApplyInfos s
ervantapp0_ left outer join examAdmitPlan examadmitp1_ on servantapp0_.f_examAdmitPlan_id=examadmitp1_.id left outer join institution institutio2_ on examadmitp1_.f_admitUnit_id=institutio2_.id left outer join users user3_ on institutio2_.f_createUser_id=user3_.id left outer join institution institutio4_ on user3_.f_institution_id=institutio4_.id left outer join include_grade_unit includegra5_ on institutio4_.id=includegra5_.unitid left outer join include_grade_set includegra6_ on includegra5_.includeid=includegra6_.id left outer join common_filed commonfile7_ on institutio4_.f_commonFiled_id=commonfile7_.id left outer join users user8_ on commonfile7_.f_user_id=user8_.id left outer join specializedField_auditer specialize9_ on user8_.id=specialize9_.userid left outer join exam_specializedField examspecia10_ on specialize9_.specializedField=examspecia10_.id left outer join exam_level examlevel11_ on examspecia10_.f_examLevel_id=examlevel11_.id left outer join exams exam12_ on examlevel11_.f_exam_id=exam12_.id left outer join discount_payment discountpa13_ on exam12_.id=discountpa13_.f_exam_id left outer join exam_subject examsubjec14_ on examspecia10_.id=examsubjec14_.f_exam_id left outer join adminssion_card admissionc15_ on examsubjec14_.f_admissionCard_id=admissionc15_.id left outer join applyInfo_exsubject applyinfos16_ on examsubjec14_.id=applyinfos16_.subjectid left outer join apply_info applyinfo17_ on applyinfos16_.applyId=applyinfo17_.id left outer join users user18_
on applyinfo17_.f_auditer_id=user18_.id left outer join exams exam19_ on applyinfo17_.f_exam_id=exam19_.id left outer join exam_level examlevel20_ on applyinfo17_.f_examLevel_id=examlevel20_.id left outer join exam_specializedField examspecia21_ on applyinfo17_.f_examSpecializedField_id=examspecia21_.id left outer join users user22_ on applyinfo17_.f_gatheringUser_id=user22_.id left outer join user_apply_info regristuse23_ on applyinfo17_.id=regristuse23_.f_applyInfo_id left outer join BonusPoint_unit writeachie24_ on institutio4_.id=writeachie24_.unitid left outer join write_Achie_BPoint writeachie25_ on writeachie24_.waid=writeachie25_.id left outer join write_Achie_BPoint_condition condtions26_ on writeachie25_.id=condtions26_.f_writeAchievementBonusPoint left outer join batchSet batchset27_ on examadmitp1_.f_batchSet_id=batchset27_.id left outer join category_charge categorych28_ on batchset27_.id=categorych28_.f_batchSet_id left outer join batchSet_log logs29_ on batchset27_.id=logs29_.f_batchSet_id left outer join PayCheckQuartz paycheckqu30_ on batchset27_.id=paycheckqu30_.f_batchSetname left outer join category_subject categorysu31_ on examadmitp1_.f_categorySubject_id=categorysu31_.id left outer join users user32_ on categorysu31_.f_user_id=user32_.id left outer join institution institutio33_ on examadmitp1_.f_reportUnit_id=institutio33_.id left outer join users user34_ on examadmitp1_.f_user_id=user34_.id left outer join IsPublishExamAdmitPlan ispublishe35_ on exam
admitp1_.id=ispublishe35_.examadmitplan_id left outer join servantUserInfos servantuse36_ on servantapp0_.id=servantuse36_.f_servantApplyInfo_id left outer join kinRelations kinrelatio37_ on servantuse36_.id=kinrelatio37_.f_servantUserInfo_id left outer join regrist_user regristeus38_ on kinrelatio37_.f_regristeUser_id=regristeus38_.id where servantapp0_.id=:1 order by examsubjec14_.id ASC |
| 6pt45z49qjxyj |
select servantuse0_.id as id102_34_, servantuse0_.f_account as f2_102_34_, servantuse0_.f_address as f3_102_34_, servantuse0_.f_applyAddress as f4_102_34_, servantuse0_.f_area as f5_102_34_, servantuse0_.f_birthday as f6_102_34_, servantuse0_.f_cardCode as f7_102_34_, servantuse0_.f_educationalLevel as f8_102_34_, servantuse0_.f_englishLevel as f9_102_34_, servantuse0_.examerIdentity as examerI10_102_34_, servantuse0_.f_examineSource as f11_102_34_, servantuse0_.f_f1 as f12_102_34_, servantuse0_.f_f2 as f13_102_34_, servantuse0_.f_f3 as f14_102_34_, servantuse0_.f_f4 as f15_102_34_, servantuse0_.f_f5 as f16_102_34_, servantuse0_.f_f6 as f17_102_34_, servantuse0_.f_f7 as f18_102_34_, servantuse0_.f_graduationDate as f19_102_34_, servantuse0_.f_idCard as f20_102_34_, servantuse0_.f_isSpecialExamineePost as f21_102_34_, servantuse0_.lastClickTime as lastCli22_102_34_, servantuse0_.f_marriageState as f23_102_34_, servantuse0_.f_moblePhone as f24_102_34_, servantuse0_.f_name as f25_102_34_, servantuse0_.f_nation as f26_102_34_, servantuse0_.f_nationality as f27_102_34_, servantuse0_.f_password as f28_102_34_, servantuse0_.f_personalPhoto as f29_102_34_, servantuse0_.f_phone as f30_102_34_, servantuse0_.f_politicsStatus as f31_102_34_, servantuse0_.f_post as f32_102_34_, servantuse0_.f_postbox as f33_102_34_, servantuse0_.f_profession as f34_102_34_, servantuse0_.f_professionLevel as f35_102_34_, servantuse0_.f_registeredResidence as f36_102_34_,
servantuse0_.f_remark as f37_102_34_, servantuse0_.f_resume as f38_102_34_, servantuse0_.f_school as f39_102_34_, servantuse0_.f_schoolRecord as f40_102_34_, servantuse0_.f_servantApplyInfo_id as f51_102_34_, servantuse0_.f_sex as f41_102_34_, servantuse0_.f_specializedField as f42_102_34_, servantuse0_.f_studentOriginBased as f43_102_34_, servantuse0_.f_technicaTitles as f44_102_34_, servantuse0_.f_unit as f45_102_34_, servantuse0_.f_unitNature as f46_102_34_, servantuse0_.f_userId as f47_102_34_, servantuse0_.f_workDate as f48_102_34_, servantuse0_.workPost as workPost102_34_, servantuse0_.f_workYear as f50_102_34_, kinrelatio1_.f_servantUserInfo_id as f7_36_, kinrelatio1_.id as id36_, kinrelatio1_.id as id91_0_, kinrelatio1_.f_name as f2_91_0_, kinrelatio1_.f_post as f3_91_0_, kinrelatio1_.f_regristeUser_id as f6_91_0_, kinrelatio1_.f_relation as f4_91_0_, kinrelatio1_.f_servantUserInfo_id as f7_91_0_, kinrelatio1_.f_unit as f5_91_0_, regristeus2_.id as id81_1_, regristeus2_.f_account as f2_81_1_, regristeus2_.f_address as f3_81_1_, regristeus2_.f_applyAddress as f4_81_1_, regristeus2_.f_area as f5_81_1_, regristeus2_.f_birthday as f6_81_1_, regristeus2_.f_educationalLevel as f7_81_1_, regristeus2_.f_email as f8_81_1_, regristeus2_.f_englishLevel as f9_81_1_, regristeus2_.f_examineeFile as f10_81_1_, regristeus2_.f_graduationDate as f11_81_1_, regristeus2_.f_idCard as f12_81_1_, regristeus2_.f_loginDate as f13_81_1_, regristeus2_.f_mar
riageState as f14_81_1_, regristeus2_.f_moblePhone as f15_81_1_, regristeus2_.f_name as f16_81_1_, regristeus2_.f_nationality as f17_81_1_, regristeus2_.f_password as f18_81_1_, regristeus2_.f_personalPhoto as f19_81_1_, regristeus2_.f_phone as f20_81_1_, regristeus2_.f_politicsStatus as f21_81_1_, regristeus2_.f_post as f22_81_1_, regristeus2_.f_postStuation as f23_81_1_, regristeus2_.f_postbox as f24_81_1_, regristeus2_.f_profession as f25_81_1_, regristeus2_.f_registeredResidence as f26_81_1_, regristeus2_.f_regristDate as f27_81_1_, regristeus2_.f_remark as f28_81_1_, regristeus2_.f_resume as f29_81_1_, regristeus2_.f_school as f30_81_1_, regristeus2_.f_schoolRecord as f31_81_1_, regristeus2_.f_sex as f32_81_1_, regristeus2_.f_source as f33_81_1_, regristeus2_.f_specializedField as f34_81_1_, regristeus2_.f_technicaTitles as f35_81_1_, regristeus2_.f_unit as f36_81_1_, regristeus2_.f_unitNature as f37_81_1_, regristeus2_.f_useState as f38_81_1_, regristeus2_.f_workDate as f39_81_1_, regristeus2_.f_workYear as f40_81_1_, servantapp3_.id as id111_2_, servantapp3_.f_applyCode as f2_111_2_, servantapp3_.f_applyDate as f3_111_2_, servantapp3_.f_auditDate as f4_111_2_, servantapp3_.f_examAdmitPlan_id as f13_111_2_, servantapp3_.f_examerStiation as f5_111_2_, servantapp3_.f_paymentState as f6_111_2_, servantapp3_.f_reapply as f7_111_2_, servantapp3_.f_rejectReason as f8_111_2_, servantapp3_.f_revocationDate as f9_111_2_, servantapp3_.f_revoca
tionName as f10_111_2_, servantapp3_.f_revocationReason as f11_111_2_, servantapp3_.f_state as f12_111_2_, examadmitp4_.id as id53_3_, examadmitp4_.f_admitNum as f2_53_3_, examadmitp4_.f_admitUnit_id as f27_53_3_, examadmitp4_.admitUnitName as admitUni3_53_3_, examadmitp4_.f_batchSet_id as f28_53_3_, examadmitp4_.f_batchSetName as f4_53_3_, examadmitp4_.f_categorySubject_id as f29_53_3_, examadmitp4_.examType as examType53_3_, examadmitp4_.hometown as hometown53_3_, examadmitp4_.maxRestrictionAge as maxRestr7_53_3_, examadmitp4_.minRestrictionAge as minRestr8_53_3_, examadmitp4_.f_otherCondition as f9_53_3_, examadmitp4_.f_physicalTest as f10_53_3_, examadmitp4_.f_postId as f11_53_3_, examadmitp4_.f_postName as f12_53_3_, examadmitp4_.f_rejectInfo as f13_53_3_, examadmitp4_.f_remark as f14_53_3_, examadmitp4_.f_repealInfo as f15_53_3_, examadmitp4_.f_reportUnit_id as f30_53_3_, examadmitp4_.reportUnitName as reportU16_53_3_, examadmitp4_.f_requireAge as f17_53_3_, examadmitp4_.f_requireEductionLevel as f18_53_3_, examadmitp4_.f_requireHometown as f19_53_3_, examadmitp4_.f_requireNation as f20_53_3_, examadmitp4_.f_requireSchoolRecord as f21_53_3_, examadmitp4_.f_requireSex as f22_53_3_, examadmitp4_.f_requireSpecialty as f23_53_3_, examadmitp4_.f_state as f24_53_3_, examadmitp4_.f_updateDate as f25_53_3_, examadmitp4_.f_updateInfo as f26_53_3_, examadmitp4_.f_user_id as f31_53_3_, institutio5_.id as id65_4_, institutio5_.f_code as f2_65_4_,
institutio5_.f_content as f3_65_4_, institutio5_.f_createDate as f4_65_4_, institutio5_.f_createUser_id as f10_65_4_, institutio5_.f_enabled as f5_65_4_, institutio5_.f_inslevel as f6_65_4_, institutio5_.f_name as f7_65_4_, institutio5_.f_commonFiled_id as f11_65_4_, institutio5_.f_sort as f8_65_4_, institutio5_.f_type as f9_65_4_, user6_.id as id8_5_, user6_.f_account as f2_8_5_, user6_.f_createDate as f3_8_5_, user6_.f_createRole as f4_8_5_, user6_.f_createrName as f5_8_5_, user6_.f_enabled as f6_8_5_, user6_.f_institution_id as f19_8_5_, user6_.f_name as f7_8_5_, user6_.f_password as f8_8_5_, user6_.f_rights as f9_8_5_, user6_.f_role as f10_8_5_, user6_.f_role1 as f11_8_5_, user6_.f_role2 as f12_8_5_, user6_.f_role3 as f13_8_5_, user6_.f_role4 as f14_8_5_, user6_.f_stopReason as f15_8_5_, user6_.f_updateDate as f16_8_5_, user6_.f_updateName as f17_8_5_, user6_.f_useState as f18_8_5_, institutio7_.id as id65_6_, institutio7_.f_code as f2_65_6_, institutio7_.f_content as f3_65_6_, institutio7_.f_createDate as f4_65_6_, institutio7_.f_createUser_id as f10_65_6_, institutio7_.f_enabled as f5_65_6_, institutio7_.f_inslevel as f6_65_6_, institutio7_.f_name as f7_65_6_, institutio7_.f_commonFiled_id as f11_65_6_, institutio7_.f_sort as f8_65_6_, institutio7_.f_type as f9_65_6_, includegra8_.unitid as unitid37_, includegra9_.id as includeid37_, includegra9_.id as id22_7_, includegra9_.f_adminNum as f2_22_7_, includegra9_.f_batchSetName a
s f3_22_7_, includegra9_.f_grade as f4_22_7_, includegra9_.f_includeCount as f5_22_7_, includegra9_.f_postName as f6_22_7_, includegra9_.f_type as f7_22_7_, includegra9_.f_unitId as f8_22_7_, includegra9_.f_unitName as f9_22_7_, includegra9_.f_unitNature as f10_22_7_, commonfile10_.id as id72_8_, commonfile10_.f_address as f2_72_8_, commonfile10_.f_code as f3_72_8_, commonfile10_.f_name as f4_72_8_, commonfile10_.f_type as f5_72_8_, commonfile10_.f_updateDate as f6_72_8_, commonfile10_.f_user_id as f7_72_8_, user11_.id as id8_9_, user11_.f_account as f2_8_9_, user11_.f_createDate as f3_8_9_, user11_.f_createRole as f4_8_9_, user11_.f_createrName as f5_8_9_, user11_.f_enabled as f6_8_9_, user11_.f_institution_id as f19_8_9_, user11_.f_name as f7_8_9_, user11_.f_password as f8_8_9_, user11_.f_rights as f9_8_9_, user11_.f_role as f10_8_9_, user11_.f_role1 as f11_8_9_, user11_.f_role2 as f12_8_9_, user11_.f_role3 as f13_8_9_, user11_.f_role4 as f14_8_9_, user11_.f_stopReason as f15_8_9_, user11_.f_updateDate as f16_8_9_, user11_.f_updateName as f17_8_9_, user11_.f_useState as f18_8_9_, specialize12_.userid as userid38_, examspecia13_.id as speciali1_38_, examspecia13_.id as id34_10_, examspecia13_.f_audit as f2_34_10_, examspecia13_.f_begin as f3_34_10_, examspecia13_.f_code as f4_34_10_, examspecia13_.f_examLevel_id as f7_34_10_, examspecia13_.f_isApply as f5_34_10_, examspecia13_.f_name as f6_34_10_, examlevel14_.id as id42_11_, examl
evel14_.f_amount as f2_42_11_, examlevel14_.f_code as f3_42_11_, examlevel14_.f_exam_id as f6_42_11_, examlevel14_.f_name as f4_42_11_, examlevel14_.f_scroll as f5_42_11_, exam15_.id as id80_12_, exam15_.f_abbreviation as f2_80_12_, exam15_.f_applyDateEnd as f3_80_12_, exam15_.f_applyDateStart as f4_80_12_, exam15_.f_audit as f5_80_12_, exam15_.f_auditDateEnd as f6_80_12_, exam15_.f_auditDateStart as f7_80_12_, exam15_.f_code as f8_80_12_, exam15_.f_examName as f9_80_12_, exam15_.f_examYear as f10_80_12_, exam15_.f_notice as f11_80_12_, exam15_.f_operateDate as f12_80_12_, exam15_.f_payMentDateEnd as f13_80_12_, exam15_.f_payMentDateStart as f14_80_12_, exam15_.f_payType as f15_80_12_, exam15_.f_regularAmount as f16_80_12_, exam15_.f_rule as f17_80_12_, exam15_.f_type as f18_80_12_, discountpa16_.id as id92_13_, discountpa16_.f_discountRate as f2_92_13_, discountpa16_.f_discountScroll as f3_92_13_, discountpa16_.f_discountScrollRate as f4_92_13_, discountpa16_.f_discountType as f5_92_13_, discountpa16_.f_exam_id as f11_92_13_, discountpa16_.f_mode as f6_92_13_, discountpa16_.f_modeScrollValue as f7_92_13_, discountpa16_.f_modeValue as f8_92_13_, discountpa16_.f_payMentType as f9_92_13_, discountpa16_.f_scrollPayMentType as f10_92_13_, examsubjec17_.f_exam_id as f11_39_, examsubjec17_.id as id39_, examsubjec17_.id as id73_14_, examsubjec17_.f_admissionCard_id as f10_73_14_, examsubjec17_.f_amount as f2_73_14_, examsubjec17_.code as code73
_14_, examsubjec17_.endTime as endTime73_14_, examsubjec17_.f_exam_id as f11_73_14_, examsubjec17_.examDate as examDate73_14_, examsubjec17_.gatherDate as gatherDate73_14_, examsubjec17_.f_name as f7_73_14_, examsubjec17_.f_score as f8_73_14_, examsubjec17_.startTime as startTime73_14_, admissionc18_.id as id58_15_, admissionc18_.f_cardCode as f2_58_15_, admissionc18_.f_createDate as f3_58_15_, admissionc18_.f_examArea as f4_58_15_, admissionc18_.f_examLevel as f5_58_15_, admissionc18_.f_examLevelCode as f6_58_15_, admissionc18_.f_examName as f7_58_15_, admissionc18_.f_examPlaceCode as f8_58_15_, admissionc18_.f_examPoint as f9_58_15_, admissionc18_.f_examSpecialty as f10_58_15_, admissionc18_.f_examSpecialtyCode as f11_58_15_, admissionc18_.f_examSubject as f12_58_15_, admissionc18_.f_examSubjectCode as f13_58_15_, admissionc18_.f_examYear as f14_58_15_, admissionc18_.f_idCard as f15_58_15_, admissionc18_.f_seatCode as f16_58_15_, admissionc18_.f_userName as f17_58_15_, applyinfos19_.subjectid as subjectid40_, applyinfo20_.id as applyId40_, applyinfo20_.id as id25_16_, applyinfo20_.f_applyCode as f2_25_16_, applyinfo20_.f_applyDate as f3_25_16_, applyinfo20_.f_applyMode as f4_25_16_, applyinfo20_.f_applySerial as f5_25_16_, applyinfo20_.f_auditDate as f6_25_16_, applyinfo20_.f_auditName as f7_25_16_, applyinfo20_.f_auditRevocationDate as f8_25_16_, applyinfo20_.f_auditer_id as f20_25_16_, applyinfo20_.f_confirm as f9_25_16_, applyinfo20_.
f_exam_id as f21_25_16_, applyinfo20_.f_examLevel_id as f22_25_16_, applyinfo20_.f_examSpecializedField_id as f23_25_16_, applyinfo20_.f_gatheringDate as f10_25_16_, applyinfo20_.f_gatheringUser_id as f24_25_16_, applyinfo20_.f_paymentAmount as f11_25_16_, applyinfo20_.f_paymentComeSerial as f12_25_16_, applyinfo20_.f_paymentDate as f13_25_16_, applyinfo20_.f_paymentMode as f14_25_16_, applyinfo20_.f_paymentOrderCode as f15_25_16_, applyinfo20_.f_rejectDate as f16_25_16_, applyinfo20_.f_rejectReason as f17_25_16_, applyinfo20_.f_state as f18_25_16_, applyinfo20_.f_stauts as f19_25_16_, user21_.id as id8_17_, user21_.f_account as f2_8_17_, user21_.f_createDate as f3_8_17_, user21_.f_createRole as f4_8_17_, user21_.f_createrName as f5_8_17_, user21_.f_enabled as f6_8_17_, user21_.f_institution_id as f19_8_17_, user21_.f_name as f7_8_17_, user21_.f_password as f8_8_17_, user21_.f_rights as f9_8_17_, user21_.f_role as f10_8_17_, user21_.f_role1 as f11_8_17_, user21_.f_role2 as f12_8_17_, user21_.f_role3 as f13_8_17_, user21_.f_role4 as f14_8_17_, user21_.f_stopReason as f15_8_17_, user21_.f_updateDate as f16_8_17_, user21_.f_updateName as f17_8_17_, user21_.f_useState as f18_8_17_, exam22_.id as id80_18_, exam22_.f_abbreviation as f2_80_18_, exam22_.f_applyDateEnd as f3_80_18_, exam22_.f_applyDateStart as f4_80_18_, exam22_.f_audit as f5_80_18_, exam22_.f_auditDateEnd as f6_80_18_, exam22_.f_auditDateStart as f7_80_18_, exam22_.f_code as f8
_80_18_, exam22_.f_examName as f9_80_18_, exam22_.f_examYear as f10_80_18_, exam22_.f_notice as f11_80_18_, exam22_.f_operateDate as f12_80_18_, exam22_.f_payMentDateEnd as f13_80_18_, exam22_.f_payMentDateStart as f14_80_18_, exam22_.f_payType as f15_80_18_, exam22_.f_regularAmount as f16_80_18_, exam22_.f_rule as f17_80_18_, exam22_.f_type as f18_80_18_, examlevel23_.id as id42_19_, examlevel23_.f_amount as f2_42_19_, examlevel23_.f_code as f3_42_19_, examlevel23_.f_exam_id as f6_42_19_, examlevel23_.f_name as f4_42_19_, examlevel23_.f_scroll as f5_42_19_, examspecia24_.id as id34_20_, examspecia24_.f_audit as f2_34_20_, examspecia24_.f_begin as f3_34_20_, examspecia24_.f_code as f4_34_20_, examspecia24_.f_examLevel_id as f7_34_20_, examspecia24_.f_isApply as f5_34_20_, examspecia24_.f_name as f6_34_20_, user25_.id as id8_21_, user25_.f_account as f2_8_21_, user25_.f_createDate as f3_8_21_, user25_.f_createRole as f4_8_21_, user25_.f_createrName as f5_8_21_, user25_.f_enabled as f6_8_21_, user25_.f_institution_id as f19_8_21_, user25_.f_name as f7_8_21_, user25_.f_password as f8_8_21_, user25_.f_rights as f9_8_21_, user25_.f_role as f10_8_21_, user25_.f_role1 as f11_8_21_, user25_.f_role2 as f12_8_21_, user25_.f_role3 as f13_8_21_, user25_.f_role4 as f14_8_21_, user25_.f_stopReason as f15_8_21_, user25_.f_updateDate as f16_8_21_, user25_.f_updateName as f17_8_21_, user25_.f_useState as f18_8_21_, regristuse26_.id as id82_22_, regr
istuse26_.f_account as f2_82_22_, regristuse26_.f_address as f3_82_22_, regristuse26_.f_applyAddress as f4_82_22_, regristuse26_.f_applyInfo_id as f37_82_22_, regristuse26_.f_area as f5_82_22_, regristuse26_.f_birthday as f6_82_22_, regristuse26_.f_educationalLevel as f7_82_22_, regristuse26_.f_englishLevel as f8_82_22_, regristuse26_.f_examineeFile as f9_82_22_, regristuse26_.f_graduationDate as f10_82_22_, regristuse26_.f_idCard as f11_82_22_, regristuse26_.f_marriageState as f12_82_22_, regristuse26_.f_moblePhone as f13_82_22_, regristuse26_.f_name as f14_82_22_, regristuse26_.f_nationality as f15_82_22_, regristuse26_.f_password as f16_82_22_, regristuse26_.f_personalPhoto as f17_82_22_, regristuse26_.f_phone as f18_82_22_, regristuse26_.f_politicsStatus as f19_82_22_, regristuse26_.f_post as f20_82_22_, regristuse26_.f_postStuation as f21_82_22_, regristuse26_.f_postbox as f22_82_22_, regristuse26_.f_profession as f23_82_22_, regristuse26_.f_professionLevel as f24_82_22_, regristuse26_.f_registeredResidence as f25_82_22_, regristuse26_.f_school as f26_82_22_, regristuse26_.f_schoolRecord as f27_82_22_, regristuse26_.f_sex as f28_82_22_, regristuse26_.f_source as f29_82_22_, regristuse26_.f_specializedField as f30_82_22_, regristuse26_.f_technicaTitles as f31_82_22_, regristuse26_.f_unit as f32_82_22_, regristuse26_.f_unitNature as f33_82_22_, regristuse26_.f_userId as f34_82_22_, regristuse26_.f_workDate as f35_82_22_, regristuse26_.f_w
orkYear as f36_82_22_, writeachie27_.unitid as unitid41_, writeachie28_.id as waid41_, writeachie28_.id as id69_23_, writeachie28_.f_batchSetName as f2_69_23_, writeachie28_.f_policy as f3_69_23_, writeachie28_.f_scale as f4_69_23_, writeachie28_.suitType as suitType69_23_, condtions29_.f_writeAchievementBonusPoint as f7_42_, condtions29_.id as id42_, condtions29_.id as id57_24_, condtions29_.f_batchName as f2_57_24_, condtions29_.f_condtion as f3_57_24_, condtions29_.f_relation as f4_57_24_, condtions29_.f_scale as f5_57_24_, condtions29_.f_value as f6_57_24_, condtions29_.f_writeAchievementBonusPoint as f7_57_24_, batchset30_.id as id26_25_, batchset30_.f_applyEndDate as f2_26_25_, batchset30_.f_applyStartDate as f3_26_25_, batchset30_.f_cardCode as f4_26_25_, batchset30_.f_cardNotice as f5_26_25_, batchset30_.f_chargeType as f6_26_25_, batchset30_.f_examDate as f7_26_25_, batchset30_.f_musterName as f8_26_25_, batchset30_.f_name as f9_26_25_, batchset30_.f_paymentEndDate as f10_26_25_, batchset30_.f_paymentStartDate as f11_26_25_, batchset30_.f_publicApplyCount as f12_26_25_, batchset30_.f_publicAuditCount as f13_26_25_, batchset30_.f_publicPaymentCount as f14_26_25_, batchset30_.f_state as f15_26_25_, batchset30_.f_studentNotice as f16_26_25_, batchset30_.f_tableName as f17_26_25_, batchset30_.f_timelagDate as f18_26_25_, batchset30_.f_type as f19_26_25_, batchset30_.f_unitePrice as f20_26_25_, batchset30_.f_updateDate as f21_26_25_,
batchset30_.f_updateName as f22_26_25_, categorych31_.f_batchSet_id as f4_43_, categorych31_.id as id43_, categorych31_.id as id43_26_, categorych31_.f_amount as f2_43_26_, categorych31_.f_batchSet_id as f4_43_26_, categorych31_.f_name as f3_43_26_, logs32_.f_batchSet_id as f4_44_, logs32_.id as id44_, logs32_.id as id95_27_, logs32_.f_batchSet_id as f4_95_27_, logs32_.f_operatorDate as f2_95_27_, logs32_.f_userName as f3_95_27_, paycheckqu33_.id as id2_28_, paycheckqu33_.f_batchSetname as f3_2_28_, paycheckqu33_.state as state2_28_, categorysu34_.id as id101_29_, categorysu34_.f_name as f2_101_29_, categorysu34_.f_summary as f3_101_29_, categorysu34_.f_type as f4_101_29_, categorysu34_.f_typeCode as f5_101_29_, categorysu34_.f_typename as f6_101_29_, categorysu34_.f_updateDate as f7_101_29_, categorysu34_.f_user_id as f8_101_29_, user35_.id as id8_30_, user35_.f_account as f2_8_30_, user35_.f_createDate as f3_8_30_, user35_.f_createRole as f4_8_30_, user35_.f_createrName as f5_8_30_, user35_.f_enabled as f6_8_30_, user35_.f_institution_id as f19_8_30_, user35_.f_name as f7_8_30_, user35_.f_password as f8_8_30_, user35_.f_rights as f9_8_30_, user35_.f_role as f10_8_30_, user35_.f_role1 as f11_8_30_, user35_.f_role2 as f12_8_30_, user35_.f_role3 as f13_8_30_, user35_.f_role4 as f14_8_30_, user35_.f_stopReason as f15_8_30_, user35_.f_updateDate as f16_8_30_, user35_.f_updateName as f17_8_30_, user35_.f_useState as f18_8_30_, institutio
36_.id as id65_31_, institutio36_.f_code as f2_65_31_, institutio36_.f_content as f3_65_31_, institutio36_.f_createDate as f4_65_31_, institutio36_.f_createUser_id as f10_65_31_, institutio36_.f_enabled as f5_65_31_, institutio36_.f_inslevel as f6_65_31_, institutio36_.f_name as f7_65_31_, institutio36_.f_commonFiled_id as f11_65_31_, institutio36_.f_sort as f8_65_31_, institutio36_.f_type as f9_65_31_, user37_.id as id8_32_, user37_.f_account as f2_8_32_, user37_.f_createDate as f3_8_32_, user37_.f_createRole as f4_8_32_, user37_.f_createrName as f5_8_32_, user37_.f_enabled as f6_8_32_, user37_.f_institution_id as f19_8_32_, user37_.f_name as f7_8_32_, user37_.f_password as f8_8_32_, user37_.f_rights as f9_8_32_, user37_.f_role as f10_8_32_, user37_.f_role1 as f11_8_32_, user37_.f_role2 as f12_8_32_, user37_.f_role3 as f13_8_32_, user37_.f_role4 as f14_8_32_, user37_.f_stopReason as f15_8_32_, user37_.f_updateDate as f16_8_32_, user37_.f_updateName as f17_8_32_, user37_.f_useState as f18_8_32_, ispublishe38_.id as id33_33_, ispublishe38_.batchName as batchName33_33_, ispublishe38_.examadmitplan_id as examadmi6_33_33_, ispublishe38_.isPublish as isPublish33_33_, ispublishe38_.updateDate as updateDate33_33_, ispublishe38_.updateUser as updateUser33_33_ from servantUserInfos servantuse0_ left outer join kinRelations kinrelatio1_ on servantuse0_.id=kinrelatio1_.f_servantUserInfo_id left outer join regrist_user regristeus2_ on kinrelatio1_.f_reg
risteUser_id=regristeus2_.id left outer join servantApplyInfos servantapp3_ on servantuse0_.f_servantApplyInfo_id=servantapp3_.id left outer join examAdmitPlan examadmitp4_ on servantapp3_.f_examAdmitPlan_id=examadmitp4_.id left outer join institution institutio5_ on examadmitp4_.f_admitUnit_id=institutio5_.id left outer join users user6_ on institutio5_.f_createUser_id=user6_.id left outer join institution institutio7_ on user6_.f_institution_id=institutio7_.id left outer join include_grade_unit includegra8_ on institutio7_.id=includegra8_.unitid left outer join include_grade_set includegra9_ on includegra8_.includeid=includegra9_.id left outer join common_filed commonfile10_ on institutio7_.f_commonFiled_id=commonfile10_.id left outer join users user11_ on commonfile10_.f_user_id=user11_.id left outer join specializedField_auditer specialize12_ on user11_.id=specialize12_.userid left outer join exam_specializedField examspecia13_ on specialize12_.specializedField=examspecia13_.id left outer join exam_level examlevel14_ on examspecia13_.f_examLevel_id=examlevel14_.id left outer join exams exam15_ on examlevel14_.f_exam_id=exam15_.id left outer join discount_payment discountpa16_ on exam15_.id=discountpa16_.f_exam_id left outer join exam_subject examsubjec17_ on examspecia13_.id=examsubjec17_.f_exam_id left outer join adminssion_card admissionc18_ on examsubjec17_.f_admissionCard_id=admissionc18_.id left outer join applyInfo_exsubject applyinfos19_ on examsubjec17_.id=applyin
fos19_.subjectid left outer join apply_info applyinfo20_ on applyinfos19_.applyId=applyinfo20_.id left outer join users user21_ on applyinfo20_.f_auditer_id=user21_.id left outer join exams exam22_ on applyinfo20_.f_exam_id=exam22_.id left outer join exam_level examlevel23_ on applyinfo20_.f_examLevel_id=examlevel23_.id left outer join exam_specializedField examspecia24_ on applyinfo20_.f_examSpecializedField_id=examspecia24_.id left outer join users user25_ on applyinfo20_.f_gatheringUser_id=user25_.id left outer join user_apply_info regristuse26_ on applyinfo20_.id=regristuse26_.f_applyInfo_id left outer join BonusPoint_unit writeachie27_ on institutio7_.id=writeachie27_.unitid left outer join write_Achie_BPoint writeachie28_ on writeachie27_.waid=writeachie28_.id left outer join write_Achie_BPoint_condition condtions29_ on writeachie28_.id=condtions29_.f_writeAchievementBonusPoint left outer join batchSet batchset30_ on examadmitp4_.f_batchSet_id=batchset30_.id left outer join category_charge categorych31_ on batchset30_.id=categorych31_.f_batchSet_id left outer join batchSet_log logs32_ on batchset30_.id=logs32_.f_batchSet_id left outer join PayCheckQuartz paycheckqu33_ on batchset30_.id=paycheckqu33_.f_batchSetname left outer join category_subject categorysu34_ on examadmitp4_.f_categorySubject_id=categorysu34_.id left outer join users user35_ on categorysu34_.f_user_id=user35_.id left outer join institution institutio36_ on examadmitp4_.f_reportUnit_id=institutio36_.id
left outer join users user37_ on examadmitp4_.f_user_id=user37_.id left outer join IsPublishExamAdmitPlan ispublishe38_ on examadmitp4_.id=ispublishe38_.examadmitplan_id where servantuse0_.f_servantApplyInfo_id=:1 order by examsubjec17_.id ASC |
| 6uw5a9a2cgk2u | select * from ( select count(examadmitp0_.id) as col_0_0_ from examAdmitPlan examadmitp0_ where examadmitp0_.f_batchSet_id=425984 and examadmitp0_.f_state=3 ) where rownum <= :1 |
| 8prwydvtc1993 | update infos set f_ahthor=:1, f_auditDate=:2, f_auditUser_id=:3, f_content=:4, f_createDate=:5, f_createUser_id=:6, f_f1=:7, f_f2=:8, f_f3=:9, f_f4=:10, f_f5=:11, f_f6=:12, f_keyWord=:13, f_operator=:14, f_operatorDate=:15, f_path=:16, f_recommand=:17, f_recommandImage=:18, f_rejectReason=:19, f_state=:20, f_subtitle=:21, f_title=:22, f_updateDate=:23, f_updateUser_id=:24, f_viewCount=:25 where id=:26 |
| 9ph54u7896z03 |
select specialize0_.userid as userid4_, specialize0_.specializedField as speciali2_4_, examspecia1_.id as id59_0_, examspecia1_.f_audit as f2_59_0_, examspecia1_.f_begin as f3_59_0_, examspecia1_.f_code as f4_59_0_, examspecia1_.f_examLevel_id as f7_59_0_, examspecia1_.f_isApply as f5_59_0_, examspecia1_.f_name as f6_59_0_, examlevel2_.id as id33_1_, examlevel2_.f_amount as f2_33_1_, examlevel2_.f_code as f3_33_1_, examlevel2_.f_exam_id as f6_33_1_, examlevel2_.f_name as f4_33_1_, examlevel2_.f_scroll as f5_33_1_, exam3_.id as id32_2_, exam3_.f_abbreviation as f2_32_2_, exam3_.f_applyDateEnd as f3_32_2_, exam3_.f_applyDateStart as f4_32_2_, exam3_.f_audit as f5_32_2_, exam3_.f_auditDateEnd as f6_32_2_, exam3_.f_auditDateStart as f7_32_2_, exam3_.f_code as f8_32_2_, exam3_.f_examName as f9_32_2_, exam3_.f_examYear as f10_32_2_, exam3_.f_notice as f11_32_2_, exam3_.f_operateDate as f12_32_2_, exam3_.f_payMentDateEnd as f13_32_2_, exam3_.f_payMentDateStart as f14_32_2_, exam3_.f_payType as f15_32_2_, exam3_.f_regularAmount as f16_32_2_, exam3_.f_rule as f17_32_2_, exam3_.f_type as f18_32_2_, discountpa4_.id as id18_3_, discountpa4_.f_discountRate as f2_18_3_, discountpa4_.f_discountScroll as f3_18_3_, discountpa4_.f_discountScrollRate as f4_18_3_, discountpa4_.f_discountType as f5_18_3_, discountpa4_.f_exam_id as f11_18_3_, discountpa4_.f_mode as f6_18_3_, discountpa4_.f_modeScrollValue as f7_18_3_, discountpa4_.f_modeValue as f8_18_3_,
discountpa4_.f_payMentType as f9_18_3_, discountpa4_.f_scrollPayMentType as f10_18_3_ from specializedField_auditer specialize0_ left outer join exam_specializedField examspecia1_ on specialize0_.specializedField=examspecia1_.id left outer join exam_level examlevel2_ on examspecia1_.f_examLevel_id=examlevel2_.id left outer join exams exam3_ on examlevel2_.f_exam_id=exam3_.id left outer join discount_payment discountpa4_ on exam3_.id=discountpa4_.f_exam_id where specialize0_.userid=:1 |
| a51z8dguk7m7c | select columns0_.infoid as infoid1_, columns0_.columnid as columnid1_, infocolumn1_.id as id6_0_, infocolumn1_.f_audit as f2_6_0_, infocolumn1_.f_createDate as f3_6_0_, infocolumn1_.f_grade as f4_6_0_, infocolumn1_.f_name as f5_6_0_, infocolumn1_.f_parentId as f6_6_0_, infocolumn1_.f_serial as f7_6_0_, infocolumn1_.f_sort as f8_6_0_, infocolumn1_.f_type as f9_6_0_, infocolumn1_.f_upateDate as f10_6_0_, infocolumn1_.f_username as f11_6_0_ from info_column columns0_ left outer join columns infocolumn1_ on columns0_.columnid=infocolumn1_.id where columns0_.infoid=:1 |
| ab3swhv5g138y |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| abn8sc326g6ga | select * from ( SELECT count(*) from VIEW_EXAMADMITPLAN where f_state<>1 and f_type='1' ) where rownum <= :1 |
| afgw8p2bddgxx |
select servantapp0_.id as id111_34_, servantapp0_.f_applyCode as f2_111_34_, servantapp0_.f_applyDate as f3_111_34_, servantapp0_.f_auditDate as f4_111_34_, servantapp0_.f_examAdmitPlan_id as f13_111_34_, servantapp0_.f_examerStiation as f5_111_34_, servantapp0_.f_paymentState as f6_111_34_, servantapp0_.f_reapply as f7_111_34_, servantapp0_.f_rejectReason as f8_111_34_, servantapp0_.f_revocationDate as f9_111_34_, servantapp0_.f_revocationName as f10_111_34_, servantapp0_.f_revocationReason as f11_111_34_, servantapp0_.f_state as f12_111_34_, examadmitp1_.id as id53_0_, examadmitp1_.f_admitNum as f2_53_0_, examadmitp1_.f_admitUnit_id as f27_53_0_, examadmitp1_.admitUnitName as admitUni3_53_0_, examadmitp1_.f_batchSet_id as f28_53_0_, examadmitp1_.f_batchSetName as f4_53_0_, examadmitp1_.f_categorySubject_id as f29_53_0_, examadmitp1_.examType as examType53_0_, examadmitp1_.hometown as hometown53_0_, examadmitp1_.maxRestrictionAge as maxRestr7_53_0_, examadmitp1_.minRestrictionAge as minRestr8_53_0_, examadmitp1_.f_otherCondition as f9_53_0_, examadmitp1_.f_physicalTest as f10_53_0_, examadmitp1_.f_postId as f11_53_0_, examadmitp1_.f_postName as f12_53_0_, examadmitp1_.f_rejectInfo as f13_53_0_, examadmitp1_.f_remark as f14_53_0_, examadmitp1_.f_repealInfo as f15_53_0_, examadmitp1_.f_reportUnit_id as f30_53_0_, examadmitp1_.reportUnitName as reportU16_53_0_, examadmitp1_.f_requireAge as f17_53_0_, examadmitp1_.f_requireEductionLevel as f18_5
3_0_, examadmitp1_.f_requireHometown as f19_53_0_, examadmitp1_.f_requireNation as f20_53_0_, examadmitp1_.f_requireSchoolRecord as f21_53_0_, examadmitp1_.f_requireSex as f22_53_0_, examadmitp1_.f_requireSpecialty as f23_53_0_, examadmitp1_.f_state as f24_53_0_, examadmitp1_.f_updateDate as f25_53_0_, examadmitp1_.f_updateInfo as f26_53_0_, examadmitp1_.f_user_id as f31_53_0_, institutio2_.id as id65_1_, institutio2_.f_code as f2_65_1_, institutio2_.f_content as f3_65_1_, institutio2_.f_createDate as f4_65_1_, institutio2_.f_createUser_id as f10_65_1_, institutio2_.f_enabled as f5_65_1_, institutio2_.f_inslevel as f6_65_1_, institutio2_.f_name as f7_65_1_, institutio2_.f_commonFiled_id as f11_65_1_, institutio2_.f_sort as f8_65_1_, institutio2_.f_type as f9_65_1_, user3_.id as id8_2_, user3_.f_account as f2_8_2_, user3_.f_createDate as f3_8_2_, user3_.f_createRole as f4_8_2_, user3_.f_createrName as f5_8_2_, user3_.f_enabled as f6_8_2_, user3_.f_institution_id as f19_8_2_, user3_.f_name as f7_8_2_, user3_.f_password as f8_8_2_, user3_.f_rights as f9_8_2_, user3_.f_role as f10_8_2_, user3_.f_role1 as f11_8_2_, user3_.f_role2 as f12_8_2_, user3_.f_role3 as f13_8_2_, user3_.f_role4 as f14_8_2_, user3_.f_stopReason as f15_8_2_, user3_.f_updateDate as f16_8_2_, user3_.f_updateName as f17_8_2_, user3_.f_useState as f18_8_2_, institutio4_.id as id65_3_, institutio4_.f_code as f2_65_3_, institutio4_.f_content as f3_65_3_, institutio4_.f_cre
ateDate as f4_65_3_, institutio4_.f_createUser_id as f10_65_3_, institutio4_.f_enabled as f5_65_3_, institutio4_.f_inslevel as f6_65_3_, institutio4_.f_name as f7_65_3_, institutio4_.f_commonFiled_id as f11_65_3_, institutio4_.f_sort as f8_65_3_, institutio4_.f_type as f9_65_3_, includegra5_.unitid as unitid36_, includegra6_.id as includeid36_, includegra6_.id as id22_4_, includegra6_.f_adminNum as f2_22_4_, includegra6_.f_batchSetName as f3_22_4_, includegra6_.f_grade as f4_22_4_, includegra6_.f_includeCount as f5_22_4_, includegra6_.f_postName as f6_22_4_, includegra6_.f_type as f7_22_4_, includegra6_.f_unitId as f8_22_4_, includegra6_.f_unitName as f9_22_4_, includegra6_.f_unitNature as f10_22_4_, commonfile7_.id as id72_5_, commonfile7_.f_address as f2_72_5_, commonfile7_.f_code as f3_72_5_, commonfile7_.f_name as f4_72_5_, commonfile7_.f_type as f5_72_5_, commonfile7_.f_updateDate as f6_72_5_, commonfile7_.f_user_id as f7_72_5_, user8_.id as id8_6_, user8_.f_account as f2_8_6_, user8_.f_createDate as f3_8_6_, user8_.f_createRole as f4_8_6_, user8_.f_createrName as f5_8_6_, user8_.f_enabled as f6_8_6_, user8_.f_institution_id as f19_8_6_, user8_.f_name as f7_8_6_, user8_.f_password as f8_8_6_, user8_.f_rights as f9_8_6_, user8_.f_role as f10_8_6_, user8_.f_role1 as f11_8_6_, user8_.f_role2 as f12_8_6_, user8_.f_role3 as f13_8_6_, user8_.f_role4 as f14_8_6_, user8_.f_stopReason as f15_8_6_, user8_.f_updateDate as f16_8_6_, user8_
.f_updateName as f17_8_6_, user8_.f_useState as f18_8_6_, specialize9_.userid as userid37_, examspecia10_.id as speciali1_37_, examspecia10_.id as id34_7_, examspecia10_.f_audit as f2_34_7_, examspecia10_.f_begin as f3_34_7_, examspecia10_.f_code as f4_34_7_, examspecia10_.f_examLevel_id as f7_34_7_, examspecia10_.f_isApply as f5_34_7_, examspecia10_.f_name as f6_34_7_, examlevel11_.id as id42_8_, examlevel11_.f_amount as f2_42_8_, examlevel11_.f_code as f3_42_8_, examlevel11_.f_exam_id as f6_42_8_, examlevel11_.f_name as f4_42_8_, examlevel11_.f_scroll as f5_42_8_, exam12_.id as id80_9_, exam12_.f_abbreviation as f2_80_9_, exam12_.f_applyDateEnd as f3_80_9_, exam12_.f_applyDateStart as f4_80_9_, exam12_.f_audit as f5_80_9_, exam12_.f_auditDateEnd as f6_80_9_, exam12_.f_auditDateStart as f7_80_9_, exam12_.f_code as f8_80_9_, exam12_.f_examName as f9_80_9_, exam12_.f_examYear as f10_80_9_, exam12_.f_notice as f11_80_9_, exam12_.f_operateDate as f12_80_9_, exam12_.f_payMentDateEnd as f13_80_9_, exam12_.f_payMentDateStart as f14_80_9_, exam12_.f_payType as f15_80_9_, exam12_.f_regularAmount as f16_80_9_, exam12_.f_rule as f17_80_9_, exam12_.f_type as f18_80_9_, discountpa13_.id as id92_10_, discountpa13_.f_discountRate as f2_92_10_, discountpa13_.f_discountScroll as f3_92_10_, discountpa13_.f_discountScrollRate as f4_92_10_, discountpa13_.f_discountType as f5_92_10_, discountpa13_.f_exam_id as f11_92_10_, discountpa13_.f_mode as f6_92_10_
, discountpa13_.f_modeScrollValue as f7_92_10_, discountpa13_.f_modeValue as f8_92_10_, discountpa13_.f_payMentType as f9_92_10_, discountpa13_.f_scrollPayMentType as f10_92_10_, examsubjec14_.f_exam_id as f11_38_, examsubjec14_.id as id38_, examsubjec14_.id as id73_11_, examsubjec14_.f_admissionCard_id as f10_73_11_, examsubjec14_.f_amount as f2_73_11_, examsubjec14_.code as code73_11_, examsubjec14_.endTime as endTime73_11_, examsubjec14_.f_exam_id as f11_73_11_, examsubjec14_.examDate as examDate73_11_, examsubjec14_.gatherDate as gatherDate73_11_, examsubjec14_.f_name as f7_73_11_, examsubjec14_.f_score as f8_73_11_, examsubjec14_.startTime as startTime73_11_, admissionc15_.id as id58_12_, admissionc15_.f_cardCode as f2_58_12_, admissionc15_.f_createDate as f3_58_12_, admissionc15_.f_examArea as f4_58_12_, admissionc15_.f_examLevel as f5_58_12_, admissionc15_.f_examLevelCode as f6_58_12_, admissionc15_.f_examName as f7_58_12_, admissionc15_.f_examPlaceCode as f8_58_12_, admissionc15_.f_examPoint as f9_58_12_, admissionc15_.f_examSpecialty as f10_58_12_, admissionc15_.f_examSpecialtyCode as f11_58_12_, admissionc15_.f_examSubject as f12_58_12_, admissionc15_.f_examSubjectCode as f13_58_12_, admissionc15_.f_examYear as f14_58_12_, admissionc15_.f_idCard as f15_58_12_, admissionc15_.f_seatCode as f16_58_12_, admissionc15_.f_userName as f17_58_12_, applyinfos16_.subjectid as subjectid39_, applyinfo17_.id as applyId39_, applyinfo17_.id as i
d25_13_, applyinfo17_.f_applyCode as f2_25_13_, applyinfo17_.f_applyDate as f3_25_13_, applyinfo17_.f_applyMode as f4_25_13_, applyinfo17_.f_applySerial as f5_25_13_, applyinfo17_.f_auditDate as f6_25_13_, applyinfo17_.f_auditName as f7_25_13_, applyinfo17_.f_auditRevocationDate as f8_25_13_, applyinfo17_.f_auditer_id as f20_25_13_, applyinfo17_.f_confirm as f9_25_13_, applyinfo17_.f_exam_id as f21_25_13_, applyinfo17_.f_examLevel_id as f22_25_13_, applyinfo17_.f_examSpecializedField_id as f23_25_13_, applyinfo17_.f_gatheringDate as f10_25_13_, applyinfo17_.f_gatheringUser_id as f24_25_13_, applyinfo17_.f_paymentAmount as f11_25_13_, applyinfo17_.f_paymentComeSerial as f12_25_13_, applyinfo17_.f_paymentDate as f13_25_13_, applyinfo17_.f_paymentMode as f14_25_13_, applyinfo17_.f_paymentOrderCode as f15_25_13_, applyinfo17_.f_rejectDate as f16_25_13_, applyinfo17_.f_rejectReason as f17_25_13_, applyinfo17_.f_state as f18_25_13_, applyinfo17_.f_stauts as f19_25_13_, user18_.id as id8_14_, user18_.f_account as f2_8_14_, user18_.f_createDate as f3_8_14_, user18_.f_createRole as f4_8_14_, user18_.f_createrName as f5_8_14_, user18_.f_enabled as f6_8_14_, user18_.f_institution_id as f19_8_14_, user18_.f_name as f7_8_14_, user18_.f_password as f8_8_14_, user18_.f_rights as f9_8_14_, user18_.f_role as f10_8_14_, user18_.f_role1 as f11_8_14_, user18_.f_role2 as f12_8_14_, user18_.f_role3 as f13_8_14_, user18_.f_role4 as f14_8_14_, user18_.f_stopRea
son as f15_8_14_, user18_.f_updateDate as f16_8_14_, user18_.f_updateName as f17_8_14_, user18_.f_useState as f18_8_14_, exam19_.id as id80_15_, exam19_.f_abbreviation as f2_80_15_, exam19_.f_applyDateEnd as f3_80_15_, exam19_.f_applyDateStart as f4_80_15_, exam19_.f_audit as f5_80_15_, exam19_.f_auditDateEnd as f6_80_15_, exam19_.f_auditDateStart as f7_80_15_, exam19_.f_code as f8_80_15_, exam19_.f_examName as f9_80_15_, exam19_.f_examYear as f10_80_15_, exam19_.f_notice as f11_80_15_, exam19_.f_operateDate as f12_80_15_, exam19_.f_payMentDateEnd as f13_80_15_, exam19_.f_payMentDateStart as f14_80_15_, exam19_.f_payType as f15_80_15_, exam19_.f_regularAmount as f16_80_15_, exam19_.f_rule as f17_80_15_, exam19_.f_type as f18_80_15_, examlevel20_.id as id42_16_, examlevel20_.f_amount as f2_42_16_, examlevel20_.f_code as f3_42_16_, examlevel20_.f_exam_id as f6_42_16_, examlevel20_.f_name as f4_42_16_, examlevel20_.f_scroll as f5_42_16_, examspecia21_.id as id34_17_, examspecia21_.f_audit as f2_34_17_, examspecia21_.f_begin as f3_34_17_, examspecia21_.f_code as f4_34_17_, examspecia21_.f_examLevel_id as f7_34_17_, examspecia21_.f_isApply as f5_34_17_, examspecia21_.f_name as f6_34_17_, user22_.id as id8_18_, user22_.f_account as f2_8_18_, user22_.f_createDate as f3_8_18_, user22_.f_createRole as f4_8_18_, user22_.f_createrName as f5_8_18_, user22_.f_enabled as f6_8_18_, user22_.f_institution_id as f19_8_18_, user22_.f_name as f7_8_18_,
user22_.f_password as f8_8_18_, user22_.f_rights as f9_8_18_, user22_.f_role as f10_8_18_, user22_.f_role1 as f11_8_18_, user22_.f_role2 as f12_8_18_, user22_.f_role3 as f13_8_18_, user22_.f_role4 as f14_8_18_, user22_.f_stopReason as f15_8_18_, user22_.f_updateDate as f16_8_18_, user22_.f_updateName as f17_8_18_, user22_.f_useState as f18_8_18_, regristuse23_.id as id82_19_, regristuse23_.f_account as f2_82_19_, regristuse23_.f_address as f3_82_19_, regristuse23_.f_applyAddress as f4_82_19_, regristuse23_.f_applyInfo_id as f37_82_19_, regristuse23_.f_area as f5_82_19_, regristuse23_.f_birthday as f6_82_19_, regristuse23_.f_educationalLevel as f7_82_19_, regristuse23_.f_englishLevel as f8_82_19_, regristuse23_.f_examineeFile as f9_82_19_, regristuse23_.f_graduationDate as f10_82_19_, regristuse23_.f_idCard as f11_82_19_, regristuse23_.f_marriageState as f12_82_19_, regristuse23_.f_moblePhone as f13_82_19_, regristuse23_.f_name as f14_82_19_, regristuse23_.f_nationality as f15_82_19_, regristuse23_.f_password as f16_82_19_, regristuse23_.f_personalPhoto as f17_82_19_, regristuse23_.f_phone as f18_82_19_, regristuse23_.f_politicsStatus as f19_82_19_, regristuse23_.f_post as f20_82_19_, regristuse23_.f_postStuation as f21_82_19_, regristuse23_.f_postbox as f22_82_19_, regristuse23_.f_profession as f23_82_19_, regristuse23_.f_professionLevel as f24_82_19_, regristuse23_.f_registeredResidence as f25_82_19_, regristuse23_.f_school as f26_82_19_,
regristuse23_.f_schoolRecord as f27_82_19_, regristuse23_.f_sex as f28_82_19_, regristuse23_.f_source as f29_82_19_, regristuse23_.f_specializedField as f30_82_19_, regristuse23_.f_technicaTitles as f31_82_19_, regristuse23_.f_unit as f32_82_19_, regristuse23_.f_unitNature as f33_82_19_, regristuse23_.f_userId as f34_82_19_, regristuse23_.f_workDate as f35_82_19_, regristuse23_.f_workYear as f36_82_19_, writeachie24_.unitid as unitid40_, writeachie25_.id as waid40_, writeachie25_.id as id69_20_, writeachie25_.f_batchSetName as f2_69_20_, writeachie25_.f_policy as f3_69_20_, writeachie25_.f_scale as f4_69_20_, writeachie25_.suitType as suitType69_20_, condtions26_.f_writeAchievementBonusPoint as f7_41_, condtions26_.id as id41_, condtions26_.id as id57_21_, condtions26_.f_batchName as f2_57_21_, condtions26_.f_condtion as f3_57_21_, condtions26_.f_relation as f4_57_21_, condtions26_.f_scale as f5_57_21_, condtions26_.f_value as f6_57_21_, condtions26_.f_writeAchievementBonusPoint as f7_57_21_, batchset27_.id as id26_22_, batchset27_.f_applyEndDate as f2_26_22_, batchset27_.f_applyStartDate as f3_26_22_, batchset27_.f_cardCode as f4_26_22_, batchset27_.f_cardNotice as f5_26_22_, batchset27_.f_chargeType as f6_26_22_, batchset27_.f_examDate as f7_26_22_, batchset27_.f_musterName as f8_26_22_, batchset27_.f_name as f9_26_22_, batchset27_.f_paymentEndDate as f10_26_22_, batchset27_.f_paymentStartDate as f11_26_22_, batchset27_.f_publicApplyCo
unt as f12_26_22_, batchset27_.f_publicAuditCount as f13_26_22_, batchset27_.f_publicPaymentCount as f14_26_22_, batchset27_.f_state as f15_26_22_, batchset27_.f_studentNotice as f16_26_22_, batchset27_.f_tableName as f17_26_22_, batchset27_.f_timelagDate as f18_26_22_, batchset27_.f_type as f19_26_22_, batchset27_.f_unitePrice as f20_26_22_, batchset27_.f_updateDate as f21_26_22_, batchset27_.f_updateName as f22_26_22_, categorych28_.f_batchSet_id as f4_42_, categorych28_.id as id42_, categorych28_.id as id43_23_, categorych28_.f_amount as f2_43_23_, categorych28_.f_batchSet_id as f4_43_23_, categorych28_.f_name as f3_43_23_, logs29_.f_batchSet_id as f4_43_, logs29_.id as id43_, logs29_.id as id95_24_, logs29_.f_batchSet_id as f4_95_24_, logs29_.f_operatorDate as f2_95_24_, logs29_.f_userName as f3_95_24_, paycheckqu30_.id as id2_25_, paycheckqu30_.f_batchSetname as f3_2_25_, paycheckqu30_.state as state2_25_, categorysu31_.id as id101_26_, categorysu31_.f_name as f2_101_26_, categorysu31_.f_summary as f3_101_26_, categorysu31_.f_type as f4_101_26_, categorysu31_.f_typeCode as f5_101_26_, categorysu31_.f_typename as f6_101_26_, categorysu31_.f_updateDate as f7_101_26_, categorysu31_.f_user_id as f8_101_26_, user32_.id as id8_27_, user32_.f_account as f2_8_27_, user32_.f_createDate as f3_8_27_, user32_.f_createRole as f4_8_27_, user32_.f_createrName as f5_8_27_, user32_.f_enabled as f6_8_27_, user32_.f_institution_id as f19_8_27_, user
32_.f_name as f7_8_27_, user32_.f_password as f8_8_27_, user32_.f_rights as f9_8_27_, user32_.f_role as f10_8_27_, user32_.f_role1 as f11_8_27_, user32_.f_role2 as f12_8_27_, user32_.f_role3 as f13_8_27_, user32_.f_role4 as f14_8_27_, user32_.f_stopReason as f15_8_27_, user32_.f_updateDate as f16_8_27_, user32_.f_updateName as f17_8_27_, user32_.f_useState as f18_8_27_, institutio33_.id as id65_28_, institutio33_.f_code as f2_65_28_, institutio33_.f_content as f3_65_28_, institutio33_.f_createDate as f4_65_28_, institutio33_.f_createUser_id as f10_65_28_, institutio33_.f_enabled as f5_65_28_, institutio33_.f_inslevel as f6_65_28_, institutio33_.f_name as f7_65_28_, institutio33_.f_commonFiled_id as f11_65_28_, institutio33_.f_sort as f8_65_28_, institutio33_.f_type as f9_65_28_, user34_.id as id8_29_, user34_.f_account as f2_8_29_, user34_.f_createDate as f3_8_29_, user34_.f_createRole as f4_8_29_, user34_.f_createrName as f5_8_29_, user34_.f_enabled as f6_8_29_, user34_.f_institution_id as f19_8_29_, user34_.f_name as f7_8_29_, user34_.f_password as f8_8_29_, user34_.f_rights as f9_8_29_, user34_.f_role as f10_8_29_, user34_.f_role1 as f11_8_29_, user34_.f_role2 as f12_8_29_, user34_.f_role3 as f13_8_29_, user34_.f_role4 as f14_8_29_, user34_.f_stopReason as f15_8_29_, user34_.f_updateDate as f16_8_29_, user34_.f_updateName as f17_8_29_, user34_.f_useState as f18_8_29_, ispublishe35_.id as id33_30_, ispublishe35_.batchName as batchN
ame33_30_, ispublishe35_.examadmitplan_id as examadmi6_33_30_, ispublishe35_.isPublish as isPublish33_30_, ispublishe35_.updateDate as updateDate33_30_, ispublishe35_.updateUser as updateUser33_30_, servantuse36_.id as id102_31_, servantuse36_.f_account as f2_102_31_, servantuse36_.f_address as f3_102_31_, servantuse36_.f_applyAddress as f4_102_31_, servantuse36_.f_area as f5_102_31_, servantuse36_.f_birthday as f6_102_31_, servantuse36_.f_cardCode as f7_102_31_, servantuse36_.f_educationalLevel as f8_102_31_, servantuse36_.f_englishLevel as f9_102_31_, servantuse36_.examerIdentity as examerI10_102_31_, servantuse36_.f_examineSource as f11_102_31_, servantuse36_.f_f1 as f12_102_31_, servantuse36_.f_f2 as f13_102_31_, servantuse36_.f_f3 as f14_102_31_, servantuse36_.f_f4 as f15_102_31_, servantuse36_.f_f5 as f16_102_31_, servantuse36_.f_f6 as f17_102_31_, servantuse36_.f_f7 as f18_102_31_, servantuse36_.f_graduationDate as f19_102_31_, servantuse36_.f_idCard as f20_102_31_, servantuse36_.f_isSpecialExamineePost as f21_102_31_, servantuse36_.lastClickTime as lastCli22_102_31_, servantuse36_.f_marriageState as f23_102_31_, servantuse36_.f_moblePhone as f24_102_31_, servantuse36_.f_name as f25_102_31_, servantuse36_.f_nation as f26_102_31_, servantuse36_.f_nationality as f27_102_31_, servantuse36_.f_password as f28_102_31_, servantuse36_.f_personalPhoto as f29_102_31_, servantuse36_.f_phone as f30_102_31_, servantuse36_.f_politicsStatus as f31_1
02_31_, servantuse36_.f_post as f32_102_31_, servantuse36_.f_postbox as f33_102_31_, servantuse36_.f_profession as f34_102_31_, servantuse36_.f_professionLevel as f35_102_31_, servantuse36_.f_registeredResidence as f36_102_31_, servantuse36_.f_remark as f37_102_31_, servantuse36_.f_resume as f38_102_31_, servantuse36_.f_school as f39_102_31_, servantuse36_.f_schoolRecord as f40_102_31_, servantuse36_.f_servantApplyInfo_id as f51_102_31_, servantuse36_.f_sex as f41_102_31_, servantuse36_.f_specializedField as f42_102_31_, servantuse36_.f_studentOriginBased as f43_102_31_, servantuse36_.f_technicaTitles as f44_102_31_, servantuse36_.f_unit as f45_102_31_, servantuse36_.f_unitNature as f46_102_31_, servantuse36_.f_userId as f47_102_31_, servantuse36_.f_workDate as f48_102_31_, servantuse36_.workPost as workPost102_31_, servantuse36_.f_workYear as f50_102_31_, kinrelatio37_.f_servantUserInfo_id as f7_44_, kinrelatio37_.id as id44_, kinrelatio37_.id as id91_32_, kinrelatio37_.f_name as f2_91_32_, kinrelatio37_.f_post as f3_91_32_, kinrelatio37_.f_regristeUser_id as f6_91_32_, kinrelatio37_.f_relation as f4_91_32_, kinrelatio37_.f_servantUserInfo_id as f7_91_32_, kinrelatio37_.f_unit as f5_91_32_, regristeus38_.id as id81_33_, regristeus38_.f_account as f2_81_33_, regristeus38_.f_address as f3_81_33_, regristeus38_.f_applyAddress as f4_81_33_, regristeus38_.f_area as f5_81_33_, regristeus38_.f_birthday as f6_81_33_, regristeus38_.f_educationalLev
el as f7_81_33_, regristeus38_.f_email as f8_81_33_, regristeus38_.f_englishLevel as f9_81_33_, regristeus38_.f_examineeFile as f10_81_33_, regristeus38_.f_graduationDate as f11_81_33_, regristeus38_.f_idCard as f12_81_33_, regristeus38_.f_loginDate as f13_81_33_, regristeus38_.f_marriageState as f14_81_33_, regristeus38_.f_moblePhone as f15_81_33_, regristeus38_.f_name as f16_81_33_, regristeus38_.f_nationality as f17_81_33_, regristeus38_.f_password as f18_81_33_, regristeus38_.f_personalPhoto as f19_81_33_, regristeus38_.f_phone as f20_81_33_, regristeus38_.f_politicsStatus as f21_81_33_, regristeus38_.f_post as f22_81_33_, regristeus38_.f_postStuation as f23_81_33_, regristeus38_.f_postbox as f24_81_33_, regristeus38_.f_profession as f25_81_33_, regristeus38_.f_registeredResidence as f26_81_33_, regristeus38_.f_regristDate as f27_81_33_, regristeus38_.f_remark as f28_81_33_, regristeus38_.f_resume as f29_81_33_, regristeus38_.f_school as f30_81_33_, regristeus38_.f_schoolRecord as f31_81_33_, regristeus38_.f_sex as f32_81_33_, regristeus38_.f_source as f33_81_33_, regristeus38_.f_specializedField as f34_81_33_, regristeus38_.f_technicaTitles as f35_81_33_, regristeus38_.f_unit as f36_81_33_, regristeus38_.f_unitNature as f37_81_33_, regristeus38_.f_useState as f38_81_33_, regristeus38_.f_workDate as f39_81_33_, regristeus38_.f_workYear as f40_81_33_ from servantApplyInfos servantapp0_ left outer join examAdmitPlan examadmitp1_ on servantap
p0_.f_examAdmitPlan_id=examadmitp1_.id left outer join institution institutio2_ on examadmitp1_.f_admitUnit_id=institutio2_.id left outer join users user3_ on institutio2_.f_createUser_id=user3_.id left outer join institution institutio4_ on user3_.f_institution_id=institutio4_.id left outer join include_grade_unit includegra5_ on institutio4_.id=includegra5_.unitid left outer join include_grade_set includegra6_ on includegra5_.includeid=includegra6_.id left outer join common_filed commonfile7_ on institutio4_.f_commonFiled_id=commonfile7_.id left outer join users user8_ on commonfile7_.f_user_id=user8_.id left outer join specializedField_auditer specialize9_ on user8_.id=specialize9_.userid left outer join exam_specializedField examspecia10_ on specialize9_.specializedField=examspecia10_.id left outer join exam_level examlevel11_ on examspecia10_.f_examLevel_id=examlevel11_.id left outer join exams exam12_ on examlevel11_.f_exam_id=exam12_.id left outer join discount_payment discountpa13_ on exam12_.id=discountpa13_.f_exam_id left outer join exam_subject examsubjec14_ on examspecia10_.id=examsubjec14_.f_exam_id left outer join adminssion_card admissionc15_ on examsubjec14_.f_admissionCard_id=admissionc15_.id left outer join applyInfo_exsubject applyinfos16_ on examsubjec14_.id=applyinfos16_.subjectid left outer join apply_info applyinfo17_ on applyinfos16_.applyId=applyinfo17_.id left outer join users user18_ on applyinfo17_.f_auditer_id=user18_.id left outer join exams exam
19_ on applyinfo17_.f_exam_id=exam19_.id left outer join exam_level examlevel20_ on applyinfo17_.f_examLevel_id=examlevel20_.id left outer join exam_specializedField examspecia21_ on applyinfo17_.f_examSpecializedField_id=examspecia21_.id left outer join users user22_ on applyinfo17_.f_gatheringUser_id=user22_.id left outer join user_apply_info regristuse23_ on applyinfo17_.id=regristuse23_.f_applyInfo_id left outer join BonusPoint_unit writeachie24_ on institutio4_.id=writeachie24_.unitid left outer join write_Achie_BPoint writeachie25_ on writeachie24_.waid=writeachie25_.id left outer join write_Achie_BPoint_condition condtions26_ on writeachie25_.id=condtions26_.f_writeAchievementBonusPoint left outer join batchSet batchset27_ on examadmitp1_.f_batchSet_id=batchset27_.id left outer join category_charge categorych28_ on batchset27_.id=categorych28_.f_batchSet_id left outer join batchSet_log logs29_ on batchset27_.id=logs29_.f_batchSet_id left outer join PayCheckQuartz paycheckqu30_ on batchset27_.id=paycheckqu30_.f_batchSetname left outer join category_subject categorysu31_ on examadmitp1_.f_categorySubject_id=categorysu31_.id left outer join users user32_ on categorysu31_.f_user_id=user32_.id left outer join institution institutio33_ on examadmitp1_.f_reportUnit_id=institutio33_.id left outer join users user34_ on examadmitp1_.f_user_id=user34_.id left outer join IsPublishExamAdmitPlan ispublishe35_ on examadmitp1_.id=ispublishe35_.examadmitplan_id left outer join servantU
serInfos servantuse36_ on servantapp0_.id=servantuse36_.f_servantApplyInfo_id left outer join kinRelations kinrelatio37_ on servantuse36_.id=kinrelatio37_.f_servantUserInfo_id left outer join regrist_user regristeus38_ on kinrelatio37_.f_regristeUser_id=regristeus38_.id where servantapp0_.id=:1 order by examsubjec14_.id ASC |
| akdb1nqh7k3wp | select columns0_.infoid as infoid1_, columns0_.columnid as columnid1_, infocolumn1_.id as id95_0_, infocolumn1_.f_audit as f2_95_0_, infocolumn1_.f_createDate as f3_95_0_, infocolumn1_.f_grade as f4_95_0_, infocolumn1_.f_name as f5_95_0_, infocolumn1_.f_parentId as f6_95_0_, infocolumn1_.f_serial as f7_95_0_, infocolumn1_.f_sort as f8_95_0_, infocolumn1_.f_type as f9_95_0_, infocolumn1_.f_upateDate as f10_95_0_, infocolumn1_.f_username as f11_95_0_ from info_column columns0_ left outer join columns infocolumn1_ on columns0_.columnid=infocolumn1_.id where columns0_.infoid=:1 |
| cc5fm6gnhvx2p |
select kinrelatio0_.f_regristeUser_id as f6_16_, kinrelatio0_.id as id16_, kinrelatio0_.id as id91_15_, kinrelatio0_.f_name as f2_91_15_, kinrelatio0_.f_post as f3_91_15_, kinrelatio0_.f_regristeUser_id as f6_91_15_, kinrelatio0_.f_relation as f4_91_15_, kinrelatio0_.f_servantUserInfo_id as f7_91_15_, kinrelatio0_.f_unit as f5_91_15_, servantuse1_.id as id102_0_, servantuse1_.f_account as f2_102_0_, servantuse1_.f_address as f3_102_0_, servantuse1_.f_applyAddress as f4_102_0_, servantuse1_.f_area as f5_102_0_, servantuse1_.f_birthday as f6_102_0_, servantuse1_.f_cardCode as f7_102_0_, servantuse1_.f_educationalLevel as f8_102_0_, servantuse1_.f_englishLevel as f9_102_0_, servantuse1_.examerIdentity as examerI10_102_0_, servantuse1_.f_examineSource as f11_102_0_, servantuse1_.f_f1 as f12_102_0_, servantuse1_.f_f2 as f13_102_0_, servantuse1_.f_f3 as f14_102_0_, servantuse1_.f_f4 as f15_102_0_, servantuse1_.f_f5 as f16_102_0_, servantuse1_.f_f6 as f17_102_0_, servantuse1_.f_f7 as f18_102_0_, servantuse1_.f_graduationDate as f19_102_0_, servantuse1_.f_idCard as f20_102_0_, servantuse1_.f_isSpecialExamineePost as f21_102_0_, servantuse1_.lastClickTime as lastCli22_102_0_, servantuse1_.f_marriageState as f23_102_0_, servantuse1_.f_moblePhone as f24_102_0_, servantuse1_.f_name as f25_102_0_, servantuse1_.f_nation as f26_102_0_, servantuse1_.f_nationality as f27_102_0_, servantuse1_.f_password as f28_102_0_, servantuse1_.f_personalPhoto as f29_102
_0_, servantuse1_.f_phone as f30_102_0_, servantuse1_.f_politicsStatus as f31_102_0_, servantuse1_.f_post as f32_102_0_, servantuse1_.f_postbox as f33_102_0_, servantuse1_.f_profession as f34_102_0_, servantuse1_.f_professionLevel as f35_102_0_, servantuse1_.f_registeredResidence as f36_102_0_, servantuse1_.f_remark as f37_102_0_, servantuse1_.f_resume as f38_102_0_, servantuse1_.f_school as f39_102_0_, servantuse1_.f_schoolRecord as f40_102_0_, servantuse1_.f_servantApplyInfo_id as f51_102_0_, servantuse1_.f_sex as f41_102_0_, servantuse1_.f_specializedField as f42_102_0_, servantuse1_.f_studentOriginBased as f43_102_0_, servantuse1_.f_technicaTitles as f44_102_0_, servantuse1_.f_unit as f45_102_0_, servantuse1_.f_unitNature as f46_102_0_, servantuse1_.f_userId as f47_102_0_, servantuse1_.f_workDate as f48_102_0_, servantuse1_.workPost as workPost102_0_, servantuse1_.f_workYear as f50_102_0_, servantapp2_.id as id111_1_, servantapp2_.f_applyCode as f2_111_1_, servantapp2_.f_applyDate as f3_111_1_, servantapp2_.f_auditDate as f4_111_1_, servantapp2_.f_examAdmitPlan_id as f13_111_1_, servantapp2_.f_examerStiation as f5_111_1_, servantapp2_.f_paymentState as f6_111_1_, servantapp2_.f_reapply as f7_111_1_, servantapp2_.f_rejectReason as f8_111_1_, servantapp2_.f_revocationDate as f9_111_1_, servantapp2_.f_revocationName as f10_111_1_, servantapp2_.f_revocationReason as f11_111_1_, servantapp2_.f_state as f12_111_1_, examadmitp3_.id as id53_2_,
examadmitp3_.f_admitNum as f2_53_2_, examadmitp3_.f_admitUnit_id as f27_53_2_, examadmitp3_.admitUnitName as admitUni3_53_2_, examadmitp3_.f_batchSet_id as f28_53_2_, examadmitp3_.f_batchSetName as f4_53_2_, examadmitp3_.f_categorySubject_id as f29_53_2_, examadmitp3_.examType as examType53_2_, examadmitp3_.hometown as hometown53_2_, examadmitp3_.maxRestrictionAge as maxRestr7_53_2_, examadmitp3_.minRestrictionAge as minRestr8_53_2_, examadmitp3_.f_otherCondition as f9_53_2_, examadmitp3_.f_physicalTest as f10_53_2_, examadmitp3_.f_postId as f11_53_2_, examadmitp3_.f_postName as f12_53_2_, examadmitp3_.f_rejectInfo as f13_53_2_, examadmitp3_.f_remark as f14_53_2_, examadmitp3_.f_repealInfo as f15_53_2_, examadmitp3_.f_reportUnit_id as f30_53_2_, examadmitp3_.reportUnitName as reportU16_53_2_, examadmitp3_.f_requireAge as f17_53_2_, examadmitp3_.f_requireEductionLevel as f18_53_2_, examadmitp3_.f_requireHometown as f19_53_2_, examadmitp3_.f_requireNation as f20_53_2_, examadmitp3_.f_requireSchoolRecord as f21_53_2_, examadmitp3_.f_requireSex as f22_53_2_, examadmitp3_.f_requireSpecialty as f23_53_2_, examadmitp3_.f_state as f24_53_2_, examadmitp3_.f_updateDate as f25_53_2_, examadmitp3_.f_updateInfo as f26_53_2_, examadmitp3_.f_user_id as f31_53_2_, institutio4_.id as id65_3_, institutio4_.f_code as f2_65_3_, institutio4_.f_content as f3_65_3_, institutio4_.f_createDate as f4_65_3_, institutio4_.f_createUser_id as f10_65_3_, institutio4_.f_
enabled as f5_65_3_, institutio4_.f_inslevel as f6_65_3_, institutio4_.f_name as f7_65_3_, institutio4_.f_commonFiled_id as f11_65_3_, institutio4_.f_sort as f8_65_3_, institutio4_.f_type as f9_65_3_, user5_.id as id8_4_, user5_.f_account as f2_8_4_, user5_.f_createDate as f3_8_4_, user5_.f_createRole as f4_8_4_, user5_.f_createrName as f5_8_4_, user5_.f_enabled as f6_8_4_, user5_.f_institution_id as f19_8_4_, user5_.f_name as f7_8_4_, user5_.f_password as f8_8_4_, user5_.f_rights as f9_8_4_, user5_.f_role as f10_8_4_, user5_.f_role1 as f11_8_4_, user5_.f_role2 as f12_8_4_, user5_.f_role3 as f13_8_4_, user5_.f_role4 as f14_8_4_, user5_.f_stopReason as f15_8_4_, user5_.f_updateDate as f16_8_4_, user5_.f_updateName as f17_8_4_, user5_.f_useState as f18_8_4_, institutio6_.id as id65_5_, institutio6_.f_code as f2_65_5_, institutio6_.f_content as f3_65_5_, institutio6_.f_createDate as f4_65_5_, institutio6_.f_createUser_id as f10_65_5_, institutio6_.f_enabled as f5_65_5_, institutio6_.f_inslevel as f6_65_5_, institutio6_.f_name as f7_65_5_, institutio6_.f_commonFiled_id as f11_65_5_, institutio6_.f_sort as f8_65_5_, institutio6_.f_type as f9_65_5_, commonfile7_.id as id72_6_, commonfile7_.f_address as f2_72_6_, commonfile7_.f_code as f3_72_6_, commonfile7_.f_name as f4_72_6_, commonfile7_.f_type as f5_72_6_, commonfile7_.f_updateDate as f6_72_6_, commonfile7_.f_user_id as f7_72_6_, user8_.id as id8_7_, user8_.f_account as f2_8_7_, user8
_.f_createDate as f3_8_7_, user8_.f_createRole as f4_8_7_, user8_.f_createrName as f5_8_7_, user8_.f_enabled as f6_8_7_, user8_.f_institution_id as f19_8_7_, user8_.f_name as f7_8_7_, user8_.f_password as f8_8_7_, user8_.f_rights as f9_8_7_, user8_.f_role as f10_8_7_, user8_.f_role1 as f11_8_7_, user8_.f_role2 as f12_8_7_, user8_.f_role3 as f13_8_7_, user8_.f_role4 as f14_8_7_, user8_.f_stopReason as f15_8_7_, user8_.f_updateDate as f16_8_7_, user8_.f_updateName as f17_8_7_, user8_.f_useState as f18_8_7_, batchset9_.id as id26_8_, batchset9_.f_applyEndDate as f2_26_8_, batchset9_.f_applyStartDate as f3_26_8_, batchset9_.f_cardCode as f4_26_8_, batchset9_.f_cardNotice as f5_26_8_, batchset9_.f_chargeType as f6_26_8_, batchset9_.f_examDate as f7_26_8_, batchset9_.f_musterName as f8_26_8_, batchset9_.f_name as f9_26_8_, batchset9_.f_paymentEndDate as f10_26_8_, batchset9_.f_paymentStartDate as f11_26_8_, batchset9_.f_publicApplyCount as f12_26_8_, batchset9_.f_publicAuditCount as f13_26_8_, batchset9_.f_publicPaymentCount as f14_26_8_, batchset9_.f_state as f15_26_8_, batchset9_.f_studentNotice as f16_26_8_, batchset9_.f_tableName as f17_26_8_, batchset9_.f_timelagDate as f18_26_8_, batchset9_.f_type as f19_26_8_, batchset9_.f_unitePrice as f20_26_8_, batchset9_.f_updateDate as f21_26_8_, batchset9_.f_updateName as f22_26_8_, paycheckqu10_.id as id2_9_, paycheckqu10_.f_batchSetname as f3_2_9_, paycheckqu10_.state as state2_9_, categorysu
11_.id as id101_10_, categorysu11_.f_name as f2_101_10_, categorysu11_.f_summary as f3_101_10_, categorysu11_.f_type as f4_101_10_, categorysu11_.f_typeCode as f5_101_10_, categorysu11_.f_typename as f6_101_10_, categorysu11_.f_updateDate as f7_101_10_, categorysu11_.f_user_id as f8_101_10_, user12_.id as id8_11_, user12_.f_account as f2_8_11_, user12_.f_createDate as f3_8_11_, user12_.f_createRole as f4_8_11_, user12_.f_createrName as f5_8_11_, user12_.f_enabled as f6_8_11_, user12_.f_institution_id as f19_8_11_, user12_.f_name as f7_8_11_, user12_.f_password as f8_8_11_, user12_.f_rights as f9_8_11_, user12_.f_role as f10_8_11_, user12_.f_role1 as f11_8_11_, user12_.f_role2 as f12_8_11_, user12_.f_role3 as f13_8_11_, user12_.f_role4 as f14_8_11_, user12_.f_stopReason as f15_8_11_, user12_.f_updateDate as f16_8_11_, user12_.f_updateName as f17_8_11_, user12_.f_useState as f18_8_11_, institutio13_.id as id65_12_, institutio13_.f_code as f2_65_12_, institutio13_.f_content as f3_65_12_, institutio13_.f_createDate as f4_65_12_, institutio13_.f_createUser_id as f10_65_12_, institutio13_.f_enabled as f5_65_12_, institutio13_.f_inslevel as f6_65_12_, institutio13_.f_name as f7_65_12_, institutio13_.f_commonFiled_id as f11_65_12_, institutio13_.f_sort as f8_65_12_, institutio13_.f_type as f9_65_12_, user14_.id as id8_13_, user14_.f_account as f2_8_13_, user14_.f_createDate as f3_8_13_, user14_.f_createRole as f4_8_13_, user14_.f_createrName
as f5_8_13_, user14_.f_enabled as f6_8_13_, user14_.f_institution_id as f19_8_13_, user14_.f_name as f7_8_13_, user14_.f_password as f8_8_13_, user14_.f_rights as f9_8_13_, user14_.f_role as f10_8_13_, user14_.f_role1 as f11_8_13_, user14_.f_role2 as f12_8_13_, user14_.f_role3 as f13_8_13_, user14_.f_role4 as f14_8_13_, user14_.f_stopReason as f15_8_13_, user14_.f_updateDate as f16_8_13_, user14_.f_updateName as f17_8_13_, user14_.f_useState as f18_8_13_, ispublishe15_.id as id33_14_, ispublishe15_.batchName as batchName33_14_, ispublishe15_.examadmitplan_id as examadmi6_33_14_, ispublishe15_.isPublish as isPublish33_14_, ispublishe15_.updateDate as updateDate33_14_, ispublishe15_.updateUser as updateUser33_14_ from kinRelations kinrelatio0_ left outer join servantUserInfos servantuse1_ on kinrelatio0_.f_servantUserInfo_id=servantuse1_.id left outer join servantApplyInfos servantapp2_ on servantuse1_.f_servantApplyInfo_id=servantapp2_.id left outer join examAdmitPlan examadmitp3_ on servantapp2_.f_examAdmitPlan_id=examadmitp3_.id left outer join institution institutio4_ on examadmitp3_.f_admitUnit_id=institutio4_.id left outer join users user5_ on institutio4_.f_createUser_id=user5_.id left outer join institution institutio6_ on user5_.f_institution_id=institutio6_.id left outer join common_filed commonfile7_ on institutio6_.f_commonFiled_id=commonfile7_.id left outer join users user8_ on commonfile7_.f_user_id=user8_.id left outer join batchSet batchset9_
on examadmitp3_.f_batchSet_id=batchset9_.id left outer join PayCheckQuartz paycheckqu10_ on batchset9_.id=paycheckqu10_.f_batchSetname left outer join category_subject categorysu11_ on examadmitp3_.f_categorySubject_id=categorysu11_.id left outer join users user12_ on categorysu11_.f_user_id=user12_.id left outer join institution institutio13_ on examadmitp3_.f_reportUnit_id=institutio13_.id left outer join users user14_ on examadmitp3_.f_user_id=user14_.id left outer join IsPublishExamAdmitPlan ispublishe15_ on examadmitp3_.id=ispublishe15_.examadmitplan_id where kinrelatio0_.f_regristeUser_id=:1 |
| cj52cq1u1hbrf |
select servantuse0_.id as id98_34_, servantuse0_.f_account as f2_98_34_, servantuse0_.f_address as f3_98_34_, servantuse0_.f_applyAddress as f4_98_34_, servantuse0_.f_area as f5_98_34_, servantuse0_.f_birthday as f6_98_34_, servantuse0_.f_cardCode as f7_98_34_, servantuse0_.f_educationalLevel as f8_98_34_, servantuse0_.f_englishLevel as f9_98_34_, servantuse0_.examerIdentity as examerI10_98_34_, servantuse0_.f_examineSource as f11_98_34_, servantuse0_.f_f1 as f12_98_34_, servantuse0_.f_f2 as f13_98_34_, servantuse0_.f_f3 as f14_98_34_, servantuse0_.f_f4 as f15_98_34_, servantuse0_.f_f5 as f16_98_34_, servantuse0_.f_f6 as f17_98_34_, servantuse0_.f_f7 as f18_98_34_, servantuse0_.f_graduationDate as f19_98_34_, servantuse0_.f_idCard as f20_98_34_, servantuse0_.f_isSpecialExamineePost as f21_98_34_, servantuse0_.lastClickTime as lastCli22_98_34_, servantuse0_.f_marriageState as f23_98_34_, servantuse0_.f_moblePhone as f24_98_34_, servantuse0_.f_name as f25_98_34_, servantuse0_.f_nation as f26_98_34_, servantuse0_.f_nationality as f27_98_34_, servantuse0_.f_password as f28_98_34_, servantuse0_.f_personalPhoto as f29_98_34_, servantuse0_.f_phone as f30_98_34_, servantuse0_.f_politicsStatus as f31_98_34_, servantuse0_.f_post as f32_98_34_, servantuse0_.f_postbox as f33_98_34_, servantuse0_.f_profession as f34_98_34_, servantuse0_.f_professionLevel as f35_98_34_, servantuse0_.f_registeredResidence as f36_98_34_, servantuse0_.f_remark as f37_98_34_
, servantuse0_.f_resume as f38_98_34_, servantuse0_.f_school as f39_98_34_, servantuse0_.f_schoolRecord as f40_98_34_, servantuse0_.f_servantApplyInfo_id as f51_98_34_, servantuse0_.f_sex as f41_98_34_, servantuse0_.f_specializedField as f42_98_34_, servantuse0_.f_studentOriginBased as f43_98_34_, servantuse0_.f_technicaTitles as f44_98_34_, servantuse0_.f_unit as f45_98_34_, servantuse0_.f_unitNature as f46_98_34_, servantuse0_.f_userId as f47_98_34_, servantuse0_.f_workDate as f48_98_34_, servantuse0_.workPost as workPost98_34_, servantuse0_.f_workYear as f50_98_34_, kinrelatio1_.f_servantUserInfo_id as f7_36_, kinrelatio1_.id as id36_, kinrelatio1_.id as id40_0_, kinrelatio1_.f_name as f2_40_0_, kinrelatio1_.f_post as f3_40_0_, kinrelatio1_.f_regristeUser_id as f6_40_0_, kinrelatio1_.f_relation as f4_40_0_, kinrelatio1_.f_servantUserInfo_id as f7_40_0_, kinrelatio1_.f_unit as f5_40_0_, regristeus2_.id as id107_1_, regristeus2_.f_account as f2_107_1_, regristeus2_.f_address as f3_107_1_, regristeus2_.f_applyAddress as f4_107_1_, regristeus2_.f_area as f5_107_1_, regristeus2_.f_birthday as f6_107_1_, regristeus2_.f_educationalLevel as f7_107_1_, regristeus2_.f_email as f8_107_1_, regristeus2_.f_englishLevel as f9_107_1_, regristeus2_.f_examineeFile as f10_107_1_, regristeus2_.f_graduationDate as f11_107_1_, regristeus2_.f_idCard as f12_107_1_, regristeus2_.f_loginDate as f13_107_1_, regristeus2_.f_marriageState as f14_107_1_, regristeus2
_.f_moblePhone as f15_107_1_, regristeus2_.f_name as f16_107_1_, regristeus2_.f_nationality as f17_107_1_, regristeus2_.f_password as f18_107_1_, regristeus2_.f_personalPhoto as f19_107_1_, regristeus2_.f_phone as f20_107_1_, regristeus2_.f_politicsStatus as f21_107_1_, regristeus2_.f_post as f22_107_1_, regristeus2_.f_postStuation as f23_107_1_, regristeus2_.f_postbox as f24_107_1_, regristeus2_.f_profession as f25_107_1_, regristeus2_.f_registeredResidence as f26_107_1_, regristeus2_.f_regristDate as f27_107_1_, regristeus2_.f_remark as f28_107_1_, regristeus2_.f_resume as f29_107_1_, regristeus2_.f_school as f30_107_1_, regristeus2_.f_schoolRecord as f31_107_1_, regristeus2_.f_sex as f32_107_1_, regristeus2_.f_source as f33_107_1_, regristeus2_.f_specializedField as f34_107_1_, regristeus2_.f_technicaTitles as f35_107_1_, regristeus2_.f_unit as f36_107_1_, regristeus2_.f_unitNature as f37_107_1_, regristeus2_.f_useState as f38_107_1_, regristeus2_.f_workDate as f39_107_1_, regristeus2_.f_workYear as f40_107_1_, servantapp3_.id as id49_2_, servantapp3_.f_applyCode as f2_49_2_, servantapp3_.f_applyDate as f3_49_2_, servantapp3_.f_auditDate as f4_49_2_, servantapp3_.f_examAdmitPlan_id as f13_49_2_, servantapp3_.f_examerStiation as f5_49_2_, servantapp3_.f_paymentState as f6_49_2_, servantapp3_.f_reapply as f7_49_2_, servantapp3_.f_rejectReason as f8_49_2_, servantapp3_.f_revocationDate as f9_49_2_, servantapp3_.f_revocationName as f10_49_2_
, servantapp3_.f_revocationReason as f11_49_2_, servantapp3_.f_state as f12_49_2_, examadmitp4_.id as id87_3_, examadmitp4_.f_admitNum as f2_87_3_, examadmitp4_.f_admitUnit_id as f27_87_3_, examadmitp4_.admitUnitName as admitUni3_87_3_, examadmitp4_.f_batchSet_id as f28_87_3_, examadmitp4_.f_batchSetName as f4_87_3_, examadmitp4_.f_categorySubject_id as f29_87_3_, examadmitp4_.examType as examType87_3_, examadmitp4_.hometown as hometown87_3_, examadmitp4_.maxRestrictionAge as maxRestr7_87_3_, examadmitp4_.minRestrictionAge as minRestr8_87_3_, examadmitp4_.f_otherCondition as f9_87_3_, examadmitp4_.f_physicalTest as f10_87_3_, examadmitp4_.f_postId as f11_87_3_, examadmitp4_.f_postName as f12_87_3_, examadmitp4_.f_rejectInfo as f13_87_3_, examadmitp4_.f_remark as f14_87_3_, examadmitp4_.f_repealInfo as f15_87_3_, examadmitp4_.f_reportUnit_id as f30_87_3_, examadmitp4_.reportUnitName as reportU16_87_3_, examadmitp4_.f_requireAge as f17_87_3_, examadmitp4_.f_requireEductionLevel as f18_87_3_, examadmitp4_.f_requireHometown as f19_87_3_, examadmitp4_.f_requireNation as f20_87_3_, examadmitp4_.f_requireSchoolRecord as f21_87_3_, examadmitp4_.f_requireSex as f22_87_3_, examadmitp4_.f_requireSpecialty as f23_87_3_, examadmitp4_.f_state as f24_87_3_, examadmitp4_.f_updateDate as f25_87_3_, examadmitp4_.f_updateInfo as f26_87_3_, examadmitp4_.f_user_id as f31_87_3_, institutio5_.id as id42_4_, institutio5_.f_code as f2_42_4_, institutio5_.f_content
as f3_42_4_, institutio5_.f_createDate as f4_42_4_, institutio5_.f_createUser_id as f10_42_4_, institutio5_.f_enabled as f5_42_4_, institutio5_.f_inslevel as f6_42_4_, institutio5_.f_name as f7_42_4_, institutio5_.f_commonFiled_id as f11_42_4_, institutio5_.f_sort as f8_42_4_, institutio5_.f_type as f9_42_4_, user6_.id as id70_5_, user6_.f_account as f2_70_5_, user6_.f_createDate as f3_70_5_, user6_.f_createRole as f4_70_5_, user6_.f_createrName as f5_70_5_, user6_.f_enabled as f6_70_5_, user6_.f_institution_id as f19_70_5_, user6_.f_name as f7_70_5_, user6_.f_password as f8_70_5_, user6_.f_rights as f9_70_5_, user6_.f_role as f10_70_5_, user6_.f_role1 as f11_70_5_, user6_.f_role2 as f12_70_5_, user6_.f_role3 as f13_70_5_, user6_.f_role4 as f14_70_5_, user6_.f_stopReason as f15_70_5_, user6_.f_updateDate as f16_70_5_, user6_.f_updateName as f17_70_5_, user6_.f_useState as f18_70_5_, institutio7_.id as id42_6_, institutio7_.f_code as f2_42_6_, institutio7_.f_content as f3_42_6_, institutio7_.f_createDate as f4_42_6_, institutio7_.f_createUser_id as f10_42_6_, institutio7_.f_enabled as f5_42_6_, institutio7_.f_inslevel as f6_42_6_, institutio7_.f_name as f7_42_6_, institutio7_.f_commonFiled_id as f11_42_6_, institutio7_.f_sort as f8_42_6_, institutio7_.f_type as f9_42_6_, includegra8_.unitid as unitid37_, includegra9_.id as includeid37_, includegra9_.id as id52_7_, includegra9_.f_adminNum as f2_52_7_, includegra9_.f_batchSetName as f3_
52_7_, includegra9_.f_grade as f4_52_7_, includegra9_.f_includeCount as f5_52_7_, includegra9_.f_postName as f6_52_7_, includegra9_.f_type as f7_52_7_, includegra9_.f_unitId as f8_52_7_, includegra9_.f_unitName as f9_52_7_, includegra9_.f_unitNature as f10_52_7_, commonfile10_.id as id75_8_, commonfile10_.f_address as f2_75_8_, commonfile10_.f_code as f3_75_8_, commonfile10_.f_name as f4_75_8_, commonfile10_.f_type as f5_75_8_, commonfile10_.f_updateDate as f6_75_8_, commonfile10_.f_user_id as f7_75_8_, user11_.id as id70_9_, user11_.f_account as f2_70_9_, user11_.f_createDate as f3_70_9_, user11_.f_createRole as f4_70_9_, user11_.f_createrName as f5_70_9_, user11_.f_enabled as f6_70_9_, user11_.f_institution_id as f19_70_9_, user11_.f_name as f7_70_9_, user11_.f_password as f8_70_9_, user11_.f_rights as f9_70_9_, user11_.f_role as f10_70_9_, user11_.f_role1 as f11_70_9_, user11_.f_role2 as f12_70_9_, user11_.f_role3 as f13_70_9_, user11_.f_role4 as f14_70_9_, user11_.f_stopReason as f15_70_9_, user11_.f_updateDate as f16_70_9_, user11_.f_updateName as f17_70_9_, user11_.f_useState as f18_70_9_, specialize12_.userid as userid38_, examspecia13_.id as speciali2_38_, examspecia13_.id as id59_10_, examspecia13_.f_audit as f2_59_10_, examspecia13_.f_begin as f3_59_10_, examspecia13_.f_code as f4_59_10_, examspecia13_.f_examLevel_id as f7_59_10_, examspecia13_.f_isApply as f5_59_10_, examspecia13_.f_name as f6_59_10_, examlevel14_.id as id
33_11_, examlevel14_.f_amount as f2_33_11_, examlevel14_.f_code as f3_33_11_, examlevel14_.f_exam_id as f6_33_11_, examlevel14_.f_name as f4_33_11_, examlevel14_.f_scroll as f5_33_11_, exam15_.id as id32_12_, exam15_.f_abbreviation as f2_32_12_, exam15_.f_applyDateEnd as f3_32_12_, exam15_.f_applyDateStart as f4_32_12_, exam15_.f_audit as f5_32_12_, exam15_.f_auditDateEnd as f6_32_12_, exam15_.f_auditDateStart as f7_32_12_, exam15_.f_code as f8_32_12_, exam15_.f_examName as f9_32_12_, exam15_.f_examYear as f10_32_12_, exam15_.f_notice as f11_32_12_, exam15_.f_operateDate as f12_32_12_, exam15_.f_payMentDateEnd as f13_32_12_, exam15_.f_payMentDateStart as f14_32_12_, exam15_.f_payType as f15_32_12_, exam15_.f_regularAmount as f16_32_12_, exam15_.f_rule as f17_32_12_, exam15_.f_type as f18_32_12_, discountpa16_.id as id18_13_, discountpa16_.f_discountRate as f2_18_13_, discountpa16_.f_discountScroll as f3_18_13_, discountpa16_.f_discountScrollRate as f4_18_13_, discountpa16_.f_discountType as f5_18_13_, discountpa16_.f_exam_id as f11_18_13_, discountpa16_.f_mode as f6_18_13_, discountpa16_.f_modeScrollValue as f7_18_13_, discountpa16_.f_modeValue as f8_18_13_, discountpa16_.f_payMentType as f9_18_13_, discountpa16_.f_scrollPayMentType as f10_18_13_, examsubjec17_.f_exam_id as f11_39_, examsubjec17_.id as id39_, examsubjec17_.id as id43_14_, examsubjec17_.f_admissionCard_id as f10_43_14_, examsubjec17_.f_amount as f2_43_14_, examsubjec17_.
code as code43_14_, examsubjec17_.endTime as endTime43_14_, examsubjec17_.f_exam_id as f11_43_14_, examsubjec17_.examDate as examDate43_14_, examsubjec17_.gatherDate as gatherDate43_14_, examsubjec17_.f_name as f7_43_14_, examsubjec17_.f_score as f8_43_14_, examsubjec17_.startTime as startTime43_14_, admissionc18_.id as id37_15_, admissionc18_.f_cardCode as f2_37_15_, admissionc18_.f_createDate as f3_37_15_, admissionc18_.f_examArea as f4_37_15_, admissionc18_.f_examLevel as f5_37_15_, admissionc18_.f_examLevelCode as f6_37_15_, admissionc18_.f_examName as f7_37_15_, admissionc18_.f_examPlaceCode as f8_37_15_, admissionc18_.f_examPoint as f9_37_15_, admissionc18_.f_examSpecialty as f10_37_15_, admissionc18_.f_examSpecialtyCode as f11_37_15_, admissionc18_.f_examSubject as f12_37_15_, admissionc18_.f_examSubjectCode as f13_37_15_, admissionc18_.f_examYear as f14_37_15_, admissionc18_.f_idCard as f15_37_15_, admissionc18_.f_seatCode as f16_37_15_, admissionc18_.f_userName as f17_37_15_, applyinfos19_.subjectid as subjectid40_, applyinfo20_.id as applyId40_, applyinfo20_.id as id4_16_, applyinfo20_.f_applyCode as f2_4_16_, applyinfo20_.f_applyDate as f3_4_16_, applyinfo20_.f_applyMode as f4_4_16_, applyinfo20_.f_applySerial as f5_4_16_, applyinfo20_.f_auditDate as f6_4_16_, applyinfo20_.f_auditName as f7_4_16_, applyinfo20_.f_auditRevocationDate as f8_4_16_, applyinfo20_.f_auditer_id as f20_4_16_, applyinfo20_.f_confirm as f9_4_16_, applyinfo
20_.f_exam_id as f21_4_16_, applyinfo20_.f_examLevel_id as f22_4_16_, applyinfo20_.f_examSpecializedField_id as f23_4_16_, applyinfo20_.f_gatheringDate as f10_4_16_, applyinfo20_.f_gatheringUser_id as f24_4_16_, applyinfo20_.f_paymentAmount as f11_4_16_, applyinfo20_.f_paymentComeSerial as f12_4_16_, applyinfo20_.f_paymentDate as f13_4_16_, applyinfo20_.f_paymentMode as f14_4_16_, applyinfo20_.f_paymentOrderCode as f15_4_16_, applyinfo20_.f_rejectDate as f16_4_16_, applyinfo20_.f_rejectReason as f17_4_16_, applyinfo20_.f_state as f18_4_16_, applyinfo20_.f_stauts as f19_4_16_, user21_.id as id70_17_, user21_.f_account as f2_70_17_, user21_.f_createDate as f3_70_17_, user21_.f_createRole as f4_70_17_, user21_.f_createrName as f5_70_17_, user21_.f_enabled as f6_70_17_, user21_.f_institution_id as f19_70_17_, user21_.f_name as f7_70_17_, user21_.f_password as f8_70_17_, user21_.f_rights as f9_70_17_, user21_.f_role as f10_70_17_, user21_.f_role1 as f11_70_17_, user21_.f_role2 as f12_70_17_, user21_.f_role3 as f13_70_17_, user21_.f_role4 as f14_70_17_, user21_.f_stopReason as f15_70_17_, user21_.f_updateDate as f16_70_17_, user21_.f_updateName as f17_70_17_, user21_.f_useState as f18_70_17_, exam22_.id as id32_18_, exam22_.f_abbreviation as f2_32_18_, exam22_.f_applyDateEnd as f3_32_18_, exam22_.f_applyDateStart as f4_32_18_, exam22_.f_audit as f5_32_18_, exam22_.f_auditDateEnd as f6_32_18_, exam22_.f_auditDateStart as f7_32_18_, exam22_.f_c
ode as f8_32_18_, exam22_.f_examName as f9_32_18_, exam22_.f_examYear as f10_32_18_, exam22_.f_notice as f11_32_18_, exam22_.f_operateDate as f12_32_18_, exam22_.f_payMentDateEnd as f13_32_18_, exam22_.f_payMentDateStart as f14_32_18_, exam22_.f_payType as f15_32_18_, exam22_.f_regularAmount as f16_32_18_, exam22_.f_rule as f17_32_18_, exam22_.f_type as f18_32_18_, examlevel23_.id as id33_19_, examlevel23_.f_amount as f2_33_19_, examlevel23_.f_code as f3_33_19_, examlevel23_.f_exam_id as f6_33_19_, examlevel23_.f_name as f4_33_19_, examlevel23_.f_scroll as f5_33_19_, examspecia24_.id as id59_20_, examspecia24_.f_audit as f2_59_20_, examspecia24_.f_begin as f3_59_20_, examspecia24_.f_code as f4_59_20_, examspecia24_.f_examLevel_id as f7_59_20_, examspecia24_.f_isApply as f5_59_20_, examspecia24_.f_name as f6_59_20_, user25_.id as id70_21_, user25_.f_account as f2_70_21_, user25_.f_createDate as f3_70_21_, user25_.f_createRole as f4_70_21_, user25_.f_createrName as f5_70_21_, user25_.f_enabled as f6_70_21_, user25_.f_institution_id as f19_70_21_, user25_.f_name as f7_70_21_, user25_.f_password as f8_70_21_, user25_.f_rights as f9_70_21_, user25_.f_role as f10_70_21_, user25_.f_role1 as f11_70_21_, user25_.f_role2 as f12_70_21_, user25_.f_role3 as f13_70_21_, user25_.f_role4 as f14_70_21_, user25_.f_stopReason as f15_70_21_, user25_.f_updateDate as f16_70_21_, user25_.f_updateName as f17_70_21_, user25_.f_useState as f18_70_21_, regrist
use26_.id as id16_22_, regristuse26_.f_account as f2_16_22_, regristuse26_.f_address as f3_16_22_, regristuse26_.f_applyAddress as f4_16_22_, regristuse26_.f_applyInfo_id as f37_16_22_, regristuse26_.f_area as f5_16_22_, regristuse26_.f_birthday as f6_16_22_, regristuse26_.f_educationalLevel as f7_16_22_, regristuse26_.f_englishLevel as f8_16_22_, regristuse26_.f_examineeFile as f9_16_22_, regristuse26_.f_graduationDate as f10_16_22_, regristuse26_.f_idCard as f11_16_22_, regristuse26_.f_marriageState as f12_16_22_, regristuse26_.f_moblePhone as f13_16_22_, regristuse26_.f_name as f14_16_22_, regristuse26_.f_nationality as f15_16_22_, regristuse26_.f_password as f16_16_22_, regristuse26_.f_personalPhoto as f17_16_22_, regristuse26_.f_phone as f18_16_22_, regristuse26_.f_politicsStatus as f19_16_22_, regristuse26_.f_post as f20_16_22_, regristuse26_.f_postStuation as f21_16_22_, regristuse26_.f_postbox as f22_16_22_, regristuse26_.f_profession as f23_16_22_, regristuse26_.f_professionLevel as f24_16_22_, regristuse26_.f_registeredResidence as f25_16_22_, regristuse26_.f_school as f26_16_22_, regristuse26_.f_schoolRecord as f27_16_22_, regristuse26_.f_sex as f28_16_22_, regristuse26_.f_source as f29_16_22_, regristuse26_.f_specializedField as f30_16_22_, regristuse26_.f_technicaTitles as f31_16_22_, regristuse26_.f_unit as f32_16_22_, regristuse26_.f_unitNature as f33_16_22_, regristuse26_.f_userId as f34_16_22_, regristuse26_.f_workDate as f3
5_16_22_, regristuse26_.f_workYear as f36_16_22_, writeachie27_.unitid as unitid41_, writeachie28_.id as waid41_, writeachie28_.id as id46_23_, writeachie28_.f_batchSetName as f2_46_23_, writeachie28_.f_policy as f3_46_23_, writeachie28_.f_scale as f4_46_23_, writeachie28_.suitType as suitType46_23_, condtions29_.f_writeAchievementBonusPoint as f7_42_, condtions29_.id as id42_, condtions29_.id as id61_24_, condtions29_.f_batchName as f2_61_24_, condtions29_.f_condtion as f3_61_24_, condtions29_.f_relation as f4_61_24_, condtions29_.f_scale as f5_61_24_, condtions29_.f_value as f6_61_24_, condtions29_.f_writeAchievementBonusPoint as f7_61_24_, batchset30_.id as id50_25_, batchset30_.f_applyEndDate as f2_50_25_, batchset30_.f_applyStartDate as f3_50_25_, batchset30_.f_cardCode as f4_50_25_, batchset30_.f_cardNotice as f5_50_25_, batchset30_.f_chargeType as f6_50_25_, batchset30_.f_examDate as f7_50_25_, batchset30_.f_musterName as f8_50_25_, batchset30_.f_name as f9_50_25_, batchset30_.f_paymentEndDate as f10_50_25_, batchset30_.f_paymentStartDate as f11_50_25_, batchset30_.f_publicApplyCount as f12_50_25_, batchset30_.f_publicAuditCount as f13_50_25_, batchset30_.f_publicPaymentCount as f14_50_25_, batchset30_.f_state as f15_50_25_, batchset30_.f_studentNotice as f16_50_25_, batchset30_.f_tableName as f17_50_25_, batchset30_.f_timelagDate as f18_50_25_, batchset30_.f_type as f19_50_25_, batchset30_.f_unitePrice as f20_50_25_, batchset30_.f
_updateDate as f21_50_25_, batchset30_.f_updateName as f22_50_25_, categorych31_.f_batchSet_id as f4_43_, categorych31_.id as id43_, categorych31_.id as id104_26_, categorych31_.f_amount as f2_104_26_, categorych31_.f_batchSet_id as f4_104_26_, categorych31_.f_name as f3_104_26_, logs32_.f_batchSet_id as f4_44_, logs32_.id as id44_, logs32_.id as id78_27_, logs32_.f_batchSet_id as f4_78_27_, logs32_.f_operatorDate as f2_78_27_, logs32_.f_userName as f3_78_27_, paycheckqu33_.id as id72_28_, paycheckqu33_.f_batchSetname as f3_72_28_, paycheckqu33_.state as state72_28_, categorysu34_.id as id111_29_, categorysu34_.f_name as f2_111_29_, categorysu34_.f_summary as f3_111_29_, categorysu34_.f_type as f4_111_29_, categorysu34_.f_typeCode as f5_111_29_, categorysu34_.f_typename as f6_111_29_, categorysu34_.f_updateDate as f7_111_29_, categorysu34_.f_user_id as f8_111_29_, user35_.id as id70_30_, user35_.f_account as f2_70_30_, user35_.f_createDate as f3_70_30_, user35_.f_createRole as f4_70_30_, user35_.f_createrName as f5_70_30_, user35_.f_enabled as f6_70_30_, user35_.f_institution_id as f19_70_30_, user35_.f_name as f7_70_30_, user35_.f_password as f8_70_30_, user35_.f_rights as f9_70_30_, user35_.f_role as f10_70_30_, user35_.f_role1 as f11_70_30_, user35_.f_role2 as f12_70_30_, user35_.f_role3 as f13_70_30_, user35_.f_role4 as f14_70_30_, user35_.f_stopReason as f15_70_30_, user35_.f_updateDate as f16_70_30_, user35_.f_updateName as f17_
70_30_, user35_.f_useState as f18_70_30_, institutio36_.id as id42_31_, institutio36_.f_code as f2_42_31_, institutio36_.f_content as f3_42_31_, institutio36_.f_createDate as f4_42_31_, institutio36_.f_createUser_id as f10_42_31_, institutio36_.f_enabled as f5_42_31_, institutio36_.f_inslevel as f6_42_31_, institutio36_.f_name as f7_42_31_, institutio36_.f_commonFiled_id as f11_42_31_, institutio36_.f_sort as f8_42_31_, institutio36_.f_type as f9_42_31_, user37_.id as id70_32_, user37_.f_account as f2_70_32_, user37_.f_createDate as f3_70_32_, user37_.f_createRole as f4_70_32_, user37_.f_createrName as f5_70_32_, user37_.f_enabled as f6_70_32_, user37_.f_institution_id as f19_70_32_, user37_.f_name as f7_70_32_, user37_.f_password as f8_70_32_, user37_.f_rights as f9_70_32_, user37_.f_role as f10_70_32_, user37_.f_role1 as f11_70_32_, user37_.f_role2 as f12_70_32_, user37_.f_role3 as f13_70_32_, user37_.f_role4 as f14_70_32_, user37_.f_stopReason as f15_70_32_, user37_.f_updateDate as f16_70_32_, user37_.f_updateName as f17_70_32_, user37_.f_useState as f18_70_32_, ispublishe38_.id as id8_33_, ispublishe38_.batchName as batchName8_33_, ispublishe38_.examadmitplan_id as examadmi6_8_33_, ispublishe38_.isPublish as isPublish8_33_, ispublishe38_.updateDate as updateDate8_33_, ispublishe38_.updateUser as updateUser8_33_ from servantUserInfos servantuse0_ left outer join kinRelations kinrelatio1_ on servantuse0_.id=kinrelatio1_.f_servantUserInfo
_id left outer join regrist_user regristeus2_ on kinrelatio1_.f_regristeUser_id=regristeus2_.id left outer join servantApplyInfos servantapp3_ on servantuse0_.f_servantApplyInfo_id=servantapp3_.id left outer join examAdmitPlan examadmitp4_ on servantapp3_.f_examAdmitPlan_id=examadmitp4_.id left outer join institution institutio5_ on examadmitp4_.f_admitUnit_id=institutio5_.id left outer join users user6_ on institutio5_.f_createUser_id=user6_.id left outer join institution institutio7_ on user6_.f_institution_id=institutio7_.id left outer join include_grade_unit includegra8_ on institutio7_.id=includegra8_.unitid left outer join include_grade_set includegra9_ on includegra8_.includeid=includegra9_.id left outer join common_filed commonfile10_ on institutio7_.f_commonFiled_id=commonfile10_.id left outer join users user11_ on commonfile10_.f_user_id=user11_.id left outer join specializedField_auditer specialize12_ on user11_.id=specialize12_.userid left outer join exam_specializedField examspecia13_ on specialize12_.specializedField=examspecia13_.id left outer join exam_level examlevel14_ on examspecia13_.f_examLevel_id=examlevel14_.id left outer join exams exam15_ on examlevel14_.f_exam_id=exam15_.id left outer join discount_payment discountpa16_ on exam15_.id=discountpa16_.f_exam_id left outer join exam_subject examsubjec17_ on examspecia13_.id=examsubjec17_.f_exam_id left outer join adminssion_card admissionc18_ on examsubjec17_.f_admissionCard_id=admissionc18_.id left outer
join applyInfo_exsubject applyinfos19_ on examsubjec17_.id=applyinfos19_.subjectid left outer join apply_info applyinfo20_ on applyinfos19_.applyId=applyinfo20_.id left outer join users user21_ on applyinfo20_.f_auditer_id=user21_.id left outer join exams exam22_ on applyinfo20_.f_exam_id=exam22_.id left outer join exam_level examlevel23_ on applyinfo20_.f_examLevel_id=examlevel23_.id left outer join exam_specializedField examspecia24_ on applyinfo20_.f_examSpecializedField_id=examspecia24_.id left outer join users user25_ on applyinfo20_.f_gatheringUser_id=user25_.id left outer join user_apply_info regristuse26_ on applyinfo20_.id=regristuse26_.f_applyInfo_id left outer join BonusPoint_unit writeachie27_ on institutio7_.id=writeachie27_.unitid left outer join write_Achie_BPoint writeachie28_ on writeachie27_.waid=writeachie28_.id left outer join write_Achie_BPoint_condition condtions29_ on writeachie28_.id=condtions29_.f_writeAchievementBonusPoint left outer join batchSet batchset30_ on examadmitp4_.f_batchSet_id=batchset30_.id left outer join category_charge categorych31_ on batchset30_.id=categorych31_.f_batchSet_id left outer join batchSet_log logs32_ on batchset30_.id=logs32_.f_batchSet_id left outer join PayCheckQuartz paycheckqu33_ on batchset30_.id=paycheckqu33_.f_batchSetname left outer join category_subject categorysu34_ on examadmitp4_.f_categorySubject_id=categorysu34_.id left outer join users user35_ on categorysu34_.f_user_id=user35_.id left outer join institut
ion institutio36_ on examadmitp4_.f_reportUnit_id=institutio36_.id left outer join users user37_ on examadmitp4_.f_user_id=user37_.id left outer join IsPublishExamAdmitPlan ispublishe38_ on examadmitp4_.id=ispublishe38_.examadmitplan_id where servantuse0_.f_servantApplyInfo_id=:1 order by examsubjec17_.id ASC |
| dhu478ugjs6j1 |
select infos0_.columnid as columnid8_, infos0_.infoid as infoid8_, info1_.id as id45_0_, info1_.f_ahthor as f2_45_0_, info1_.f_auditDate as f3_45_0_, info1_.f_auditUser_id as f24_45_0_, info1_.f_content as f4_45_0_, info1_.f_createDate as f5_45_0_, info1_.f_createUser_id as f25_45_0_, info1_.f_f1 as f6_45_0_, info1_.f_f2 as f7_45_0_, info1_.f_f3 as f8_45_0_, info1_.f_f4 as f9_45_0_, info1_.f_f5 as f10_45_0_, info1_.f_f6 as f11_45_0_, info1_.f_keyWord as f12_45_0_, info1_.f_operator as f13_45_0_, info1_.f_operatorDate as f14_45_0_, info1_.f_path as f15_45_0_, info1_.f_recommand as f16_45_0_, info1_.f_recommandImage as f17_45_0_, info1_.f_rejectReason as f18_45_0_, info1_.f_state as f19_45_0_, info1_.f_subtitle as f20_45_0_, info1_.f_title as f21_45_0_, info1_.f_updateDate as f22_45_0_, info1_.f_updateUser_id as f26_45_0_, info1_.f_viewCount as f23_45_0_, user2_.id as id70_1_, user2_.f_account as f2_70_1_, user2_.f_createDate as f3_70_1_, user2_.f_createRole as f4_70_1_, user2_.f_createrName as f5_70_1_, user2_.f_enabled as f6_70_1_, user2_.f_institution_id as f19_70_1_, user2_.f_name as f7_70_1_, user2_.f_password as f8_70_1_, user2_.f_rights as f9_70_1_, user2_.f_role as f10_70_1_, user2_.f_role1 as f11_70_1_, user2_.f_role2 as f12_70_1_, user2_.f_role3 as f13_70_1_, user2_.f_role4 as f14_70_1_, user2_.f_stopReason as f15_70_1_, user2_.f_updateDate as f16_70_1_, user2_.f_updateName as f17_70_1_, user2_.f_useState as f18_70_1_, in
stitutio3_.id as id42_2_, institutio3_.f_code as f2_42_2_, institutio3_.f_content as f3_42_2_, institutio3_.f_createDate as f4_42_2_, institutio3_.f_createUser_id as f10_42_2_, institutio3_.f_enabled as f5_42_2_, institutio3_.f_inslevel as f6_42_2_, institutio3_.f_name as f7_42_2_, institutio3_.f_commonFiled_id as f11_42_2_, institutio3_.f_sort as f8_42_2_, institutio3_.f_type as f9_42_2_, user4_.id as id70_3_, user4_.f_account as f2_70_3_, user4_.f_createDate as f3_70_3_, user4_.f_createRole as f4_70_3_, user4_.f_createrName as f5_70_3_, user4_.f_enabled as f6_70_3_, user4_.f_institution_id as f19_70_3_, user4_.f_name as f7_70_3_, user4_.f_password as f8_70_3_, user4_.f_rights as f9_70_3_, user4_.f_role as f10_70_3_, user4_.f_role1 as f11_70_3_, user4_.f_role2 as f12_70_3_, user4_.f_role3 as f13_70_3_, user4_.f_role4 as f14_70_3_, user4_.f_stopReason as f15_70_3_, user4_.f_updateDate as f16_70_3_, user4_.f_updateName as f17_70_3_, user4_.f_useState as f18_70_3_, commonfile5_.id as id75_4_, commonfile5_.f_address as f2_75_4_, commonfile5_.f_code as f3_75_4_, commonfile5_.f_name as f4_75_4_, commonfile5_.f_type as f5_75_4_, commonfile5_.f_updateDate as f6_75_4_, commonfile5_.f_user_id as f7_75_4_, user6_.id as id70_5_, user6_.f_account as f2_70_5_, user6_.f_createDate as f3_70_5_, user6_.f_createRole as f4_70_5_, user6_.f_createrName as f5_70_5_, user6_.f_enabled as f6_70_5_, user6_.f_institution_id as f19_70_5_, user6_.f_name as f7_
70_5_, user6_.f_password as f8_70_5_, user6_.f_rights as f9_70_5_, user6_.f_role as f10_70_5_, user6_.f_role1 as f11_70_5_, user6_.f_role2 as f12_70_5_, user6_.f_role3 as f13_70_5_, user6_.f_role4 as f14_70_5_, user6_.f_stopReason as f15_70_5_, user6_.f_updateDate as f16_70_5_, user6_.f_updateName as f17_70_5_, user6_.f_useState as f18_70_5_, user7_.id as id70_6_, user7_.f_account as f2_70_6_, user7_.f_createDate as f3_70_6_, user7_.f_createRole as f4_70_6_, user7_.f_createrName as f5_70_6_, user7_.f_enabled as f6_70_6_, user7_.f_institution_id as f19_70_6_, user7_.f_name as f7_70_6_, user7_.f_password as f8_70_6_, user7_.f_rights as f9_70_6_, user7_.f_role as f10_70_6_, user7_.f_role1 as f11_70_6_, user7_.f_role2 as f12_70_6_, user7_.f_role3 as f13_70_6_, user7_.f_role4 as f14_70_6_, user7_.f_stopReason as f15_70_6_, user7_.f_updateDate as f16_70_6_, user7_.f_updateName as f17_70_6_, user7_.f_useState as f18_70_6_, user8_.id as id70_7_, user8_.f_account as f2_70_7_, user8_.f_createDate as f3_70_7_, user8_.f_createRole as f4_70_7_, user8_.f_createrName as f5_70_7_, user8_.f_enabled as f6_70_7_, user8_.f_institution_id as f19_70_7_, user8_.f_name as f7_70_7_, user8_.f_password as f8_70_7_, user8_.f_rights as f9_70_7_, user8_.f_role as f10_70_7_, user8_.f_role1 as f11_70_7_, user8_.f_role2 as f12_70_7_, user8_.f_role3 as f13_70_7_, user8_.f_role4 as f14_70_7_, user8_.f_stopReason as f15_70_7_, user8_.f_updateDate as f16_70_7_, use
r8_.f_updateName as f17_70_7_, user8_.f_useState as f18_70_7_ from info_column infos0_ left outer join infos info1_ on infos0_.infoid=info1_.id left outer join users user2_ on info1_.f_auditUser_id=user2_.id left outer join institution institutio3_ on user2_.f_institution_id=institutio3_.id left outer join users user4_ on institutio3_.f_createUser_id=user4_.id left outer join common_filed commonfile5_ on institutio3_.f_commonFiled_id=commonfile5_.id left outer join users user6_ on commonfile5_.f_user_id=user6_.id left outer join users user7_ on info1_.f_createUser_id=user7_.id left outer join users user8_ on info1_.f_updateUser_id=user8_.id where infos0_.columnid=:1 order by info1_.f_operatorDate DESC |
| dph7u5kr041p0 |
select infos0_.columnid as columnid8_, infos0_.infoid as infoid8_, info1_.id as id71_0_, info1_.f_ahthor as f2_71_0_, info1_.f_auditDate as f3_71_0_, info1_.f_auditUser_id as f24_71_0_, info1_.f_content as f4_71_0_, info1_.f_createDate as f5_71_0_, info1_.f_createUser_id as f25_71_0_, info1_.f_f1 as f6_71_0_, info1_.f_f2 as f7_71_0_, info1_.f_f3 as f8_71_0_, info1_.f_f4 as f9_71_0_, info1_.f_f5 as f10_71_0_, info1_.f_f6 as f11_71_0_, info1_.f_keyWord as f12_71_0_, info1_.f_operator as f13_71_0_, info1_.f_operatorDate as f14_71_0_, info1_.f_path as f15_71_0_, info1_.f_recommand as f16_71_0_, info1_.f_recommandImage as f17_71_0_, info1_.f_rejectReason as f18_71_0_, info1_.f_state as f19_71_0_, info1_.f_subtitle as f20_71_0_, info1_.f_title as f21_71_0_, info1_.f_updateDate as f22_71_0_, info1_.f_updateUser_id as f26_71_0_, info1_.f_viewCount as f23_71_0_, user2_.id as id8_1_, user2_.f_account as f2_8_1_, user2_.f_createDate as f3_8_1_, user2_.f_createRole as f4_8_1_, user2_.f_createrName as f5_8_1_, user2_.f_enabled as f6_8_1_, user2_.f_institution_id as f19_8_1_, user2_.f_name as f7_8_1_, user2_.f_password as f8_8_1_, user2_.f_rights as f9_8_1_, user2_.f_role as f10_8_1_, user2_.f_role1 as f11_8_1_, user2_.f_role2 as f12_8_1_, user2_.f_role3 as f13_8_1_, user2_.f_role4 as f14_8_1_, user2_.f_stopReason as f15_8_1_, user2_.f_updateDate as f16_8_1_, user2_.f_updateName as f17_8_1_, user2_.f_useState as f18_8_1_, institutio3_.id as id
65_2_, institutio3_.f_code as f2_65_2_, institutio3_.f_content as f3_65_2_, institutio3_.f_createDate as f4_65_2_, institutio3_.f_createUser_id as f10_65_2_, institutio3_.f_enabled as f5_65_2_, institutio3_.f_inslevel as f6_65_2_, institutio3_.f_name as f7_65_2_, institutio3_.f_commonFiled_id as f11_65_2_, institutio3_.f_sort as f8_65_2_, institutio3_.f_type as f9_65_2_, user4_.id as id8_3_, user4_.f_account as f2_8_3_, user4_.f_createDate as f3_8_3_, user4_.f_createRole as f4_8_3_, user4_.f_createrName as f5_8_3_, user4_.f_enabled as f6_8_3_, user4_.f_institution_id as f19_8_3_, user4_.f_name as f7_8_3_, user4_.f_password as f8_8_3_, user4_.f_rights as f9_8_3_, user4_.f_role as f10_8_3_, user4_.f_role1 as f11_8_3_, user4_.f_role2 as f12_8_3_, user4_.f_role3 as f13_8_3_, user4_.f_role4 as f14_8_3_, user4_.f_stopReason as f15_8_3_, user4_.f_updateDate as f16_8_3_, user4_.f_updateName as f17_8_3_, user4_.f_useState as f18_8_3_, commonfile5_.id as id72_4_, commonfile5_.f_address as f2_72_4_, commonfile5_.f_code as f3_72_4_, commonfile5_.f_name as f4_72_4_, commonfile5_.f_type as f5_72_4_, commonfile5_.f_updateDate as f6_72_4_, commonfile5_.f_user_id as f7_72_4_, user6_.id as id8_5_, user6_.f_account as f2_8_5_, user6_.f_createDate as f3_8_5_, user6_.f_createRole as f4_8_5_, user6_.f_createrName as f5_8_5_, user6_.f_enabled as f6_8_5_, user6_.f_institution_id as f19_8_5_, user6_.f_name as f7_8_5_, user6_.f_password as f8_8_5_, user6_.
f_rights as f9_8_5_, user6_.f_role as f10_8_5_, user6_.f_role1 as f11_8_5_, user6_.f_role2 as f12_8_5_, user6_.f_role3 as f13_8_5_, user6_.f_role4 as f14_8_5_, user6_.f_stopReason as f15_8_5_, user6_.f_updateDate as f16_8_5_, user6_.f_updateName as f17_8_5_, user6_.f_useState as f18_8_5_, user7_.id as id8_6_, user7_.f_account as f2_8_6_, user7_.f_createDate as f3_8_6_, user7_.f_createRole as f4_8_6_, user7_.f_createrName as f5_8_6_, user7_.f_enabled as f6_8_6_, user7_.f_institution_id as f19_8_6_, user7_.f_name as f7_8_6_, user7_.f_password as f8_8_6_, user7_.f_rights as f9_8_6_, user7_.f_role as f10_8_6_, user7_.f_role1 as f11_8_6_, user7_.f_role2 as f12_8_6_, user7_.f_role3 as f13_8_6_, user7_.f_role4 as f14_8_6_, user7_.f_stopReason as f15_8_6_, user7_.f_updateDate as f16_8_6_, user7_.f_updateName as f17_8_6_, user7_.f_useState as f18_8_6_, user8_.id as id8_7_, user8_.f_account as f2_8_7_, user8_.f_createDate as f3_8_7_, user8_.f_createRole as f4_8_7_, user8_.f_createrName as f5_8_7_, user8_.f_enabled as f6_8_7_, user8_.f_institution_id as f19_8_7_, user8_.f_name as f7_8_7_, user8_.f_password as f8_8_7_, user8_.f_rights as f9_8_7_, user8_.f_role as f10_8_7_, user8_.f_role1 as f11_8_7_, user8_.f_role2 as f12_8_7_, user8_.f_role3 as f13_8_7_, user8_.f_role4 as f14_8_7_, user8_.f_stopReason as f15_8_7_, user8_.f_updateDate as f16_8_7_, user8_.f_updateName as f17_8_7_, user8_.f_useState as f18_8_7_ from info_column infos0_ left ou
ter join infos info1_ on infos0_.infoid=info1_.id left outer join users user2_ on info1_.f_auditUser_id=user2_.id left outer join institution institutio3_ on user2_.f_institution_id=institutio3_.id left outer join users user4_ on institutio3_.f_createUser_id=user4_.id left outer join common_filed commonfile5_ on institutio3_.f_commonFiled_id=commonfile5_.id left outer join users user6_ on commonfile5_.f_user_id=user6_.id left outer join users user7_ on info1_.f_createUser_id=user7_.id left outer join users user8_ on info1_.f_updateUser_id=user8_.id where infos0_.columnid=:1 order by info1_.f_operatorDate DESC |
| dtm5a1zss0d6u | insert into servantUserInfos (f_account, f_address, f_applyAddress, f_area, f_birthday, f_cardCode, f_educationalLevel, f_englishLevel, examerIdentity, f_examineSource, f_f1, f_f2, f_f3, f_f4, f_f5, f_f6, f_f7, f_graduationDate, f_idCard, f_isSpecialExamineePost, lastClickTime, f_marriageState, f_moblePhone, f_name, f_nation, f_nationality, f_password, f_personalPhoto, f_phone, f_politicsStatus, f_post, f_postbox, f_profession, f_professionLevel, f_registeredResidence, f_remark, f_resume, f_school, f_schoolRecord, f_servantApplyInfo_id, f_sex, f_specializedField, f_studentOriginBased, f_technicaTitles, f_unit, f_unitNature, f_userId, f_workDate, workPost, f_workYear, id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51) |
| f9ruq4bngvh9f |
select examadmitp0_.id as id53_30_, examadmitp0_.f_admitNum as f2_53_30_, examadmitp0_.f_admitUnit_id as f27_53_30_, examadmitp0_.admitUnitName as admitUni3_53_30_, examadmitp0_.f_batchSet_id as f28_53_30_, examadmitp0_.f_batchSetName as f4_53_30_, examadmitp0_.f_categorySubject_id as f29_53_30_, examadmitp0_.examType as examType53_30_, examadmitp0_.hometown as hometown53_30_, examadmitp0_.maxRestrictionAge as maxRestr7_53_30_, examadmitp0_.minRestrictionAge as minRestr8_53_30_, examadmitp0_.f_otherCondition as f9_53_30_, examadmitp0_.f_physicalTest as f10_53_30_, examadmitp0_.f_postId as f11_53_30_, examadmitp0_.f_postName as f12_53_30_, examadmitp0_.f_rejectInfo as f13_53_30_, examadmitp0_.f_remark as f14_53_30_, examadmitp0_.f_repealInfo as f15_53_30_, examadmitp0_.f_reportUnit_id as f30_53_30_, examadmitp0_.reportUnitName as reportU16_53_30_, examadmitp0_.f_requireAge as f17_53_30_, examadmitp0_.f_requireEductionLevel as f18_53_30_, examadmitp0_.f_requireHometown as f19_53_30_, examadmitp0_.f_requireNation as f20_53_30_, examadmitp0_.f_requireSchoolRecord as f21_53_30_, examadmitp0_.f_requireSex as f22_53_30_, examadmitp0_.f_requireSpecialty as f23_53_30_, examadmitp0_.f_state as f24_53_30_, examadmitp0_.f_updateDate as f25_53_30_, examadmitp0_.f_updateInfo as f26_53_30_, examadmitp0_.f_user_id as f31_53_30_, institutio1_.id as id65_0_, institutio1_.f_code as f2_65_0_, institutio1_.f_content as f3_65_0_, institutio1_.f_createDate as f4_65
_0_, institutio1_.f_createUser_id as f10_65_0_, institutio1_.f_enabled as f5_65_0_, institutio1_.f_inslevel as f6_65_0_, institutio1_.f_name as f7_65_0_, institutio1_.f_commonFiled_id as f11_65_0_, institutio1_.f_sort as f8_65_0_, institutio1_.f_type as f9_65_0_, user2_.id as id8_1_, user2_.f_account as f2_8_1_, user2_.f_createDate as f3_8_1_, user2_.f_createRole as f4_8_1_, user2_.f_createrName as f5_8_1_, user2_.f_enabled as f6_8_1_, user2_.f_institution_id as f19_8_1_, user2_.f_name as f7_8_1_, user2_.f_password as f8_8_1_, user2_.f_rights as f9_8_1_, user2_.f_role as f10_8_1_, user2_.f_role1 as f11_8_1_, user2_.f_role2 as f12_8_1_, user2_.f_role3 as f13_8_1_, user2_.f_role4 as f14_8_1_, user2_.f_stopReason as f15_8_1_, user2_.f_updateDate as f16_8_1_, user2_.f_updateName as f17_8_1_, user2_.f_useState as f18_8_1_, institutio3_.id as id65_2_, institutio3_.f_code as f2_65_2_, institutio3_.f_content as f3_65_2_, institutio3_.f_createDate as f4_65_2_, institutio3_.f_createUser_id as f10_65_2_, institutio3_.f_enabled as f5_65_2_, institutio3_.f_inslevel as f6_65_2_, institutio3_.f_name as f7_65_2_, institutio3_.f_commonFiled_id as f11_65_2_, institutio3_.f_sort as f8_65_2_, institutio3_.f_type as f9_65_2_, includegra4_.unitid as unitid32_, includegra5_.id as includeid32_, includegra5_.id as id22_3_, includegra5_.f_adminNum as f2_22_3_, includegra5_.f_batchSetName as f3_22_3_, includegra5_.f_grade as f4_22_3_, includegra5_.f_includeCo
unt as f5_22_3_, includegra5_.f_postName as f6_22_3_, includegra5_.f_type as f7_22_3_, includegra5_.f_unitId as f8_22_3_, includegra5_.f_unitName as f9_22_3_, includegra5_.f_unitNature as f10_22_3_, commonfile6_.id as id72_4_, commonfile6_.f_address as f2_72_4_, commonfile6_.f_code as f3_72_4_, commonfile6_.f_name as f4_72_4_, commonfile6_.f_type as f5_72_4_, commonfile6_.f_updateDate as f6_72_4_, commonfile6_.f_user_id as f7_72_4_, user7_.id as id8_5_, user7_.f_account as f2_8_5_, user7_.f_createDate as f3_8_5_, user7_.f_createRole as f4_8_5_, user7_.f_createrName as f5_8_5_, user7_.f_enabled as f6_8_5_, user7_.f_institution_id as f19_8_5_, user7_.f_name as f7_8_5_, user7_.f_password as f8_8_5_, user7_.f_rights as f9_8_5_, user7_.f_role as f10_8_5_, user7_.f_role1 as f11_8_5_, user7_.f_role2 as f12_8_5_, user7_.f_role3 as f13_8_5_, user7_.f_role4 as f14_8_5_, user7_.f_stopReason as f15_8_5_, user7_.f_updateDate as f16_8_5_, user7_.f_updateName as f17_8_5_, user7_.f_useState as f18_8_5_, specialize8_.userid as userid33_, examspecia9_.id as speciali1_33_, examspecia9_.id as id34_6_, examspecia9_.f_audit as f2_34_6_, examspecia9_.f_begin as f3_34_6_, examspecia9_.f_code as f4_34_6_, examspecia9_.f_examLevel_id as f7_34_6_, examspecia9_.f_isApply as f5_34_6_, examspecia9_.f_name as f6_34_6_, examlevel10_.id as id42_7_, examlevel10_.f_amount as f2_42_7_, examlevel10_.f_code as f3_42_7_, examlevel10_.f_exam_id as f6_42_7_, examlevel10_.
f_name as f4_42_7_, examlevel10_.f_scroll as f5_42_7_, exam11_.id as id80_8_, exam11_.f_abbreviation as f2_80_8_, exam11_.f_applyDateEnd as f3_80_8_, exam11_.f_applyDateStart as f4_80_8_, exam11_.f_audit as f5_80_8_, exam11_.f_auditDateEnd as f6_80_8_, exam11_.f_auditDateStart as f7_80_8_, exam11_.f_code as f8_80_8_, exam11_.f_examName as f9_80_8_, exam11_.f_examYear as f10_80_8_, exam11_.f_notice as f11_80_8_, exam11_.f_operateDate as f12_80_8_, exam11_.f_payMentDateEnd as f13_80_8_, exam11_.f_payMentDateStart as f14_80_8_, exam11_.f_payType as f15_80_8_, exam11_.f_regularAmount as f16_80_8_, exam11_.f_rule as f17_80_8_, exam11_.f_type as f18_80_8_, discountpa12_.id as id92_9_, discountpa12_.f_discountRate as f2_92_9_, discountpa12_.f_discountScroll as f3_92_9_, discountpa12_.f_discountScrollRate as f4_92_9_, discountpa12_.f_discountType as f5_92_9_, discountpa12_.f_exam_id as f11_92_9_, discountpa12_.f_mode as f6_92_9_, discountpa12_.f_modeScrollValue as f7_92_9_, discountpa12_.f_modeValue as f8_92_9_, discountpa12_.f_payMentType as f9_92_9_, discountpa12_.f_scrollPayMentType as f10_92_9_, examsubjec13_.f_exam_id as f11_34_, examsubjec13_.id as id34_, examsubjec13_.id as id73_10_, examsubjec13_.f_admissionCard_id as f10_73_10_, examsubjec13_.f_amount as f2_73_10_, examsubjec13_.code as code73_10_, examsubjec13_.endTime as endTime73_10_, examsubjec13_.f_exam_id as f11_73_10_, examsubjec13_.examDate as examDate73_10_, examsubjec13_.gath
erDate as gatherDate73_10_, examsubjec13_.f_name as f7_73_10_, examsubjec13_.f_score as f8_73_10_, examsubjec13_.startTime as startTime73_10_, admissionc14_.id as id58_11_, admissionc14_.f_cardCode as f2_58_11_, admissionc14_.f_createDate as f3_58_11_, admissionc14_.f_examArea as f4_58_11_, admissionc14_.f_examLevel as f5_58_11_, admissionc14_.f_examLevelCode as f6_58_11_, admissionc14_.f_examName as f7_58_11_, admissionc14_.f_examPlaceCode as f8_58_11_, admissionc14_.f_examPoint as f9_58_11_, admissionc14_.f_examSpecialty as f10_58_11_, admissionc14_.f_examSpecialtyCode as f11_58_11_, admissionc14_.f_examSubject as f12_58_11_, admissionc14_.f_examSubjectCode as f13_58_11_, admissionc14_.f_examYear as f14_58_11_, admissionc14_.f_idCard as f15_58_11_, admissionc14_.f_seatCode as f16_58_11_, admissionc14_.f_userName as f17_58_11_, applyinfos15_.subjectid as subjectid35_, applyinfo16_.id as applyId35_, applyinfo16_.id as id25_12_, applyinfo16_.f_applyCode as f2_25_12_, applyinfo16_.f_applyDate as f3_25_12_, applyinfo16_.f_applyMode as f4_25_12_, applyinfo16_.f_applySerial as f5_25_12_, applyinfo16_.f_auditDate as f6_25_12_, applyinfo16_.f_auditName as f7_25_12_, applyinfo16_.f_auditRevocationDate as f8_25_12_, applyinfo16_.f_auditer_id as f20_25_12_, applyinfo16_.f_confirm as f9_25_12_, applyinfo16_.f_exam_id as f21_25_12_, applyinfo16_.f_examLevel_id as f22_25_12_, applyinfo16_.f_examSpecializedField_id as f23_25_12_, applyinfo16_.f_gathering
Date as f10_25_12_, applyinfo16_.f_gatheringUser_id as f24_25_12_, applyinfo16_.f_paymentAmount as f11_25_12_, applyinfo16_.f_paymentComeSerial as f12_25_12_, applyinfo16_.f_paymentDate as f13_25_12_, applyinfo16_.f_paymentMode as f14_25_12_, applyinfo16_.f_paymentOrderCode as f15_25_12_, applyinfo16_.f_rejectDate as f16_25_12_, applyinfo16_.f_rejectReason as f17_25_12_, applyinfo16_.f_state as f18_25_12_, applyinfo16_.f_stauts as f19_25_12_, user17_.id as id8_13_, user17_.f_account as f2_8_13_, user17_.f_createDate as f3_8_13_, user17_.f_createRole as f4_8_13_, user17_.f_createrName as f5_8_13_, user17_.f_enabled as f6_8_13_, user17_.f_institution_id as f19_8_13_, user17_.f_name as f7_8_13_, user17_.f_password as f8_8_13_, user17_.f_rights as f9_8_13_, user17_.f_role as f10_8_13_, user17_.f_role1 as f11_8_13_, user17_.f_role2 as f12_8_13_, user17_.f_role3 as f13_8_13_, user17_.f_role4 as f14_8_13_, user17_.f_stopReason as f15_8_13_, user17_.f_updateDate as f16_8_13_, user17_.f_updateName as f17_8_13_, user17_.f_useState as f18_8_13_, exam18_.id as id80_14_, exam18_.f_abbreviation as f2_80_14_, exam18_.f_applyDateEnd as f3_80_14_, exam18_.f_applyDateStart as f4_80_14_, exam18_.f_audit as f5_80_14_, exam18_.f_auditDateEnd as f6_80_14_, exam18_.f_auditDateStart as f7_80_14_, exam18_.f_code as f8_80_14_, exam18_.f_examName as f9_80_14_, exam18_.f_examYear as f10_80_14_, exam18_.f_notice as f11_80_14_, exam18_.f_operateDate as f12_80_14_,
exam18_.f_payMentDateEnd as f13_80_14_, exam18_.f_payMentDateStart as f14_80_14_, exam18_.f_payType as f15_80_14_, exam18_.f_regularAmount as f16_80_14_, exam18_.f_rule as f17_80_14_, exam18_.f_type as f18_80_14_, examlevel19_.id as id42_15_, examlevel19_.f_amount as f2_42_15_, examlevel19_.f_code as f3_42_15_, examlevel19_.f_exam_id as f6_42_15_, examlevel19_.f_name as f4_42_15_, examlevel19_.f_scroll as f5_42_15_, examspecia20_.id as id34_16_, examspecia20_.f_audit as f2_34_16_, examspecia20_.f_begin as f3_34_16_, examspecia20_.f_code as f4_34_16_, examspecia20_.f_examLevel_id as f7_34_16_, examspecia20_.f_isApply as f5_34_16_, examspecia20_.f_name as f6_34_16_, user21_.id as id8_17_, user21_.f_account as f2_8_17_, user21_.f_createDate as f3_8_17_, user21_.f_createRole as f4_8_17_, user21_.f_createrName as f5_8_17_, user21_.f_enabled as f6_8_17_, user21_.f_institution_id as f19_8_17_, user21_.f_name as f7_8_17_, user21_.f_password as f8_8_17_, user21_.f_rights as f9_8_17_, user21_.f_role as f10_8_17_, user21_.f_role1 as f11_8_17_, user21_.f_role2 as f12_8_17_, user21_.f_role3 as f13_8_17_, user21_.f_role4 as f14_8_17_, user21_.f_stopReason as f15_8_17_, user21_.f_updateDate as f16_8_17_, user21_.f_updateName as f17_8_17_, user21_.f_useState as f18_8_17_, regristuse22_.id as id82_18_, regristuse22_.f_account as f2_82_18_, regristuse22_.f_address as f3_82_18_, regristuse22_.f_applyAddress as f4_82_18_, regristuse22_.f_applyInfo_id as
f37_82_18_, regristuse22_.f_area as f5_82_18_, regristuse22_.f_birthday as f6_82_18_, regristuse22_.f_educationalLevel as f7_82_18_, regristuse22_.f_englishLevel as f8_82_18_, regristuse22_.f_examineeFile as f9_82_18_, regristuse22_.f_graduationDate as f10_82_18_, regristuse22_.f_idCard as f11_82_18_, regristuse22_.f_marriageState as f12_82_18_, regristuse22_.f_moblePhone as f13_82_18_, regristuse22_.f_name as f14_82_18_, regristuse22_.f_nationality as f15_82_18_, regristuse22_.f_password as f16_82_18_, regristuse22_.f_personalPhoto as f17_82_18_, regristuse22_.f_phone as f18_82_18_, regristuse22_.f_politicsStatus as f19_82_18_, regristuse22_.f_post as f20_82_18_, regristuse22_.f_postStuation as f21_82_18_, regristuse22_.f_postbox as f22_82_18_, regristuse22_.f_profession as f23_82_18_, regristuse22_.f_professionLevel as f24_82_18_, regristuse22_.f_registeredResidence as f25_82_18_, regristuse22_.f_school as f26_82_18_, regristuse22_.f_schoolRecord as f27_82_18_, regristuse22_.f_sex as f28_82_18_, regristuse22_.f_source as f29_82_18_, regristuse22_.f_specializedField as f30_82_18_, regristuse22_.f_technicaTitles as f31_82_18_, regristuse22_.f_unit as f32_82_18_, regristuse22_.f_unitNature as f33_82_18_, regristuse22_.f_userId as f34_82_18_, regristuse22_.f_workDate as f35_82_18_, regristuse22_.f_workYear as f36_82_18_, writeachie23_.unitid as unitid36_, writeachie24_.id as waid36_, writeachie24_.id as id69_19_, writeachie24_.f_batchSetName
as f2_69_19_, writeachie24_.f_policy as f3_69_19_, writeachie24_.f_scale as f4_69_19_, writeachie24_.suitType as suitType69_19_, condtions25_.f_writeAchievementBonusPoint as f7_37_, condtions25_.id as id37_, condtions25_.id as id57_20_, condtions25_.f_batchName as f2_57_20_, condtions25_.f_condtion as f3_57_20_, condtions25_.f_relation as f4_57_20_, condtions25_.f_scale as f5_57_20_, condtions25_.f_value as f6_57_20_, condtions25_.f_writeAchievementBonusPoint as f7_57_20_, batchset26_.id as id26_21_, batchset26_.f_applyEndDate as f2_26_21_, batchset26_.f_applyStartDate as f3_26_21_, batchset26_.f_cardCode as f4_26_21_, batchset26_.f_cardNotice as f5_26_21_, batchset26_.f_chargeType as f6_26_21_, batchset26_.f_examDate as f7_26_21_, batchset26_.f_musterName as f8_26_21_, batchset26_.f_name as f9_26_21_, batchset26_.f_paymentEndDate as f10_26_21_, batchset26_.f_paymentStartDate as f11_26_21_, batchset26_.f_publicApplyCount as f12_26_21_, batchset26_.f_publicAuditCount as f13_26_21_, batchset26_.f_publicPaymentCount as f14_26_21_, batchset26_.f_state as f15_26_21_, batchset26_.f_studentNotice as f16_26_21_, batchset26_.f_tableName as f17_26_21_, batchset26_.f_timelagDate as f18_26_21_, batchset26_.f_type as f19_26_21_, batchset26_.f_unitePrice as f20_26_21_, batchset26_.f_updateDate as f21_26_21_, batchset26_.f_updateName as f22_26_21_, categorych27_.f_batchSet_id as f4_38_, categorych27_.id as id38_, categorych27_.id as id43_22_, categoryc
h27_.f_amount as f2_43_22_, categorych27_.f_batchSet_id as f4_43_22_, categorych27_.f_name as f3_43_22_, logs28_.f_batchSet_id as f4_39_, logs28_.id as id39_, logs28_.id as id95_23_, logs28_.f_batchSet_id as f4_95_23_, logs28_.f_operatorDate as f2_95_23_, logs28_.f_userName as f3_95_23_, paycheckqu29_.id as id2_24_, paycheckqu29_.f_batchSetname as f3_2_24_, paycheckqu29_.state as state2_24_, categorysu30_.id as id101_25_, categorysu30_.f_name as f2_101_25_, categorysu30_.f_summary as f3_101_25_, categorysu30_.f_type as f4_101_25_, categorysu30_.f_typeCode as f5_101_25_, categorysu30_.f_typename as f6_101_25_, categorysu30_.f_updateDate as f7_101_25_, categorysu30_.f_user_id as f8_101_25_, user31_.id as id8_26_, user31_.f_account as f2_8_26_, user31_.f_createDate as f3_8_26_, user31_.f_createRole as f4_8_26_, user31_.f_createrName as f5_8_26_, user31_.f_enabled as f6_8_26_, user31_.f_institution_id as f19_8_26_, user31_.f_name as f7_8_26_, user31_.f_password as f8_8_26_, user31_.f_rights as f9_8_26_, user31_.f_role as f10_8_26_, user31_.f_role1 as f11_8_26_, user31_.f_role2 as f12_8_26_, user31_.f_role3 as f13_8_26_, user31_.f_role4 as f14_8_26_, user31_.f_stopReason as f15_8_26_, user31_.f_updateDate as f16_8_26_, user31_.f_updateName as f17_8_26_, user31_.f_useState as f18_8_26_, institutio32_.id as id65_27_, institutio32_.f_code as f2_65_27_, institutio32_.f_content as f3_65_27_, institutio32_.f_createDate as f4_65_27_, institutio3
2_.f_createUser_id as f10_65_27_, institutio32_.f_enabled as f5_65_27_, institutio32_.f_inslevel as f6_65_27_, institutio32_.f_name as f7_65_27_, institutio32_.f_commonFiled_id as f11_65_27_, institutio32_.f_sort as f8_65_27_, institutio32_.f_type as f9_65_27_, user33_.id as id8_28_, user33_.f_account as f2_8_28_, user33_.f_createDate as f3_8_28_, user33_.f_createRole as f4_8_28_, user33_.f_createrName as f5_8_28_, user33_.f_enabled as f6_8_28_, user33_.f_institution_id as f19_8_28_, user33_.f_name as f7_8_28_, user33_.f_password as f8_8_28_, user33_.f_rights as f9_8_28_, user33_.f_role as f10_8_28_, user33_.f_role1 as f11_8_28_, user33_.f_role2 as f12_8_28_, user33_.f_role3 as f13_8_28_, user33_.f_role4 as f14_8_28_, user33_.f_stopReason as f15_8_28_, user33_.f_updateDate as f16_8_28_, user33_.f_updateName as f17_8_28_, user33_.f_useState as f18_8_28_, ispublishe34_.id as id33_29_, ispublishe34_.batchName as batchName33_29_, ispublishe34_.examadmitplan_id as examadmi6_33_29_, ispublishe34_.isPublish as isPublish33_29_, ispublishe34_.updateDate as updateDate33_29_, ispublishe34_.updateUser as updateUser33_29_ from examAdmitPlan examadmitp0_ left outer join institution institutio1_ on examadmitp0_.f_admitUnit_id=institutio1_.id left outer join users user2_ on institutio1_.f_createUser_id=user2_.id left outer join institution institutio3_ on user2_.f_institution_id=institutio3_.id left outer join include_grade_unit includegra4_ on institutio3_.id=
includegra4_.unitid left outer join include_grade_set includegra5_ on includegra4_.includeid=includegra5_.id left outer join common_filed commonfile6_ on institutio3_.f_commonFiled_id=commonfile6_.id left outer join users user7_ on commonfile6_.f_user_id=user7_.id left outer join specializedField_auditer specialize8_ on user7_.id=specialize8_.userid left outer join exam_specializedField examspecia9_ on specialize8_.specializedField=examspecia9_.id left outer join exam_level examlevel10_ on examspecia9_.f_examLevel_id=examlevel10_.id left outer join exams exam11_ on examlevel10_.f_exam_id=exam11_.id left outer join discount_payment discountpa12_ on exam11_.id=discountpa12_.f_exam_id left outer join exam_subject examsubjec13_ on examspecia9_.id=examsubjec13_.f_exam_id left outer join adminssion_card admissionc14_ on examsubjec13_.f_admissionCard_id=admissionc14_.id left outer join applyInfo_exsubject applyinfos15_ on examsubjec13_.id=applyinfos15_.subjectid left outer join apply_info applyinfo16_ on applyinfos15_.applyId=applyinfo16_.id left outer join users user17_ on applyinfo16_.f_auditer_id=user17_.id left outer join exams exam18_ on applyinfo16_.f_exam_id=exam18_.id left outer join exam_level examlevel19_ on applyinfo16_.f_examLevel_id=examlevel19_.id left outer join exam_specializedField examspecia20_ on applyinfo16_.f_examSpecializedField_id=examspecia20_.id left outer join users user21_ on applyinfo16_.f_gatheringUser_id=user21_.id left outer join user_apply_info regris
tuse22_ on applyinfo16_.id=regristuse22_.f_applyInfo_id left outer join BonusPoint_unit writeachie23_ on institutio3_.id=writeachie23_.unitid left outer join write_Achie_BPoint writeachie24_ on writeachie23_.waid=writeachie24_.id left outer join write_Achie_BPoint_condition condtions25_ on writeachie24_.id=condtions25_.f_writeAchievementBonusPoint left outer join batchSet batchset26_ on examadmitp0_.f_batchSet_id=batchset26_.id left outer join category_charge categorych27_ on batchset26_.id=categorych27_.f_batchSet_id left outer join batchSet_log logs28_ on batchset26_.id=logs28_.f_batchSet_id left outer join PayCheckQuartz paycheckqu29_ on batchset26_.id=paycheckqu29_.f_batchSetname left outer join category_subject categorysu30_ on examadmitp0_.f_categorySubject_id=categorysu30_.id left outer join users user31_ on categorysu30_.f_user_id=user31_.id left outer join institution institutio32_ on examadmitp0_.f_reportUnit_id=institutio32_.id left outer join users user33_ on examadmitp0_.f_user_id=user33_.id left outer join IsPublishExamAdmitPlan ispublishe34_ on examadmitp0_.id=ispublishe34_.examadmitplan_id where examadmitp0_.id=:1 order by examsubjec13_.id ASC |
| gb179fbpsjqdw |
select kinrelatio0_.f_regristeUser_id as f6_16_, kinrelatio0_.id as id16_, kinrelatio0_.id as id40_15_, kinrelatio0_.f_name as f2_40_15_, kinrelatio0_.f_post as f3_40_15_, kinrelatio0_.f_regristeUser_id as f6_40_15_, kinrelatio0_.f_relation as f4_40_15_, kinrelatio0_.f_servantUserInfo_id as f7_40_15_, kinrelatio0_.f_unit as f5_40_15_, servantuse1_.id as id98_0_, servantuse1_.f_account as f2_98_0_, servantuse1_.f_address as f3_98_0_, servantuse1_.f_applyAddress as f4_98_0_, servantuse1_.f_area as f5_98_0_, servantuse1_.f_birthday as f6_98_0_, servantuse1_.f_cardCode as f7_98_0_, servantuse1_.f_educationalLevel as f8_98_0_, servantuse1_.f_englishLevel as f9_98_0_, servantuse1_.examerIdentity as examerI10_98_0_, servantuse1_.f_examineSource as f11_98_0_, servantuse1_.f_f1 as f12_98_0_, servantuse1_.f_f2 as f13_98_0_, servantuse1_.f_f3 as f14_98_0_, servantuse1_.f_f4 as f15_98_0_, servantuse1_.f_f5 as f16_98_0_, servantuse1_.f_f6 as f17_98_0_, servantuse1_.f_f7 as f18_98_0_, servantuse1_.f_graduationDate as f19_98_0_, servantuse1_.f_idCard as f20_98_0_, servantuse1_.f_isSpecialExamineePost as f21_98_0_, servantuse1_.lastClickTime as lastCli22_98_0_, servantuse1_.f_marriageState as f23_98_0_, servantuse1_.f_moblePhone as f24_98_0_, servantuse1_.f_name as f25_98_0_, servantuse1_.f_nation as f26_98_0_, servantuse1_.f_nationality as f27_98_0_, servantuse1_.f_password as f28_98_0_, servantuse1_.f_personalPhoto as f29_98_0_, servantuse1_.f_phone as
f30_98_0_, servantuse1_.f_politicsStatus as f31_98_0_, servantuse1_.f_post as f32_98_0_, servantuse1_.f_postbox as f33_98_0_, servantuse1_.f_profession as f34_98_0_, servantuse1_.f_professionLevel as f35_98_0_, servantuse1_.f_registeredResidence as f36_98_0_, servantuse1_.f_remark as f37_98_0_, servantuse1_.f_resume as f38_98_0_, servantuse1_.f_school as f39_98_0_, servantuse1_.f_schoolRecord as f40_98_0_, servantuse1_.f_servantApplyInfo_id as f51_98_0_, servantuse1_.f_sex as f41_98_0_, servantuse1_.f_specializedField as f42_98_0_, servantuse1_.f_studentOriginBased as f43_98_0_, servantuse1_.f_technicaTitles as f44_98_0_, servantuse1_.f_unit as f45_98_0_, servantuse1_.f_unitNature as f46_98_0_, servantuse1_.f_userId as f47_98_0_, servantuse1_.f_workDate as f48_98_0_, servantuse1_.workPost as workPost98_0_, servantuse1_.f_workYear as f50_98_0_, servantapp2_.id as id49_1_, servantapp2_.f_applyCode as f2_49_1_, servantapp2_.f_applyDate as f3_49_1_, servantapp2_.f_auditDate as f4_49_1_, servantapp2_.f_examAdmitPlan_id as f13_49_1_, servantapp2_.f_examerStiation as f5_49_1_, servantapp2_.f_paymentState as f6_49_1_, servantapp2_.f_reapply as f7_49_1_, servantapp2_.f_rejectReason as f8_49_1_, servantapp2_.f_revocationDate as f9_49_1_, servantapp2_.f_revocationName as f10_49_1_, servantapp2_.f_revocationReason as f11_49_1_, servantapp2_.f_state as f12_49_1_, examadmitp3_.id as id87_2_, examadmitp3_.f_admitNum as f2_87_2_, examadmitp3_.f_admitUnit
_id as f27_87_2_, examadmitp3_.admitUnitName as admitUni3_87_2_, examadmitp3_.f_batchSet_id as f28_87_2_, examadmitp3_.f_batchSetName as f4_87_2_, examadmitp3_.f_categorySubject_id as f29_87_2_, examadmitp3_.examType as examType87_2_, examadmitp3_.hometown as hometown87_2_, examadmitp3_.maxRestrictionAge as maxRestr7_87_2_, examadmitp3_.minRestrictionAge as minRestr8_87_2_, examadmitp3_.f_otherCondition as f9_87_2_, examadmitp3_.f_physicalTest as f10_87_2_, examadmitp3_.f_postId as f11_87_2_, examadmitp3_.f_postName as f12_87_2_, examadmitp3_.f_rejectInfo as f13_87_2_, examadmitp3_.f_remark as f14_87_2_, examadmitp3_.f_repealInfo as f15_87_2_, examadmitp3_.f_reportUnit_id as f30_87_2_, examadmitp3_.reportUnitName as reportU16_87_2_, examadmitp3_.f_requireAge as f17_87_2_, examadmitp3_.f_requireEductionLevel as f18_87_2_, examadmitp3_.f_requireHometown as f19_87_2_, examadmitp3_.f_requireNation as f20_87_2_, examadmitp3_.f_requireSchoolRecord as f21_87_2_, examadmitp3_.f_requireSex as f22_87_2_, examadmitp3_.f_requireSpecialty as f23_87_2_, examadmitp3_.f_state as f24_87_2_, examadmitp3_.f_updateDate as f25_87_2_, examadmitp3_.f_updateInfo as f26_87_2_, examadmitp3_.f_user_id as f31_87_2_, institutio4_.id as id42_3_, institutio4_.f_code as f2_42_3_, institutio4_.f_content as f3_42_3_, institutio4_.f_createDate as f4_42_3_, institutio4_.f_createUser_id as f10_42_3_, institutio4_.f_enabled as f5_42_3_, institutio4_.f_inslevel as f6_42_3_, inst
itutio4_.f_name as f7_42_3_, institutio4_.f_commonFiled_id as f11_42_3_, institutio4_.f_sort as f8_42_3_, institutio4_.f_type as f9_42_3_, user5_.id as id70_4_, user5_.f_account as f2_70_4_, user5_.f_createDate as f3_70_4_, user5_.f_createRole as f4_70_4_, user5_.f_createrName as f5_70_4_, user5_.f_enabled as f6_70_4_, user5_.f_institution_id as f19_70_4_, user5_.f_name as f7_70_4_, user5_.f_password as f8_70_4_, user5_.f_rights as f9_70_4_, user5_.f_role as f10_70_4_, user5_.f_role1 as f11_70_4_, user5_.f_role2 as f12_70_4_, user5_.f_role3 as f13_70_4_, user5_.f_role4 as f14_70_4_, user5_.f_stopReason as f15_70_4_, user5_.f_updateDate as f16_70_4_, user5_.f_updateName as f17_70_4_, user5_.f_useState as f18_70_4_, institutio6_.id as id42_5_, institutio6_.f_code as f2_42_5_, institutio6_.f_content as f3_42_5_, institutio6_.f_createDate as f4_42_5_, institutio6_.f_createUser_id as f10_42_5_, institutio6_.f_enabled as f5_42_5_, institutio6_.f_inslevel as f6_42_5_, institutio6_.f_name as f7_42_5_, institutio6_.f_commonFiled_id as f11_42_5_, institutio6_.f_sort as f8_42_5_, institutio6_.f_type as f9_42_5_, commonfile7_.id as id75_6_, commonfile7_.f_address as f2_75_6_, commonfile7_.f_code as f3_75_6_, commonfile7_.f_name as f4_75_6_, commonfile7_.f_type as f5_75_6_, commonfile7_.f_updateDate as f6_75_6_, commonfile7_.f_user_id as f7_75_6_, user8_.id as id70_7_, user8_.f_account as f2_70_7_, user8_.f_createDate as f3_70_7_, user8_.f_creat
eRole as f4_70_7_, user8_.f_createrName as f5_70_7_, user8_.f_enabled as f6_70_7_, user8_.f_institution_id as f19_70_7_, user8_.f_name as f7_70_7_, user8_.f_password as f8_70_7_, user8_.f_rights as f9_70_7_, user8_.f_role as f10_70_7_, user8_.f_role1 as f11_70_7_, user8_.f_role2 as f12_70_7_, user8_.f_role3 as f13_70_7_, user8_.f_role4 as f14_70_7_, user8_.f_stopReason as f15_70_7_, user8_.f_updateDate as f16_70_7_, user8_.f_updateName as f17_70_7_, user8_.f_useState as f18_70_7_, batchset9_.id as id50_8_, batchset9_.f_applyEndDate as f2_50_8_, batchset9_.f_applyStartDate as f3_50_8_, batchset9_.f_cardCode as f4_50_8_, batchset9_.f_cardNotice as f5_50_8_, batchset9_.f_chargeType as f6_50_8_, batchset9_.f_examDate as f7_50_8_, batchset9_.f_musterName as f8_50_8_, batchset9_.f_name as f9_50_8_, batchset9_.f_paymentEndDate as f10_50_8_, batchset9_.f_paymentStartDate as f11_50_8_, batchset9_.f_publicApplyCount as f12_50_8_, batchset9_.f_publicAuditCount as f13_50_8_, batchset9_.f_publicPaymentCount as f14_50_8_, batchset9_.f_state as f15_50_8_, batchset9_.f_studentNotice as f16_50_8_, batchset9_.f_tableName as f17_50_8_, batchset9_.f_timelagDate as f18_50_8_, batchset9_.f_type as f19_50_8_, batchset9_.f_unitePrice as f20_50_8_, batchset9_.f_updateDate as f21_50_8_, batchset9_.f_updateName as f22_50_8_, paycheckqu10_.id as id72_9_, paycheckqu10_.f_batchSetname as f3_72_9_, paycheckqu10_.state as state72_9_, categorysu11_.id as id111_10_, c
ategorysu11_.f_name as f2_111_10_, categorysu11_.f_summary as f3_111_10_, categorysu11_.f_type as f4_111_10_, categorysu11_.f_typeCode as f5_111_10_, categorysu11_.f_typename as f6_111_10_, categorysu11_.f_updateDate as f7_111_10_, categorysu11_.f_user_id as f8_111_10_, user12_.id as id70_11_, user12_.f_account as f2_70_11_, user12_.f_createDate as f3_70_11_, user12_.f_createRole as f4_70_11_, user12_.f_createrName as f5_70_11_, user12_.f_enabled as f6_70_11_, user12_.f_institution_id as f19_70_11_, user12_.f_name as f7_70_11_, user12_.f_password as f8_70_11_, user12_.f_rights as f9_70_11_, user12_.f_role as f10_70_11_, user12_.f_role1 as f11_70_11_, user12_.f_role2 as f12_70_11_, user12_.f_role3 as f13_70_11_, user12_.f_role4 as f14_70_11_, user12_.f_stopReason as f15_70_11_, user12_.f_updateDate as f16_70_11_, user12_.f_updateName as f17_70_11_, user12_.f_useState as f18_70_11_, institutio13_.id as id42_12_, institutio13_.f_code as f2_42_12_, institutio13_.f_content as f3_42_12_, institutio13_.f_createDate as f4_42_12_, institutio13_.f_createUser_id as f10_42_12_, institutio13_.f_enabled as f5_42_12_, institutio13_.f_inslevel as f6_42_12_, institutio13_.f_name as f7_42_12_, institutio13_.f_commonFiled_id as f11_42_12_, institutio13_.f_sort as f8_42_12_, institutio13_.f_type as f9_42_12_, user14_.id as id70_13_, user14_.f_account as f2_70_13_, user14_.f_createDate as f3_70_13_, user14_.f_createRole as f4_70_13_, user14_.f_createrName
as f5_70_13_, user14_.f_enabled as f6_70_13_, user14_.f_institution_id as f19_70_13_, user14_.f_name as f7_70_13_, user14_.f_password as f8_70_13_, user14_.f_rights as f9_70_13_, user14_.f_role as f10_70_13_, user14_.f_role1 as f11_70_13_, user14_.f_role2 as f12_70_13_, user14_.f_role3 as f13_70_13_, user14_.f_role4 as f14_70_13_, user14_.f_stopReason as f15_70_13_, user14_.f_updateDate as f16_70_13_, user14_.f_updateName as f17_70_13_, user14_.f_useState as f18_70_13_, ispublishe15_.id as id8_14_, ispublishe15_.batchName as batchName8_14_, ispublishe15_.examadmitplan_id as examadmi6_8_14_, ispublishe15_.isPublish as isPublish8_14_, ispublishe15_.updateDate as updateDate8_14_, ispublishe15_.updateUser as updateUser8_14_ from kinRelations kinrelatio0_ left outer join servantUserInfos servantuse1_ on kinrelatio0_.f_servantUserInfo_id=servantuse1_.id left outer join servantApplyInfos servantapp2_ on servantuse1_.f_servantApplyInfo_id=servantapp2_.id left outer join examAdmitPlan examadmitp3_ on servantapp2_.f_examAdmitPlan_id=examadmitp3_.id left outer join institution institutio4_ on examadmitp3_.f_admitUnit_id=institutio4_.id left outer join users user5_ on institutio4_.f_createUser_id=user5_.id left outer join institution institutio6_ on user5_.f_institution_id=institutio6_.id left outer join common_filed commonfile7_ on institutio6_.f_commonFiled_id=commonfile7_.id left outer join users user8_ on commonfile7_.f_user_id=user8_.id left outer join batchSet b
atchset9_ on examadmitp3_.f_batchSet_id=batchset9_.id left outer join PayCheckQuartz paycheckqu10_ on batchset9_.id=paycheckqu10_.f_batchSetname left outer join category_subject categorysu11_ on examadmitp3_.f_categorySubject_id=categorysu11_.id left outer join users user12_ on categorysu11_.f_user_id=user12_.id left outer join institution institutio13_ on examadmitp3_.f_reportUnit_id=institutio13_.id left outer join users user14_ on examadmitp3_.f_user_id=user14_.id left outer join IsPublishExamAdmitPlan ispublishe15_ on examadmitp3_.id=ispublishe15_.examadmitplan_id where kinrelatio0_.f_regristeUser_id=:1 |