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