public function getAllSosaWithGenerations(){
        if(!$this->is_setup) return array();
        return Database::prepare(
            'SELECT majs_i_id AS indi,' .
            ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' .
            ' FROM `##maj_sosa`' .
            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' .
            ' GROUP BY majs_i_id'
        )->execute(array(
            'tree_id' => $this->tree->getTreeId(),
            'user_id' => $this->user->getUserId()
        ))->fetchAssoc();
    }