Group by with Sequelize

Group by with Sequelize"/>

Group by with Sequelize

我具有以下类结构：

[我正在尝试按Sequelize分组并计数，Cup_Selections表中每个选择所具有的标题等于下面键入的查询的数量：

使用Sequelize进行我的Node查询如下：

  async index(req, res) {
    const champions = await Champion.findAll({
      attributes: ['id', 'cupselection_id'],
      include: [
        {
          group: ['selection_id', 'champion.id'],
          raw: true,
          model: CupSelection,
          as: 'cupselection',
          attributes: [
            'id',
            'cup_id',
            [fn('count', col('selection_id')), 'vezes'],
          ],
          include: [
            {
              model: Selection,
              as: 'selection',
              attributes: ['id', 'country'],
            },
          ],
        },
      ],
    });

    return res.json(champions);
  }

但是向我显示以下错误：

(node:28230) UnhandledPromiseRejectionWarning: SequelizeDatabaseError: column "Champion.id" must appear in the GROUP BY clause or be used in an aggregate function

我该如何解决？

async index(req, res) { const { page = 1 } = req.query; const champions = await Champion.findAll({ limit: 5, offset: (page - 1) * 5, order: [[fn('count', col('cupselection.selection.id')), 'DESC']], attributes: [[fn('count', col('cupselection.selection.id')), 'vezes']], group: ['cupselection.selection.id', 'cupselection.selection.logo.id'], raw: true, include: [ { model: CupSelection, as: 'cupselection', attributes: [], include: [ { model: Selection, as: 'selection', attributes: ['id', 'country'], include: [ { model: File, as: 'logo', attributes: ['id', 'path', 'url'], }, ], }, ], }, ], }); return res.json(champions); }