src/Webtrees/Module/Sosa/Model/SosaProvider.php
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();
    }
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();
    }
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 ( ) ; }
Return the list of all sosas, with the generations it belongs to

@return array Associative array of Sosa ancestors, with their generation, comma separated
Return the list of all sosas with the generations it belongs to