id_, main_id_, fill_date_, subject_code_, subject_name_, subject_name_en_, subject_level_, subject_unit_, enterprise_code_, enterprise_name_, enterprise_name_en_, actual_, budget_, act_bug_, actual_ytd_, budget_ytd_, act_bug_ytd_, last_time_ SELECT q.enterprise_code_ FROM ( SELECT enterprise_code_, column_ FROM qf_finance_reporting_summary_d WHERE main_id_ = #{mainId} GROUP BY enterprise_code_, column_ ORDER BY column_ ) q SELECT q.subject_code_ FROM (SELECT subject_code_, sn_ FROM qf_finance_reporting_summary_d WHERE main_id_ =#{mainId} GROUP BY subject_code_, sn_ ORDER BY sn_) q SELECT m.enterprise_code_,m.subject_code_, (SELECT d.actual_ytd_ AS fillRealData FROM qf_finance_reporting_summary_d d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth}=m.fill_month_ and d.subject_code_ = m.subject_code_ and d.enterprise_code_ = m.enterprise_code_ ) as fillRealData, (SELECT d.actual_ytd_ AS fillUnrealData FROM qf_finance_reporting_summary_d d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth} - 1 = m.fill_month_ and d.subject_code_ = m.subject_code_ and d.enterprise_code_ = m.enterprise_code_ ) as fillUnrealData, (SELECT d.actual_ytd_ AS lastYearfillRealData FROM qf_finance_reporting_summary_d d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear}-1 AND #{endMonth} =m.fill_month_ and d.subject_code_ = m.subject_code_ and d.enterprise_code_ = m.enterprise_code_ ) as lastYearfillRealData, (SELECT d.actual_ytd_ AS lastYearfillUnrealData FROM qf_finance_reporting_summary_d d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} -1 AND #{endMonth}-1 =m.fill_month_ and d.subject_code_ = m.subject_code_ and d.enterprise_code_ = m.enterprise_code_ ) as lastYearfillUnrealData FROM qf_finance_reporting_summary_d m where m.subject_code_ in #{subjectCode} GROUP BY m.enterprise_code_,m.subject_code_ UNION all SELECT 'CIGR' AS enterprise_code_,m.subject_code_, (SELECT d.actual_consolidated_ AS fillRealData FROM qf_finance_reporting_summary_s d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth} = m.fill_month_ and d.subject_code_ = m.subject_code_ ) as fillRealData, (SELECT d.actual_consolidated_ AS fillUnrealData FROM qf_finance_reporting_summary_s d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth} - 1 = m.fill_month_ and d.subject_code_ = m.subject_code_ ) as fillUnrealData, (SELECT d.actual_consolidated_ AS lastYearfillRealData FROM qf_finance_reporting_summary_s d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear}-1 AND #{endMonth}=m.fill_month_ and d.subject_code_ = m.subject_code_ ) as lastYearfillRealData, (SELECT d.actual_consolidated_ AS lastYearfillUnrealData FROM qf_finance_reporting_summary_s d LEFT JOIN qf_finance_reporting_summary_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} -1 AND #{endMonth}-1 =m.fill_month_ and d.subject_code_ = m.subject_code_ ) as lastYearfillUnrealData FROM qf_finance_reporting_summary_s m where m.subject_code_ in #{subjectCode} GROUP BY m.subject_code_