public function getNumPhotosByRegion() {
        
        $query = "SELECT g.country_code, g.country_name, g.region_code, g.region_name, COUNT(*) AS count
            FROM image AS i
            LEFT JOIN geoplace AS g ON i.geoplace = g.id