hope this fix your issue Your query is wrong either way. But the reason for getting zeros as result are probably these conditions: b.userId = u.userId and b.userId = f.followed AND f.follower = u.userId. IF b.userId = u.userId and b.userId = f.followed then f.followed = u.userId
count(DISTINCT b.bookId) AS booksCount,
count(br.bookId) AS reviewsCount,
(SELECT COUNT(*) FROM Followers AS f WHERE f.followed = u.userId) AS followersCount
FROM Users AS u
LEFT JOIN Books AS b ON b.userId = u.userId
LEFT JOIN BooksReview AS br ON br.bookId = b.bookId
WHERE u.userId = 'dbb21849-ccce-4af1-aa0f-6653919bf956'