HOTFIX: improve performance of get reports query