selectcount(*) as aggregate from (select`bravo_cars`.* from`bravo_cars`where`bravo_cars`.`status` = 'publish'and`bravo_cars`.`deleted_at`isnullgroupby`bravo_cars`.`id`) as`aggregate_table`11.9ms/modules/Car/Controllers/CarController.php:42cafebgnu_suran