select.river.id = SELECT id FROM rivers where lower(name) = lower(:name)
