sbappend select ; sbappend xC_ID ; sbappend yC_ID as C_IDS ; sbappend yC_STATUS ; sbappend sumzm9 ; sbappend sumzm1 ; sbappend sumzm2 ; sbappend sumzm3 ; sbappend sumzm4 ; sbappend sumzm5 ;

select x.C_ID, y.C_ID as C_IDS, y.C_STATUS, sum(z.m9), sum(z.m1), sum(z.m2), sum(z.m3), sum(z.m4), sum(z.m5), sum(z.m6), sum(z.m7), sum(z.m8), x.C_NAME from db_twenty.t_place x LEFT JOIN db_twenty.t_projectreportbatch y ON ( y.R_STATEMENT_ID = ? AND x.C_ID = y.R_PLACE_ID ) LEFT JOIN db_twenty.t_projectreports z ON ( z.C_TOWID = x.C_ID and z.C_ANNUAL*100+z.C_PERIOD<=? and z.C_DELETED = 0 ) WHERE x.R_PARENT_ID = ? AND x.C_DELETED = 0 GROUP BY x.C_ID