SQLize Online / PHPize Online  /  SQLtest Online

SELECT posts.id_post, posts.text_post, posts.photo, posts.created_at, users.id_user, users.login, users.name, users.surname, users.avatar, COALESCE(`likes_post`, 0) AS `likes`, COALESCE(`comments`, 0) AS `comms` FROM `posts` INNER JOIN `users_connections` ON posts.id_user = users_connections.id_followed INNER JOIN `users` ON users.id_user = posts.id_user LEFT JOIN ( SELECT `id_post`, COUNT(`likes_post`.`id_post`) `likes_post` FROM `likes_post` GROUP BY `id_post` ) `likes_post` ON `likes_post`.`id_post` = `posts`.`id_post` LEFT JOIN ( SELECT `id_post`, COUNT(`comments`.`id_post`) `comments` FROM `comments` GROUP BY `id_post` ) `comments` ON `comments`.`id_post` = `posts`.`id_post` WHERE users_connections.id_follower = 2 ORDER BY `created_at`