corrected count query to not use order by

- [x] finish the code
- [x] gather feedback for my changes


| Q             | A
| ------------- | ---
| Bug fix?      | yes
| New feature?  | no
| Tests pass?   | no
| Fixed tickets | none
| Doc           | none