diff options
| -rw-r--r-- | routes/admin.js | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/routes/admin.js b/routes/admin.js index a2d07178..a2055c7c 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -207,7 +207,7 @@ router.get( transactions = transactions .select( - knex.raw('COUNT(' + types[i] + '.id) as ' + types[i]), + knex.raw('COUNT(DISTINCT ' + types[i] + '.id) as ' + types[i]), knex.raw('LEFT(MAX(' + types[i] + '.updatedAt), 10) as ' + stamp) ) .leftJoin(types[i], 'users.id', types[i] + '.user_id') |