selectcount(*) as aggregate from (select`bravo_spaces`.* from`bravo_spaces`where`bravo_spaces`.`status` = 'publish'and`bravo_spaces`.`deleted_at`isnullgroupby`bravo_spaces`.`id`) as`aggregate_table`17.96ms/modules/Space/Models/Space.php:1015ailamedrent