SELECT t0.table1_C5 AS table1_C5,
		t0.table1_B5 AS table1_B5,
		t0.table1_D5 AS table1_D5,
		t0.table1_E5 AS table1_E5,
		t0.table1_F5 AS table1_F5,
		t0.table1_G5 AS table1_G5,
		t0.table1_H5 AS table1_H5,
		t0.table1_I5 AS table1_I5,
		t0.table1_J5 AS table1_J5,
		t0.table1_K5 AS table1_K5,
		t0.table1_L5 AS table1_L5,
		t0.table1_M5 AS table1_M5,
		t0.table1_N5 AS table1_N5,
		t0.table1_O5 AS table1_O5,
		t0.table1_P5 AS table1_P5,
		t0.table1_Q5 AS table1_Q5,
		t0.table1_R5 AS table1_R5,
		t0.table1_S5 AS table1_S5,
		t0.table1_T5 AS table1_T5,
		t0.table1_U5 AS table1_U5,
		t0.table1_V5 AS table1_V5,
		t0.table1_W5 AS table1_W5,
		t0.table1_X5 AS table1_X5,
		t0.table1_Y5 AS table1_Y5,
		t0.table1_Z5 AS table1_Z5,
		t0.table1_AA5 AS table1_AA5,
		t0.table1_AB5 AS table1_AB5,
		t0.table1_AC5 AS table1_AC5,
		t0.table1_AD5 AS table1_AD5,
		t0.table1_AE5 AS table1_AE5,
		t0.table1_AF5 AS table1_AF5,
		t0.table1_AG5 AS table1_AG5,
		t0.table1_AH5 AS table1_AH5,
		t0.table1_AI5 AS table1_AI5,
		t0.table1_AJ5 AS table1_AJ5,
		t0.table1_AK5 AS table1_AK5,
		t0.table1_AL5 AS table1_AL5,
		t0.table1_AM5 AS table1_AM5,
		t0.table1_AN5 AS table1_AN5,
		t0.table1_AO5 AS table1_AO5,
		t0.table1_AP5 AS table1_AP5,
		t0.table1_AQ5 AS table1_AQ5,
		t0.table1_AR5 AS table1_AR5,
		t0.table1_AS5 AS table1_AS5,
		t0.table1_AT5 AS table1_AT5,
		t0.table1_AU5 AS table1_AU5,
		t0.table1_AV5 AS table1_AV5,
		t0.table1_AW5 AS table1_AW5,
		t0.table1_AX5 AS table1_AX5,
		t0.table1_AY5 AS table1_AY5,
		t0.table1_AZ5 AS table1_AZ5,
		t0.table1_BA5 AS table1_BA5,
		t0.table1_BB5 AS table1_BB5,
		t0.table1_BC5 AS table1_BC5,
		t0.table1_BD5 AS table1_BD5,
		t0.table1_BE5 AS table1_BE5,
		t0.table1_BF5 AS table1_BF5,
		t0.table1_BG5 AS table1_BG5,
		t0.table1_BH5 AS table1_BH5,
		t0.table1_BI5 AS table1_BI5,
		t0.table1_BJ5 AS table1_BJ5,
		t0.table1_BK5 AS table1_BK5,
		t0.table1_BL5 AS table1_BL5,
		t0.table1_BM5 AS table1_BM5,
		t0.table1_BN5 AS table1_BN5,
		t0.table1_BO5 AS table1_BO5,
		t0.table1_BP5 AS table1_BP5,
		t0.table1_BQ5 AS table1_BQ5,
		t0.table1_BR5 AS table1_BR5,
		t0.table1_BS5 AS table1_BS5,
		t0.table1_BT5 AS table1_BT5,
		t0.table1_BU5 AS table1_BU5,
		t0.table1_BV5 AS table1_BV5,
		t0.table1_BW5 AS table1_BW5,
		t0.table1_BX5 AS table1_BX5,
		t0.table1_BY5 AS table1_BY5,
		t0.table1_BZ5 AS table1_BZ5,
		t0.table1_CA5 AS table1_CA5,
		t0.table1_CB5 AS table1_CB5,
		t0.table1_CC5 AS table1_CC5,
		t0.table1_CD5 AS table1_CD5,
		t0.table1_CE5 AS table1_CE5,
		t0.table1_CF5 AS table1_CF5,
		t0.table1_CG5 AS table1_CG5,
		t0.table1_CH5 AS table1_CH5,
		t0.table1_CI5 AS table1_CI5,
		t0.table1_CJ5 AS table1_CJ5,
		t0.table1_CK5 AS table1_CK5,
		t0.table1_CL5 AS table1_CL5,
		t0.table1_CM5 AS table1_CM5,
		t0.table1_CN5 AS table1_CN5,
		t0.table1_CO5 AS table1_CO5,
		t0.table1_CP5 AS table1_CP5,
		t0.table1_CQ5 AS table1_CQ5,
		t0.table1_CR5 AS table1_CR5,
		t0.table1_CS5 AS table1_CS5,
		t0.table1_CT5 AS table1_CT5,
		t0.table1_CU5 AS table1_CU5,
		t0.table1_CV5 AS table1_CV5,
		t0.table1_CW5 AS table1_CW5,
		t0.table1_CX5 AS table1_CX5,
		t0.table1_CY5 AS table1_CY5,
		t0.table1_CZ5 AS table1_CZ5,
		t0.table1_DA5 AS table1_DA5,
		t0.table1_DB5 AS table1_DB5,
		t0.table1_DC5 AS table1_DC5,
		t0.table1_DD5 AS table1_DD5,
		t0.table1_DE5 AS table1_DE5,
		t0.table1_DF5 AS table1_DF5,
		t0.table1_DG5 AS table1_DG5,
		t0.table1_DH5 AS table1_DH5,
		t0.table1_DI5 AS table1_DI5,
		t0.table1_DJ5 AS table1_DJ5,
		t0.table1_DK5 AS table1_DK5,
		t0.table1_DL5 AS table1_DL5,
		t0.table1_DM5 AS table1_DM5,
		t0.table1_DN5 AS table1_DN5,
		t0.table1_DO5 AS table1_DO5,
		t0.table1_DP5 AS table1_DP5,
		t0.table1_DQ5 AS table1_DQ5,
		t0.table1_DR5 AS table1_DR5,
		t0.table1_DS5 AS table1_DS5,
		t0.table1_DT5 AS table1_DT5,
		t0.table1_DU5 AS table1_DU5,
		t0.table1_DV5 AS table1_DV5,
		t0.table1_DW5 AS table1_DW5,
		t0.table1_DX5 AS table1_DX5,
		t0.table1_DY5 AS table1_DY5,
		t0.table1_DZ5 AS table1_DZ5,
		t0.table1_EA5 AS table1_EA5,
		t0.table1_EB5 AS table1_EB5,
		t0.table1_EC5 AS table1_EC5,
		t0.table1_ED5 AS table1_ED5,
		t0.table1_EE5 AS table1_EE5,
		t0.table1_EF5 AS table1_EF5,
		t0.table1_EG5 AS table1_EG5,
		t0.table1_EH5 AS table1_EH5,
		t0.table1_EI5 AS table1_EI5,
		t0.table1_EJ5 AS table1_EJ5,
		t0.table1_EK5 AS table1_EK5,
		t0.table1_EL5 AS table1_EL5,
		t0.table1_EM5 AS table1_EM5,
		t0.table1_EN5 AS table1_EN5,
		t0.table1_EO5 AS table1_EO5,
		t0.table1_EP5 AS table1_EP5,
		t0.table1_EQ5 AS table1_EQ5,
		t0.table1_ER5 AS table1_ER5,
		t0.table1_ES5 AS table1_ES5,
		t0.table1_ET5 AS table1_ET5,
		t0.table1_EU5 AS table1_EU5,
		t0.table1_EV5 AS table1_EV5,
		t0.table1_EW5 AS table1_EW5,
		t0.table1_EX5 AS table1_EX5,
		t0.table1_EY5 AS table1_EY5,
		t0.table1_EZ5 AS table1_EZ5,
		t0.table1_FA5 AS table1_FA5,
		t0.table1_FB5 AS table1_FB5,
		t0.table1_FC5 AS table1_FC5,
		t0.table1_FD5 AS table1_FD5,
		t0.table1_FE5 AS table1_FE5,
		t0.table1_FF5 AS table1_FF5,
		t0.table1_FG5 AS table1_FG5,
		t0.table1_FH5 AS table1_FH5,
		t0.table1_FI5 AS table1_FI5,
		t0.table1_FJ5 AS table1_FJ5,
		t0.table1_FK5 AS table1_FK5,
		t0.table1_FL5 AS table1_FL5,
		t0.table1_FM5 AS table1_FM5,
		t0.table1_FN5 AS table1_FN5,
		t0.table1_FO5 AS table1_FO5,
		t0.table1_FP5 AS table1_FP5,
		t0.table1_FQ5 AS table1_FQ5,
		t0.table1_FR5 AS table1_FR5,
		t0.table1_FS5 AS table1_FS5,
		t0.table1_FT5 AS table1_FT5,
		t0.table1_FU5 AS table1_FU5,
		t0.table1_FV5 AS table1_FV5,
		t0.table1_C5_DSC AS table1_C5_DSC,
		t0.table1_D5_DSC AS table1_D5_DSC,
		concat(t0.table1_B5, '年') AS table1_B5_DSC,
		t1.CAPTION AS table1_G5_DSC,
		t2.CAPTION AS table1_H5_DSC,
		t3.CAPTION AS table1_I5_DSC,
		t4.CAPTION AS table1_J5_DSC,
		t5.CAPTION AS table1_K5_DSC,
		t6.CAPTION AS table1_L5_DSC,
		t7.CAPTION AS table1_M5_DSC,
		t8.CAPTION AS table1_N5_DSC,
		t9.CAPTION AS table1_O5_DSC,
		t10.CAPTION AS table1_P5_DSC,
		t11.CAPTION AS table1_X5_DSC,
		t12.CAPTION AS table1_Z5_DSC,
		t13.CAPTION AS table1_AA5_DSC,
		t14.CAPTION AS table1_AC5_DSC,
		t15.CAPTION AS table1_AG5_DSC,
		t16.CAPTION AS table1_AH5_DSC,
		t17.CAPTION AS table1_AI5_DSC,
		t18.CAPTION AS table1_AK5_DSC,
		t19.CAPTION AS table1_AL5_DSC,
		t20.CAPTION AS table1_AM5_DSC,
		t21.CAPTION AS table1_AN5_DSC,
		t22.CAPTION AS table1_AO5_DSC,
		t23.CAPTION AS table1_AP5_DSC,
		t24.CAPTION AS table1_AQ5_DSC,
		t25.CAPTION AS table1_AR5_DSC,
		t26.CAPTION AS table1_AS5_DSC,
		t27.CAPTION AS table1_AT5_DSC,
		t28.CAPTION AS table1_AU5_DSC,
		t29.CAPTION AS table1_AV5_DSC
