Remove deprecated Query.manual

kill deprecated Query.manual

- replace uses with Query.auto
- massive code removal!