selectcount(*) as aggregate from (select`bravo_boats`.* from`bravo_boats`where`bravo_boats`.`status` = 'publish'and`bravo_boats`.`deleted_at`isnullgroupby`bravo_boats`.`id`) as`aggregate_table`5.22ms/modules/Boat/Controllers/BoatController.php:46tripsap_new