selectcount(*) as aggregate from (select`bravo_hotels`.* from`bravo_hotels`where`bravo_hotels`.`status` = 'publish'and`bravo_hotels`.`deleted_at`isnullgroupby`bravo_hotels`.`id`) as`aggregate_table`1.89ms/modules/Hotel/Models/Hotel.php:1090ailamedrent