PHP+SQL ติดปัญหา เรื่อง Group By Clause (จะนำไปแสดงผลใน Excel ให้ได้ตามความต้องการของ User)

SELECT count(dm_model) AS total,dm_model,DATEPART(dd,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)) AS InsertDay,
DATEPART(mm,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)) AS InsertMonth,
DATEPART(yyyy,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)) AS InsertYear

FROM  dev_log LEFT OUTER JOIN devices ON dev_log.device_id=devices.device_id
LEFT OUTER JOIN lots ON devices.lot_id=lots.lot_id
LEFT OUTER JOIN device_model ON lots.dm_id=device_model.dm_id

WHERE (dev_log_datetime BETWEEN 1466787600  AND 1467133199)

GROUP BY dm_model,DATEPART(dd,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)),
DATEPART(mm,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)),
DATEPART(yyyy,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime))

ORDER BY DATEPART(dd,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)), 
DATEPART(mm,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime)), 
DATEPART(yyyy,dbo.F_UNIX_TIME_TO_DATETIME(dev_log_datetime))