select `cars`.*, (selectcount(*) from `car_favorites` where `cars`.`id` = `car_favorites`.`car_id` and `car_favorites`.`deleted_at` isnull) as `favorite_count`, (selectcount(*) from `user_visit_cars` where `cars`.`id` = `user_visit_cars`.`car_id` and `user_visit_cars`.`deleted_at` isnull) as `user_visit_car_count` from `cars` where `stock_location_id` in (2) and `cars`.`status` in (1) and `cars`.`deleted_at` isnullorderby `updated_at` desc limit 25offset0
selectsum(`user_visit_car_count`) as aggregate from (select `cars`.*, (selectcount(*) from `user_visit_cars` where `cars`.`id` = `user_visit_cars`.`car_id` and `user_visit_cars`.`deleted_at` isnull) as `user_visit_car_count` from `cars` where `status` =1and `deleted_at` isnulland `cars`.`deleted_at` isnullhaving `user_visit_car_count` >0) as `temp_table`
selectcount(*) as aggregate from (select `cars`.*, (selectcount(*) from `user_visit_cars` where `cars`.`id` = `user_visit_cars`.`car_id` and `user_visit_cars`.`deleted_at` isnull) as `user_visit_car_count` from `cars` where `status` =1and `deleted_at` isnulland `cars`.`deleted_at` isnullhaving `user_visit_car_count` >0) as `temp_table`
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4422and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4383and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4382and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4381and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4380and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4379and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4377and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4376and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4375and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4374and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4372and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4371and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4370and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4369and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4368and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4367and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4366and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4365and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4364and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4363and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4361and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4360and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4359and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull
selectcount(*) as aggregate from `user_visit_cars` where `user_visit_cars`.`car_id` =4358and `user_visit_cars`.`car_id` isnotnulland `user_visit_cars`.`deleted_at` isnull