sascha@4075: select.river = SELECT id, name FROM rivers sascha@4085: select.gauges = SELECT id, name, official_number FROM gauges WHERE river_id = :river_id