Untitled

SELECT users.id, users.name, COUNT(fault.faultref) as c
FROM fault LEFT JOIN users
ON fault.ownerid = users.id
WHERE users.teamid = 1
AND fault.resolved IS NULL
AND fault.lastclosed IS NULL
AND users.id != 1
AND users.holiday IS NULL
GROUP BY fault.ownerid