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`8.79ms/modules/Event/Models/Event.php:1014ailamedrent