GEANT / CAT

            $federations = $handle->exec("SELECT DISTINCT UPPER(institution.country) AS country FROM institution JOIN profile

                          ON institution.inst_id = profile.inst_id WHERE profile.showtime = 1 ORDER BY country");

            // SELECT never returns a boolean, always a mysqli_object

            while ($activeFederations = mysqli_fetch_object(/** @scrutinizer ignore-type */ $federations)) {

                $fedIdentifier = $activeFederations->country; // UPPER() has capitalised this for us

                $returnArray[$fedIdentifier] = isset($this->knownFederations[$fedIdentifier]) ? $this->knownFederations[$fedIdentifier] : $fedIdentifier;

            }

        } else {

            $returnArray = $this->knownFederations;

        }

            $federations = $handle->exec("SELECT DISTINCT UPPER(country) AS country FROM view_active_idp_institution ORDER BY country");

            $timeEnd = microtime(true);

            $timeElapsed = $timeEnd - $timeStart;

            while ($eduroamFederations = mysqli_fetch_object($federations)) {

                $fedIdentifier = $eduroamFederations->country;

                $returnArray[$fedIdentifier] = isset($this->knownFederations[$fedIdentifier]) ? $this->knownFederations[$fedIdentifier] : $fedIdentifier;

            }

            asort($returnArray, SORT_LOCALE_STRING);

            $returnArray['time'] = $timeElapsed;

        }