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.78ms/modules/Event/Controllers/EventController.php:53tripsap_new