I have total 6 tables in which different info has been saved

Now i need a result in which get count from 5 tables and select all info from main table but if record does not exist than it must be need to return 0 instead of no row found that's the problem here

I have tried below query but didn't get success

```
SELECT 
    u.*,
    COUNT(DISTINCT  c.id) as comments,
    COUNT(DISTINCT d.id) as dislikes,
    COUNT(DISTINCT l.id) as likes,
    COUNT(DISTINCT s.id) as shares,
    COUNT(DISTINCT t.id) as tags
FROM 
    job_details as u
    JOIN job_comments as c ON u.id = c.job_id
    JOIN job_dislike as d ON u.id = d.job_id
    JOIN job_like as l ON u.id = l.job_id
    JOIN job_share as s ON u.id = s.job_id
    JOIN job_tags as t ON u.id = t.job_id
WHERE 
    u.id = c.job_id AND
    u.id = d.job_id AND
    u.id = l.job_id AND
    u.id = s.job_id AND
    u.id = t.job_id

GROUP BY 
    u.id

```

This query is executed, but didn't get exact result.
I don't quite understand why.

I was hoping somebody here could help me out?

Thanks!