select  ed.id,
        ed.name,
        ed.delay,
        ed.max_delay,
        ed.granularity,
        ev.state,
        count(*)
from    action_trigger.event ev
        join action_trigger.event_definition ed on (ev.event_def = ed.id)
where   date(ev.run_time) = date(now())
        and ed.id = 6 -- get this id from action_trigger.event_definition
group by 1, 2, 3, 4, 5, 6
order by 1, 6;