I am trying to get forum information and count of topics and posts. I am using mysql

```
SELECT forums.id, forums.url, forums.title, forums.description, 
       forums.icon, COUNT(topics.id) topics, COUNT(posts.id) posts 
FROM forums JOIN 
     topics 
     ON forums.id = topics.to_forum JOIN 
     posts 
     ON topics.id = posts.to_topic 

```

But when there is no forum, no topic, no posts it returns
[![enter image description here](https://i.stack.imgur.com/xgcVS.png)](https://i.stack.imgur.com/xgcVS.png)

I´ve tried to use left join, right join, inner join (as I read on internet) but nothing seems to work. The left join works only if there is forum already created than it fills the data. **I need it to return no record if there is not forum created no this NULL nonsence.**
Here are structures of the tables, there are no data in database so I dont get why it returns this

Forums
[![enter image description here](https://i.stack.imgur.com/P4W43.png)](https://i.stack.imgur.com/P4W43.png)

Topics
[![enter image description here](https://i.stack.imgur.com/pzloF.png)](https://i.stack.imgur.com/pzloF.png)

Posts
[![enter image description here](https://i.stack.imgur.com/CE3tt.png)](https://i.stack.imgur.com/CE3tt.png)