Count on joint tables if....

[isedeasy]

$user = mysql_fetch_array(mysql_query("
        SELECT
        u.id,
        u.username,
        u.date_registered,
        COUNT(a.id) AS a_qty,
        COUNT(b.id) AS b_qty,
FROM users u
        LEFT JOIN table_a AS a ON a.user = u.id
        LEFT JOIN table_b AS b ON b.user = u.id
WHERE u.id = $id
        "));

 

Basically I want to count how many items a certain user has in multiple tables. The problem is that I only want to count the items in table_a that have a status=1 and same with table_b.

 

Is this possible or am I doing this completely wrong?

_{the above is just example code}

[isedeasy]

 

$user = mysql_fetch_array(mysql_query("
        SELECT
        u.id,
        u.username,
        u.date_registered,
        COUNT(a.id) AS a_qty,
        COUNT(b.id) AS b_qty,
FROM users u
        LEFT JOIN table_a AS a ON a.user = u.id  AND a.status= 1
        LEFT JOIN table_b AS b ON b.user = u.id  AND b.status= 1
WHERE u.id = $id
        "));

 

Just worked it out