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`4.44ms/modules/Boat/Controllers/BoatController.php:46tripsap_new