knex
  .with('author_books', knex('books').where('author_id', 100))
  .with('author_books_deleted', knex('author_books').whereNotNull('deleted_at'))
  .select('*')
  .from('author_books_deleted');