query hell

query.js

// Getting all sessions by secondary index on client_id field, but excluding one client_id, so I return every client id from the clients table but the one not desired

r.db("aidax").table("sessions").getAll(
	r.args(
      r.db("aidax").table("clients")
      .filter(
        function(client) {
           return client("id").ne("0f338aa9-0d16-4e00-8301-f5ddabf313de")
        }
      ).map(function(client) {
        return client("id")
      }).coerceTo('array'))
    ,{index: "client_id"}
  )

r.db("aidax").table("clients")('id')
 .filter(r.row.ne("0f338aa9-0d16-4e00-8301-f5ddabf313de"))
 .map(function(client_id){
   r.db("aidax").table("sessions")
    .getAll(client_id, {index: 'client_id'})
    .concatMap(function(x){ return x; })
 })

r.db("aidax").table("sessions").filter(r.row('client_id').ne("0f338aa9-0d16-4e00-8301-f5ddabf313de"))