Fixed row count when selects have group by in them

When using data-tables with a query that has a groupBy statement the count returns a number that is related to the count of the group instead of the count of the entire rows. This causes the pagination to be inacurate