use in clause to speed up query requests
remove unused methods
Merge pull request #1402 from marcel-blonk/release-49

Release 49