use in clause to speed up query requests
remove unused methods
Merge pull request #1401 from marcel-blonk/PLFM-2883

use in clause to speed up query requests