only return hosted balances

1 files changed, 4 insertions, 2 deletions

diff --git a/routes/info.js b/routes/info.js
index 6c2c601d..f3de8907 100644
--- a/routes/info.js
+++ b/routes/info.js
@@ -38,12 +38,14 @@ app.get("/info", async (req, res, next) => {
 app.get("/balances", async (req, res, next) => {
   try {
     const accounts = await db.Account.findAll({
+      where: {
+        pubkey: null
+      },
       attributes: [
         "asset",
-        "pubkey",
         [sequelize.fn("sum", sequelize.col("balance")), "total"]
       ],
-      group: ["asset", "pubkey"]
+      group: ["asset"]
     });
 
     let lnchannel;