select mid(fecha,1,10), accion,nivel_id,grado,count(idusuario) from log_scejal
where mid(afectado,1,2) <> '14' and grado <> 0 and fase = 'PREINSCRIPCIONES'
and accion = 'REGISTRO'
group by mid(fecha,1,10),accion,nivel_id,grado