$query = "SELECT g.country_code, g.country_name, g.region_code, g.region_name, g.neighbourhood, g.id, 
                X(g.point) AS lat, Y(g.point) AS lon, g.timezone, COUNT(*) AS count,
                GROUP_CONCAT(i.id) AS image_ids, CONCAT('/place?lat=', X(g.point), '&lon=', Y(g.point)) AS url
            FROM image AS i
            LEFT JOIN geoplace AS g ON i.geoplace = g.id