public function getFarmRolesCount($envId = null)
{
if ($envId !== null) {
$join = sprintf(" JOIN farms f ON fr.farmid = f.id AND f.env_id = %d ", $envId);
} else {
$join = '';
}
$usedBy = $this->db->GetOne("\n SELECT SUM(number) as result FROM\n (SELECT COUNT(*) AS number\n FROM farm_roles fr\n " . $join . "\n WHERE fr.role_id=?) t\n ", array($this->id));
return $usedBy;
}