select.river = SELECT id, name FROM rivers 
select.gauges = SELECT id, name FROM gauges WHERE river_id = :river_id