FROM
	(SELECT t0.table1_C5 AS table1_C5,
		max(t0.table1_B5) AS table1_B5,
		max(t0.table1_D5) AS table1_D5,
		max(t0.table1_E5) AS table1_E5,
		max(t0.table1_F5) AS table1_F5,
		max(t0.table1_G5) AS table1_G5,
		max(t0.table1_H5) AS table1_H5,
		max(t0.table1_I5) AS table1_I5,
		max(t0.table1_J5) AS table1_J5,
		max(t0.table1_K5) AS table1_K5,
		max(t0.table1_L5) AS table1_L5,
		max(t0.table1_M5) AS table1_M5,
		max(t0.table1_N5) AS table1_N5,
		max(t0.table1_O5) AS table1_O5,
		max(t0.table1_P5) AS table1_P5,
		max(t0.table1_Q5) AS table1_Q5,
		max(t0.table1_R5) AS table1_R5,
		max(t0.table1_S5) AS table1_S5,
		max(t0.table1_T5) AS table1_T5,
		max(t0.table1_U5) AS table1_U5,
		max(t0.table1_V5) AS table1_V5,
		max(t0.table1_W5) AS table1_W5,
		max(t0.table1_X5) AS table1_X5,
		max(t0.table1_Y5) AS table1_Y5,
		max(t0.table1_Z5) AS table1_Z5,
		max(t0.table1_AA5) AS table1_AA5,
		sum(t0.table1_AB5) AS table1_AB5,
		max(t0.table1_AC5) AS table1_AC5,
		sum(t0.table1_AD5) AS table1_AD5,
		sum(t0.table1_AE5) AS table1_AE5,
		sum(t0.table1_AF5) AS table1_AF5,
		max(t0.table1_AG5) AS table1_AG5,
		max(t0.table1_AH5) AS table1_AH5,
		max(t0.table1_AI5) AS table1_AI5,
		max(t0.table1_AJ5) AS table1_AJ5,
		max(t0.table1_AK5) AS table1_AK5,
		max(t0.table1_AL5) AS table1_AL5,
		max(t0.table1_AM5) AS table1_AM5,
		max(t0.table1_AN5) AS table1_AN5,
		max(t0.table1_AO5) AS table1_AO5,
		max(t0.table1_AP5) AS table1_AP5,
		max(t0.table1_AQ5) AS table1_AQ5,
		max(t0.table1_AR5) AS table1_AR5,
		max(t0.table1_AS5) AS table1_AS5,
		max(t0.table1_AT5) AS table1_AT5,
		max(t0.table1_AU5) AS table1_AU5,
		max(t0.table1_AV5) AS table1_AV5,
		sum(t0.table1_AW5) AS table1_AW5,
		sum(t0.table1_AX5) AS table1_AX5,
		sum(t0.table1_AY5) AS table1_AY5,
		sum(t0.table1_AZ5) AS table1_AZ5,
		sum(t0.table1_BA5) AS table1_BA5,
		sum(t0.table1_BB5) AS table1_BB5,
		sum(t0.table1_BC5) AS table1_BC5,
		sum(t0.table1_BD5) AS table1_BD5,
		sum(t0.table1_BE5) AS table1_BE5,
		sum(t0.table1_BF5) AS table1_BF5,
		sum(t0.table1_BG5) AS table1_BG5,
		sum(t0.table1_BH5) AS table1_BH5,
		sum(t0.table1_BI5) AS table1_BI5,
		sum(t0.table1_BJ5) AS table1_BJ5,
		sum(t0.table1_BK5) AS table1_BK5,
		sum(t0.table1_BL5) AS table1_BL5,
		sum(t0.table1_BM5) AS table1_BM5,
		sum(t0.table1_BN5) AS table1_BN5,
		sum(t0.table1_BO5) AS table1_BO5,
		sum(t0.table1_BP5) AS table1_BP5,
		sum(t0.table1_BQ5) AS table1_BQ5,
		sum(t0.table1_BR5) AS table1_BR5,
		sum(t0.table1_BS5) AS table1_BS5,
		sum(t0.table1_BT5) AS table1_BT5,
		sum(t0.table1_BU5) AS table1_BU5,
		sum(t0.table1_BV5) AS table1_BV5,
		sum(t0.table1_BW5) AS table1_BW5,
		sum(t0.table1_BX5) AS table1_BX5,
		sum(t0.table1_BY5) AS table1_BY5,
		sum(t0.table1_BZ5) AS table1_BZ5,
		sum(t0.table1_CA5) AS table1_CA5,
		sum(t0.table1_CB5) AS table1_CB5,
		sum(t0.table1_CC5) AS table1_CC5,
		sum(t0.table1_CD5) AS table1_CD5,
		sum(t0.table1_CE5) AS table1_CE5,
		sum(t0.table1_CF5) AS table1_CF5,
		sum(t0.table1_CG5) AS table1_CG5,
		sum(t0.table1_CH5) AS table1_CH5,
		sum(t0.table1_CI5) AS table1_CI5,
		sum(t0.table1_CJ5) AS table1_CJ5,
		sum(t0.table1_CK5) AS table1_CK5,
		sum(t0.table1_CL5) AS table1_CL5,
		sum(t0.table1_CM5) AS table1_CM5,
		sum(t0.table1_CN5) AS table1_CN5,
		sum(t0.table1_CO5) AS table1_CO5,
		sum(t0.table1_CP5) AS table1_CP5,
		sum(t0.table1_CQ5) AS table1_CQ5,
		sum(t0.table1_CR5) AS table1_CR5,
		sum(t0.table1_CS5) AS table1_CS5,
		sum(t0.table1_CT5) AS table1_CT5,
		sum(t0.table1_CU5) AS table1_CU5,
		sum(t0.table1_CV5) AS table1_CV5,
		sum(t0.table1_CW5) AS table1_CW5,
		sum(t0.table1_CX5) AS table1_CX5,
		sum(t0.table1_CY5) AS table1_CY5,
		sum(t0.table1_CZ5) AS table1_CZ5,
		sum(t0.table1_DA5) AS table1_DA5,
		sum(t0.table1_DB5) AS table1_DB5,
		sum(t0.table1_DC5) AS table1_DC5,
		sum(t0.table1_DD5) AS table1_DD5,
		sum(t0.table1_DE5) AS table1_DE5,
		sum(t0.table1_DF5) AS table1_DF5,
		sum(t0.table1_DG5) AS table1_DG5,
		sum(t0.table1_DH5) AS table1_DH5,
		sum(t0.table1_DI5) AS table1_DI5,
		sum(t0.table1_DJ5) AS table1_DJ5,
		sum(t0.table1_DK5) AS table1_DK5,
		sum(t0.table1_DL5) AS table1_DL5,
		sum(t0.table1_DM5) AS table1_DM5,
		sum(t0.table1_DN5) AS table1_DN5,
		sum(t0.table1_DO5) AS table1_DO5,
		sum(t0.table1_DP5) AS table1_DP5,
		sum(t0.table1_DQ5) AS table1_DQ5,
		sum(t0.table1_DR5) AS table1_DR5,
		sum(t0.table1_DS5) AS table1_DS5,
		sum(t0.table1_DT5) AS table1_DT5,
		sum(t0.table1_DU5) AS table1_DU5,
		sum(t0.table1_DV5) AS table1_DV5,
		sum(t0.table1_DW5) AS table1_DW5,
		sum(t0.table1_DX5) AS table1_DX5,
		sum(t0.table1_DY5) AS table1_DY5,
		sum(t0.table1_DZ5) AS table1_DZ5,
		sum(t0.table1_EA5) AS table1_EA5,
		sum(t0.table1_EB5) AS table1_EB5,
		sum(t0.table1_EC5) AS table1_EC5,
		sum(t0.table1_ED5) AS table1_ED5,
		sum(t0.table1_EE5) AS table1_EE5,
		sum(t0.table1_EF5) AS table1_EF5,
		sum(t0.table1_EG5) AS table1_EG5,
		sum(t0.table1_EH5) AS table1_EH5,
		sum(t0.table1_EI5) AS table1_EI5,
		sum(t0.table1_EJ5) AS table1_EJ5,
		sum(t0.table1_EK5) AS table1_EK5,
		sum(t0.table1_EL5) AS table1_EL5,
		sum(t0.table1_EM5) AS table1_EM5,
		sum(t0.table1_EN5) AS table1_EN5,
		sum(t0.table1_EO5) AS table1_EO5,
		sum(t0.table1_EP5) AS table1_EP5,
		sum(t0.table1_EQ5) AS table1_EQ5,
		sum(t0.table1_ER5) AS table1_ER5,
		sum(t0.table1_ES5) AS table1_ES5,
		sum(t0.table1_ET5) AS table1_ET5,
		sum(t0.table1_EU5) AS table1_EU5,
		sum(t0.table1_EV5) AS table1_EV5,
		sum(t0.table1_EW5) AS table1_EW5,
		sum(t0.table1_EX5) AS table1_EX5,
		sum(t0.table1_EY5) AS table1_EY5,
		sum(t0.table1_EZ5) AS table1_EZ5,
		sum(t0.table1_FA5) AS table1_FA5,
		sum(t0.table1_FB5) AS table1_FB5,
		sum(t0.table1_FC5) AS table1_FC5,
		sum(t0.table1_FD5) AS table1_FD5,
		sum(t0.table1_FE5) AS table1_FE5,
		sum(t0.table1_FF5) AS table1_FF5,
		sum(t0.table1_FG5) AS table1_FG5,
		sum(t0.table1_FH5) AS table1_FH5,
		sum(t0.table1_FI5) AS table1_FI5,
		sum(t0.table1_FJ5) AS table1_FJ5,
		sum(t0.table1_FK5) AS table1_FK5,
		sum(t0.table1_FL5) AS table1_FL5,
		sum(t0.table1_FM5) AS table1_FM5,
		sum(t0.table1_FN5) AS table1_FN5,
		sum(t0.table1_FO5) AS table1_FO5,
		sum(t0.table1_FP5) AS table1_FP5,
		max(t0.table1_FQ5) AS table1_FQ5,
		max(t0.table1_FR5) AS table1_FR5,
		max(t0.table1_FS5) AS table1_FS5,
		max(t0.table1_FT5) AS table1_FT5,
		max(t0.table1_FU5) AS table1_FU5,
		max(t0.table1_FV5) AS table1_FV5,
		max(t0.table1_C5_DSC) AS table1_C5_DSC,
		max(t0.table1_D5_DSC) AS table1_D5_DSC
	FROM
		(SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		max(t0.YEAR) AS table1_B5,
		max(t0.YLJGID) AS table1_D5,
		max(t0.DEPT_SHXYDM) AS table1_E5,
		max(t0.DEPT_CODE) AS table1_F5,
		max(t0.JJLX) AS table1_G5,
		max(t0.DEPT_CLASS) AS table1_H5,
		max(t0.JGFLGL) AS table1_I5,
		max(t0.DEPT_ADRRESSCODE) AS table1_J5,
		max(t0.DEPT_XZJDCODE) AS table1_K5,
		max(t0.ZBDW) AS table1_L5,
		max(t0.LSGX) AS table1_M5,
		max(t0.ISAUTONOMOUS) AS table1_N5,
		max(t0.ISFZJG) AS table1_O5,
		max(t0.ISDLJG) AS table1_P5,
		max(t0.DZ) AS table1_Q5,
		max(t0.YZBM) AS table1_R5,
		max(t0.LXDH) AS table1_S5,
		max(t0.EMAIL) AS table1_T5,
		max(t0.WEBYM) AS table1_U5,
		max(t0.CLSJ) AS table1_V5,
		max(t0.FRDB) AS table1_W5,
		max(t0.SFDLFR) AS table1_X5,
		max(t0.GKDWMC) AS table1_Y5,
		max(t0.SFDLHS) AS table1_Z5,
		max(t0.YYYGX) AS table1_AA5,
		sum(t0.JJCW) AS table1_AB5,
		max(t0.JJZXMS) AS table1_AC5,
		sum(t0.JJWLFGFZS) AS table1_AD5,
		sum(t0.JJZSFZS) AS table1_AE5,
		sum(t0.JJWLYYFGS) AS table1_AF5,
		max(t0.SFSLYXKS_YQJJ) AS table1_AG5,
		max(t0.SFSLYXKS_DXDD) AS table1_AH5,
		max(t0.SFSLYXKS_CGK) AS table1_AI5,
		max(t0.SFSLYXKS_QTYW) AS table1_AJ5,
		max(t0.YXTXDDQK) AS table1_AK5,
		max(t0.WXTXDDQK) AS table1_AL5,
		max(t0.SFYYHJXT) AS table1_AM5,
		max(t0.DHHJXTSFJYGN) AS table1_AN5,
		max(t0.XMHJXTSFJYGN) AS table1_AO5,
		max(t0.ZJHJXTSFJYGN) AS table1_AP5,
		max(t0.ZDPDHJXTSFJYGN) AS table1_AQ5,
		max(t0.LYSBHJXTSFJUGN) AS table1_AR5,
		max(t0.SFJBYXSLFS_DSJ) AS table1_AS5,
		max(t0.SFJBYXSLFS_QSZDD) AS table1_AT5,
		max(t0.SFJBYXSLFS_QSHJZ) AS table1_AU5,
		max(t0.SFJBYXSLFS_SSJ) AS table1_AV5,
		sum(t0.FWQCPUZHS) AS table1_AW5,
		sum(t0.YSYCCSBRL) AS table1_AX5,
		sum(t0.DNZDSL) AS table1_AY5,
		sum(t0.TGSJDBCPXT) AS table1_AZ5,
		max(t1.CAPTION) AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B1 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_CI_INDEX t2
			ON (t0.YLJGID=t2.YLJGID
				AND t0.YEAR=t2.YEAR)
		WHERE (t2.CI_DATA_STATE=1
				AND t1.ENABLED=1
				AND t1.TODATE_>='202312'
				AND t1.FROMDATE_<='202312'
				AND t0.YEAR='2023'
				AND t0.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		sum(t0.BZRS) AS table1_BA5,
		sum(t0.ZBRS) AS table1_BB5,
		sum(t0.ZGZGS) AS table1_BC5,
		sum(t0.WSJSRY) AS table1_BD5,
		sum(t0.ZYYS) AS table1_BE5,
		sum(t0.ZYZLYS) AS table1_BF5,
		sum(t0.ZCHS) AS table1_BG5,
		sum(t0.YS) AS table1_BH5,
		sum(t0.XYS) AS table1_BI5,
		sum(t0.ZYS) AS table1_BJ5,
		sum(t0.JS) AS table1_BK5,
		sum(t0.JYJS) AS table1_BL5,
		sum(t0.YXJS) AS table1_BM5,
		sum(t0.KFJS) AS table1_BN5,
		sum(t0.QTWSJSRY) AS table1_BO5,
		sum(t0.QZ_JXYS) AS table1_BP5,
		sum(t0.QTJSRY) AS table1_BQ5,
		sum(t0.GLRY) AS table1_BR5,
		sum(t0.JCSGLRY) AS table1_BS5,
		sum(t0.GQJNRY) AS table1_BT5,
		sum(t0.ZGZG_YQJJRY) AS table1_BU5,
		sum(t0.GGWSRY) AS table1_BV5,
		sum(t0.TXFPZYYSRS) AS table1_BW5,
		sum(t0.TXFPZYLB) AS table1_BX5,
		sum(t0.LTXRY) AS table1_BY5,
		sum(t0.QZ_NNTXRY) AS table1_BZ5,
		sum(t0.ZFJBGWPXS) AS table1_CA5,
		sum(t0.JSJXYXJYRS) AS table1_CB5,
		sum(t0.JXBNYSRS) AS table1_CC5,
		sum(t0.LR) AS table1_CD5,
		sum(t0.LC) AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B2 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		sum(t0.FWJZMJ) AS table1_CF5,
		sum(t0.FWYWYFMJ) AS table1_CG5,
		sum(t0.NWFMJ) AS table1_CH5,
		sum(t0.YQJJYWYFMJ) AS table1_CI5,
		sum(t0.ZFMJ) AS table1_CJ5,
		sum(t0.ZFYWYFMJ) AS table1_CK5,
		sum(t0.NYQJJYWYFMJ) AS table1_CL5,
		sum(t0.ZJ) AS table1_CM5,
		sum(t0.BNPZXMSL) AS table1_CN5,
		sum(t0.BNPZXMMJ) AS table1_CO5,
		sum(t0.BNSJWCTZ) AS table1_CP5,
		sum(t0.QZ_CZXTZ) AS table1_CQ5,
		sum(t0.DWZYJJ) AS table1_CR5,
		sum(t0.YHDK) AS table1_CS5,
		sum(t0.BNFWJGMJ) AS table1_CT5,
		sum(t0.BNXZGDZC) AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B3 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		sum(t0.WASBZJZ) AS table1_CV5,
		sum(t0.WASBZSL) AS table1_CW5,
		sum(t0.QZ_49WYSB) AS table1_CX5,
		sum(t0.QZ_99WYSB) AS table1_CY5,
		sum(t0.QZ_100WYSSB) AS table1_CZ5,
		sum(t0.BXSHXJ) AS table1_DA5,
		sum(t0.DDXYQ) AS table1_DB5,
		sum(t0.XDJHCQY) AS table1_DC5,
		sum(t0.XTY) AS table1_DD5,
		sum(t0.XDTJ) AS table1_DE5,
		sum(t0.XDJHY) AS table1_DF5,
		sum(t0.XZCCQ) AS table1_DG5,
		sum(t0.QGCGJ) AS table1_DH5,
		sum(t0.XYBHDCS) AS table1_DI5,
		sum(t0.CSDJ) AS table1_DJ5,
		sum(t0.FDMJ) AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B4 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		sum(t0.ZSR) AS table1_DL5,
		sum(t0.CZBZSR) AS table1_DM5,
		sum(t0.JBZCBZ) AS table1_DN5,
		sum(t0.XMZCBZ) AS table1_DO5,
		sum(t0.SJBZSR) AS table1_DP5,
		sum(t0.SYSR) AS table1_DQ5,
		sum(t0.ZZC) AS table1_DR5,
		sum(t0.YWHDFY) AS table1_DS5,
		sum(t0.CZJBBKJF) AS table1_DT5,
		sum(t0.CZXMBKJF) AS table1_DU5,
		sum(t0.DWGLFY) AS table1_DV5,
		sum(t0.DWGL_CZJBBKJF) AS table1_DW5,
		sum(t0.DWGL_CZXMBKJF) AS table1_DX5,
		sum(t0.RYZC) AS table1_DY5,
		sum(t0.GZFLF) AS table1_DZ5,
		sum(t0.GGRJJTBZF) AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B5 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		sum(t0.ZZC) AS table1_EB5,
		sum(t0.LDZC) AS table1_EC5,
		sum(t0.FLDZC) AS table1_ED5,
		sum(t0.GDZC) AS table1_EE5,
		sum(t0.GDZCJZ) AS table1_EF5,
		sum(t0.STDLZC) AS table1_EG5,
		sum(t0.FZYJZC) AS table1_EH5,
		sum(t0.FZ) AS table1_EI5,
		sum(t0.LDFZ_FZYJZC) AS table1_EJ5,
		sum(t0.FLDFZ_FZYJZC) AS table1_EK5,
		sum(t0.STDLFZ) AS table1_EL5,
		sum(t0.JZC) AS table1_EM5,
		sum(t0.SYJJ_JZC) AS table1_EN5,
		sum(t0.ZYJJ_JZC) AS table1_EO5,
		sum(t0.QTJZC_JZC) AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B6 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		sum(t0.FWMJ) AS table1_EQ5,
		sum(t0.FWBJ) AS table1_ER5,
		sum(t0.FWRK) AS table1_ES5,
		sum(t0.CQRK) AS table1_ET5,
		sum(t0.YQJJ_PJFYSJ) AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B7 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		sum(t0.JJHJCS) AS table1_EV5,
		sum(t0.CJCS) AS table1_EW5,
		sum(t0.QJXJJCCS) AS table1_EX5,
		sum(t0.YZXJJCCS) AS table1_EY5,
		sum(t0.JZRCS) AS table1_EZ5,
		sum(t0.XZB) AS table1_FA5,
		sum(t0.GXY) AS table1_FB5,
		sum(t0.NXGB) AS table1_FC5,
		sum(t0.XSZD) AS table1_FD5,
		sum(t0.CRB) AS table1_FE5,
		sum(t0.EXZL) AS table1_FF5,
		sum(t0.HXXTJB) AS table1_FG5,
		sum(t0.XHXTJB) AS table1_FH5,
		sum(t0.SJXTJB) AS table1_FI5,
		sum(t0.MLXTJB) AS table1_FJ5,
		sum(t0.RCFWCRBFZ) AS table1_FK5,
		sum(t0.QT) AS table1_FL5,
		sum(t0.WZBLS) AS table1_FM5,
		sum(t0.WJZRCS) AS table1_FN5,
		sum(t0.CDJYSWRS) AS table1_FO5,
		sum(t0.TZSWRS) AS table1_FP5,
		null AS table1_FQ5,
		null AS table1_FR5,
		null AS table1_FS5,
		null AS table1_FT5,
		null AS table1_FU5,
		null AS table1_FV5
		FROM shtjzb.WT15_B8 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID
		UNION ALL
		SELECT t0.YLJGID AS table1_C5,
		max(t1.CAPTION) AS table1_C5_DSC,
		null AS table1_B5,
		null AS table1_D5,
		null AS table1_E5,
		null AS table1_F5,
		null AS table1_G5,
		null AS table1_H5,
		null AS table1_I5,
		null AS table1_J5,
		null AS table1_K5,
		null AS table1_L5,
		null AS table1_M5,
		null AS table1_N5,
		null AS table1_O5,
		null AS table1_P5,
		null AS table1_Q5,
		null AS table1_R5,
		null AS table1_S5,
		null AS table1_T5,
		null AS table1_U5,
		cast(null AS date) AS table1_V5,
		null AS table1_W5,
		null AS table1_X5,
		null AS table1_Y5,
		null AS table1_Z5,
		null AS table1_AA5,
		null AS table1_AB5,
		null AS table1_AC5,
		null AS table1_AD5,
		null AS table1_AE5,
		null AS table1_AF5,
		null AS table1_AG5,
		null AS table1_AH5,
		null AS table1_AI5,
		null AS table1_AJ5,
		null AS table1_AK5,
		null AS table1_AL5,
		null AS table1_AM5,
		null AS table1_AN5,
		null AS table1_AO5,
		null AS table1_AP5,
		null AS table1_AQ5,
		null AS table1_AR5,
		null AS table1_AS5,
		null AS table1_AT5,
		null AS table1_AU5,
		null AS table1_AV5,
		null AS table1_AW5,
		null AS table1_AX5,
		null AS table1_AY5,
		null AS table1_AZ5,
		null AS table1_D5_DSC,
		null AS table1_BA5,
		null AS table1_BB5,
		null AS table1_BC5,
		null AS table1_BD5,
		null AS table1_BE5,
		null AS table1_BF5,
		null AS table1_BG5,
		null AS table1_BH5,
		null AS table1_BI5,
		null AS table1_BJ5,
		null AS table1_BK5,
		null AS table1_BL5,
		null AS table1_BM5,
		null AS table1_BN5,
		null AS table1_BO5,
		null AS table1_BP5,
		null AS table1_BQ5,
		null AS table1_BR5,
		null AS table1_BS5,
		null AS table1_BT5,
		null AS table1_BU5,
		null AS table1_BV5,
		null AS table1_BW5,
		null AS table1_BX5,
		null AS table1_BY5,
		null AS table1_BZ5,
		null AS table1_CA5,
		null AS table1_CB5,
		null AS table1_CC5,
		null AS table1_CD5,
		null AS table1_CE5,
		null AS table1_CF5,
		null AS table1_CG5,
		null AS table1_CH5,
		null AS table1_CI5,
		null AS table1_CJ5,
		null AS table1_CK5,
		null AS table1_CL5,
		null AS table1_CM5,
		null AS table1_CN5,
		null AS table1_CO5,
		null AS table1_CP5,
		null AS table1_CQ5,
		null AS table1_CR5,
		null AS table1_CS5,
		null AS table1_CT5,
		null AS table1_CU5,
		null AS table1_CV5,
		null AS table1_CW5,
		null AS table1_CX5,
		null AS table1_CY5,
		null AS table1_CZ5,
		null AS table1_DA5,
		null AS table1_DB5,
		null AS table1_DC5,
		null AS table1_DD5,
		null AS table1_DE5,
		null AS table1_DF5,
		null AS table1_DG5,
		null AS table1_DH5,
		null AS table1_DI5,
		null AS table1_DJ5,
		null AS table1_DK5,
		null AS table1_DL5,
		null AS table1_DM5,
		null AS table1_DN5,
		null AS table1_DO5,
		null AS table1_DP5,
		null AS table1_DQ5,
		null AS table1_DR5,
		null AS table1_DS5,
		null AS table1_DT5,
		null AS table1_DU5,
		null AS table1_DV5,
		null AS table1_DW5,
		null AS table1_DX5,
		null AS table1_DY5,
		null AS table1_DZ5,
		null AS table1_EA5,
		null AS table1_EB5,
		null AS table1_EC5,
		null AS table1_ED5,
		null AS table1_EE5,
		null AS table1_EF5,
		null AS table1_EG5,
		null AS table1_EH5,
		null AS table1_EI5,
		null AS table1_EJ5,
		null AS table1_EK5,
		null AS table1_EL5,
		null AS table1_EM5,
		null AS table1_EN5,
		null AS table1_EO5,
		null AS table1_EP5,
		null AS table1_EQ5,
		null AS table1_ER5,
		null AS table1_ES5,
		null AS table1_ET5,
		null AS table1_EU5,
		null AS table1_EV5,
		null AS table1_EW5,
		null AS table1_EX5,
		null AS table1_EY5,
		null AS table1_EZ5,
		null AS table1_FA5,
		null AS table1_FB5,
		null AS table1_FC5,
		null AS table1_FD5,
		null AS table1_FE5,
		null AS table1_FF5,
		null AS table1_FG5,
		null AS table1_FH5,
		null AS table1_FI5,
		null AS table1_FJ5,
		null AS table1_FK5,
		null AS table1_FL5,
		null AS table1_FM5,
		null AS table1_FN5,
		null AS table1_FO5,
		null AS table1_FP5,
		max(t0.FRDB) AS table1_FQ5,
		max(t0.TJFZR) AS table1_FR5,
		max(t0.TBR) AS table1_FS5,
		max(t0.LXDH) AS table1_FT5,
		max(t0.BCRQ) AS table1_FU5,
		max(t0.TBSM) AS table1_FV5
		FROM shtjzb.WT15_B9 t0
		LEFT JOIN shtjzb.DIM_YLJG t1
			ON (t0.YLJGID=t1.YLJGID
				AND (concat(t0.YEAR, '12')>=t1.FROMDATE_
				AND concat(t0.YEAR, '12')<=t1.TODATE_))
		LEFT JOIN shtjzb.WT15_B1 t2
			ON (t2.YLJGID=t0.YLJGID
				AND t2.YEAR=t0.YEAR)
		LEFT JOIN shtjzb.WT15_CI_INDEX t3
			ON (t2.YLJGID=t3.YLJGID
				AND t2.YEAR=t3.YEAR)
		LEFT JOIN shtjzb.DIM_YLJG t4
			ON (t2.YLJGID=t4.YLJGID
				AND (concat(t2.YEAR, '12')>=t4.FROMDATE_
				AND concat(t2.YEAR, '12')<=t4.TODATE_))
		WHERE (t3.CI_DATA_STATE=1
				AND t4.ENABLED=1
				AND t4.TODATE_>='202312'
				AND t4.FROMDATE_<='202312'
				AND t2.YEAR='2023'
				AND t2.DEPT_ADRRESSCODE LIKE '310%')
		GROUP BY  t0.YLJGID ) t0
		GROUP BY  t0.table1_C5 ) t0
	LEFT JOIN shtjzb.DIM_JJLX t1
	ON (t0.table1_G5=t1.CODE)
LEFT JOIN shtjzb.DIM_WSJGLB_JG t2
	ON (t0.table1_H5=t2.CODE)
LEFT JOIN shtjzb.DIM_JGFLGL t3
	ON (t0.table1_I5=t3.CODE)
LEFT JOIN shtjzb.DIM_XZQH t4
	ON (t0.table1_J5=t4.CODE)
LEFT JOIN shtjzb.DIM_XZJDDM t5
	ON (t0.table1_K5=t5.CODE)
LEFT JOIN shtjzb.DIM_SZZBDW t6
	ON (t0.table1_L5=t6.CODE)
LEFT JOIN shtjzb.DIM_WSJGLSGX t7
	ON (t0.table1_M5=t7.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t8
	ON (t0.table1_N5=t8.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t9
	ON (t0.table1_O5=t9.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t10
	ON (t0.table1_P5=t10.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t11
	ON (t0.table1_X5=t11.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t12
	ON (t0.table1_Z5=t12.CODE)
LEFT JOIN shtjzb.DIM_YYGX t13
	ON (t0.table1_AA5=t13.CODE)
LEFT JOIN shtjzb.DIM_JJZX t14
	ON (t0.table1_AC5=t14.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t15
	ON (t0.table1_AG5=t15.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t16
	ON (t0.table1_AH5=t16.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t17
	ON (t0.table1_AI5=t17.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t18
	ON (t0.table1_AK5=t18.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t19
	ON (t0.table1_AL5=t19.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t20
	ON (t0.table1_AM5=t20.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t21
	ON (t0.table1_AN5=t21.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t22
	ON (t0.table1_AO5=t22.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t23
	ON (t0.table1_AP5=t23.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t24
	ON (t0.table1_AQ5=t24.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t25
	ON (t0.table1_AR5=t25.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t26
	ON (t0.table1_AS5=t26.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t27
	ON (t0.table1_AT5=t27.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t28
	ON (t0.table1_AU5=t28.CODE)
LEFT JOIN shtjzb.DIM_SF_10 t29
	ON (t0.table1_AV5=t29.CODE)
ORDER BY  t0.table1_C5 limit 100