public function getAllCountries() {
        
        $query = "SELECT l.country, g.country_name, (SELECT COUNT(*) FROM loco_livery WHERE loco_livery.country = l.country) AS num
            FROM loco_livery AS l
                LEFT JOIN geoplace AS g ON g.country_code = l.country