SELECT users.id, users.name, fault.faultref as c
FROM users LEFT JOIN fault
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