Count rows with preload relations (limit + offset)

[DZ8540]

Hello there!

I want to calculate the total taking into account all filters, the query looks something like this

await Inventory
  .query()
  .where('profile_id', profileId)
  .andWhereNotNull(itemIdColumn)
  .preload('armor', (query) => {
      query.preload('image')
    })
  .orderBy(config.orderByColumn, config.orderBy)
  .limit(config.limit)
  .offset(config.offset)
  .count('* as total')

And then i have catching error

P.S.:
Adding this not worked

await Inventory
  .query()
  .where('profile_id', profileId)
  .andWhereNotNull(itemIdColumn)
  .preload('armor', (query) => {
      query.preload('image')
    })
  .select('*')   <----- this
  .groupBy('inventories.id')      <----- and this
  .orderBy(config.orderByColumn, config.orderBy)
  .limit(config.limit)
  .offset(config.offset)
  .count('* as total')

After total will equals 1 (should be 33)

P.S.:
With .paginate everything works fine!

[DZ8540]

Use clone guys...

https://stackoverflow.com/questions/52775863/how-to-get-one-page-data-list-and-total-count-from-database-with-knex-js