select count(f.point_id)个数,DATE_FORMAT(f.日期,"%Y-%m-%d")年月日,g.plant_name from

(select c.*,d.plant_id from

(select a.point_id,DATE_FORMAT(b.alarm_start,"%Y-%m-%d")日期 from mom_alarm a inner join mom_alarm_record b on a.id = b.alarm_id) c inner join mom_pro_point d on c.point_id = d.id and plant_id in (1397415639378825217,1397415786250768386,1397415906912505858,1397423254204846081,1400000042739175425,1400000239011631105,1400000402195222530,1400000537159536641,1400000809365671937,1400383965398831106)) f 

inner join mom_pro_plant g on f.plant_id = g.id where g.parent_id = 1397414517960347650 and DATE_FORMAT(日期,'%Y-%m-%d') >= '${DATEINMONTH(DATEDELTA(date, 1), 1)}' AND DATE_FORMAT(日期,'%Y-%m-%d') <='${DATEINMONTH(DATEDELTA(date, 1), -1)}'

group by DATE_FORMAT(f.日期,"%Y-%m-%d"),g.plant_name

order by DATE_FORMAT(f.日期,"%Y-%m-%d") asc

这个数据集按月查询只能查出本月的，需要加点什么能相查几月查几月的？

图：