How do I turn this slick method into a subquery?

gistfile1.scala

        val myRank = (session: Session) => {
          val mine = Ratings.filter(_.userId === user.id).map(mapper).
            first()(session)
          Ratings.filter { mapper(_) > mine }.map(_.length + 1)
        }