SELECT * FROM
(
SELECT 'SSMAIP' AS central,DATE_FORMAT(STR_TO_DATE(a.fecha_cortada,'%M %d'),'%m-%d') fecha,a.hora_cortada,LEFT(a.description,2) description,
count(1) total_registro
FROM sstk_ssmaip a
WHERE DATE_FORMAT(STR_TO_DATE(a.fecha_cortada,'%M %d'),'%m-%d') >= DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 6 DAY),'%m-%d')
AND DATE_FORMAT(STR_TO_DATE(a.fecha_cortada,'%M %d'),'%m-%d') <= DATE_FORMAT(now(),'%m-%d')
AND LEFT(a.description,2) = 'OG'
GROUP BY DATE_FORMAT(STR_TO_DATE(a.fecha_cortada,'%M %d'),'%m-%d'),a.hora_cortada,LEFT(a.description,2)