gistfile1.coffee

    query = db.Auction.find
      where:
        id: req.params.auction
      include: [
        db.User
        db.Region
        db.Section
        { model: db.Image, as: 'thumbnail' }
        { model: db.Image, as: 'image' }
        # Seller and seller's membership info
        {
          model: db.User
          include:
            model: db.Membership
            foreignKey: 'user_id'
            where:
              group_id: req.group_id
        }
      ]

    query.success (auction) ->
      if not auction then return res.json 404, "Not found"

      # hacky: move membership from array to obj
      if auction.user and auction.user.dataValues.membership and auction.user.dataValues.membership.length > 0
        auction.user.dataValues.membership = auction.user.dataValues.membership[0]

      res.json auction