Untitled

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