Scalr\Model\Entity\Role::getFarmsCount PHP Метод

    public function getFarmsCount($accountId = null, $envId = null)
    {
        $sql = "SELECT COUNT(DISTINCT f.id)\n                FROM farm_roles fr\n                JOIN farms f ON fr.farmid = f.id\n                WHERE fr.role_id = ?";
        $args = [$this->id];
        if ($accountId) {
            $sql .= " AND f.clientid = ?";
            $args[] = $accountId;
        }
        if ($envId) {
            $sql .= " AND f.env_id = ?";
            $args[] = $envId;
        }
        return $this->db()->GetOne($sql, $args);
    }