CONCAT(a.id, ':', a.id_name) as id_name_str
Format(a.weight, 2) as weight_str
date_format(a.date,'%Y%m%d')>=date_format(#{beginDate},'%Y%m%d')
ifnull(sum(a.sum),0) as totall_sum
CONCAT(a.id, ':', a.id_name) as id_name_str
Format(a.weight, 2) as weight_str
date_format(a.date,'%Y%m%d')>=date_format(#{beginDate},'%Y%m%d')
ifnull(sum(a.sum),0) as totall_sum