mysql 12小时前_在mysql中以小时为单位计算过去12小时内的所有记录

我已经找到了答案如下：

SELECT za_hours.za_hour as hour, COUNT(id) as calls

FROM (

SELECT NOW() - INTERVAL 1 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 2 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 3 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 4 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 5 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 6 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 7 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 8 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 9 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 10 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 11 HOUR as za_hour UNION

SELECT NOW() - INTERVAL 12 HOUR as za_hour)

za_hours

LEFT JOIN

cebod_cdr

ON DATE_FORMAT(za_hours.za_hour, '%Y-%m-%d %H:') = DATE_FORMAT(starting_date, '%Y-%m-%d %H:')

AND starting_date >= NOW() - INTERVAL 12 HOUR

GROUP BY za_hours.za_hour

ORDER BY za_hours.za_hour

请建议，如果我能改善这个查询。