diff options
Diffstat (limited to 'bucky/db/index.js')
| -rw-r--r-- | bucky/db/index.js | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/bucky/db/index.js b/bucky/db/index.js index e26124a..d3ee2ea 100644 --- a/bucky/db/index.js +++ b/bucky/db/index.js @@ -224,7 +224,7 @@ db.getKeyword = function (keyword) { return Keyword.query("where", "keyword", "=", keyword).fetch() } db.getThreadGroups = function (keyword) { - return knex.column('keyword').sum('viewed').as('viewed').column('id').column('title').column('lastmodified').column('privacy').select().from('threads').groupBy('keyword') + return knex.column('keyword').sum('viewed').as('viewed').count('*').as('count').column('id').column('title').column('lastmodified').column('privacy').select().from('threads').groupBy('keyword') } db.createKeyword = function(data){ return new db.Keyword(data).save() |