select `users`.*, (selectsum(`videos`.`views`) from `videos` where `users`.`id` = `videos`.`user_id` and `videos`.`deleted_at` isnullandexists (select*from `users` where `videos`.`user_id` = `users`.`id`) and `approved` =1and (`privacy` =0or `privacy` =2)) as `videos_sum_views`, (selectcount(*) from `subscriptions` where `users`.`id` = `subscriptions`.`user_id`) as `subscribers_count` from `users` where `id` =265162
selectcount(*) as aggregate from `videos` where `videos`.`user_id` =265162and `videos`.`user_id` isnotnulland `videos`.`deleted_at` isnullandexists (select*from `users` where `videos`.`user_id` = `users`.`id`) and `approved` =1and (`privacy` =0or `privacy` =2)
selectcount(*) as aggregate from `videos` where `videos`.`user_id` =265162and `videos`.`user_id` isnotnulland `videos`.`deleted_at` isnullandexists (select*from `users` where `videos`.`user_id` = `users`.`id`) and `approved` =1and (`privacy` =0or `privacy` =2)