selectcount(*) as aggregate from (select`bravo_events`.* from`bravo_events`where`bravo_events`.`status` = 'publish'and`bravo_events`.`deleted_at`isnullgroupby`bravo_events`.`id`) as`aggregate_table`3.87ms/modules/Event/Models/Event.php:1014ailamedrent