Reduce number of unnecessary count queries

[ScopeyNZ]

Recently #173 added count queries when using the SQL endpoint so that the record count could be fetched to correctly display the pagination. The record count changes when filters are updated but not when page numbers are changed or sorting is applied but we still get an additional count query.

We should not query for a count when sorting or changing page numbers.