selectcount(*) as aggregate from (select`bravo_tours`.* from`bravo_tours`where`bravo_tours`.`status` = 'publish'and`bravo_tours`.`deleted_at`isnullgroupby`bravo_tours`.`id`) as`aggregate_table`1.04ms/modules/Tour/Controllers/TourController.php:46visitethiopia