select count(user_article_likes.article_id) as likes from `articles` inner join `user_article_likes` on `user_article_likes`.`article_id` = `articles`.`id` group by `articles`.`id`;

select count(subscribed_user_articles.article_id) as subscribed from `articles` inner join `subscribed_user_articles` on `subscribed_user_articles`.`article_id` = `articles`.`id` group by `articles`.`id`;

SELECT COUNT(subscribed_user_articles.article_id) AS subscribed, COUNT(user_article_likes.article_id) AS likes FROM `articles`
INNER JOIN `subscribed_user_articles` ON `subscribed_user_articles`.`article_id` = `articles`.`id`
INNER JOIN `user_articles_likes` ON `user_articles_likes`.`article_id` = `articles`.`id`
GROUP BY `articles`.`id`

select
articles.id,
count(distinct user_article_likes.article_id),
count(distinct subscribed_user_articles.article_id)
from articles
left join  user_article_likes on user_article_likes.article_id = articles.id
left join subscribed_user_articles on subscribed_user_articles.article_id = articles.id
group by articles.id