/**
    * @param int advisors id
    * @return array
    * @final
    */
    final public function getClients($advisors = null) {
        $fluent = $this->db->select("*")
                           ->select("CONCAT_WS(' ', titul, prijmeni, jmeno) AS nazevKlienta")
                           ->select("CONCAT_WS(' ', nazevSpolecnosti) AS nazevSpol")
                           ->select("IFNULL(nazevKlienta, nazevSpol) AS klient")
                           ->from(self::clientsTable);
        if(is_null($advisors))
            $fluent->where("poradce = %i", $advisors);
        return $fluent->OrderBy("zalozen DESC")->fetchPairs("id", "klient");
    }


// a píše mi to chybu Unknown column 'nazevKlienta' in 'field list'