Sequelize 'where'条件以'AND'而不是'WHERE'开头

这没有意义 . Sequelize创建一个以AND而不是WHERE开头的where条件 .

我正在尝试执行此查询：

var query = {
            limit: 10,
            order: [
                ['id', 'DESC']
            ],
            //attributes: ['id', 'name', 'supplier_id', 'created_at', 'url'],
            include: [
                {
                    required: false,
                    model: models.termTaxonomies,
                    include: [{
                        model: models.term
                    }, {
                        attributes: ['id'],
                        model: models.taxonomy
                    }],
                    where: ["termRelationships.product_id IS NULL"],
                },
                models.image,
                models.supplier
            ],

        };

在使用Product.findAll（query）执行上述查询后，在下面创建SQL .

SELECT "product".*
    ,"termTaxonomies"."id" AS "termTaxonomies.id"
    ,"termTaxonomies"."taxonomy_id" AS "termTaxonomies.taxonomy_id"
    ,"termTaxonomies"."term_id" AS "termTaxonomies.term_id"
    ,"termTaxonomies"."parentId" AS "termTaxonomies.parentId"
    ,"termTaxonomies"."hierarchyLevel" AS "termTaxonomies.hierarchyLevel"
    ,"termTaxonomies"."distance" AS "termTaxonomies.distance"
    ,"termTaxonomies.termRelationships"."product_id" AS "termTaxonomies.termRelationships.product_id"
    ,"termTaxonomies.termRelationships"."term_taxonomy_id" AS "termTaxonomies.termRelationships.term_taxonomy_id"
    ,"termTaxonomies.term"."id" AS "termTaxonomies.term.id"
    ,"termTaxonomies.term"."name" AS "termTaxonomies.term.name"
    ,"termTaxonomies.term"."plural" AS "termTaxonomies.term.plural"
    ,"termTaxonomies.term"."sin_article" AS "termTaxonomies.term.sin_article"
    ,"termTaxonomies.term"."plu_article" AS "termTaxonomies.term.plu_article"
    ,"termTaxonomies.taxonomy"."id" AS "termTaxonomies.taxonomy.id"
    ,"images"."id" AS "images.id"
    ,"images"."deal_id" AS "images.deal_id"
    ,"images"."image" AS "images.image"
    ,"supplier"."id" AS "supplier.id"
    ,"supplier"."name" AS "supplier.name"
    ,"supplier"."url" AS "supplier.url"
    ,"supplier"."logo" AS "supplier.logo"
    ,"supplier"."clicks" AS "supplier.clicks"
    ,"supplier"."order" AS "supplier.order"
FROM (
    SELECT "product"."id"
        ,"product"."name"
        ,"product"."subtitle"
        ,"product"."url"
        ,"product"."prod_specs"
        ,"product"."prod_desc"
        ,"product"."supplier_id"
        ,"product"."created_at"
        ,"product"."updated_at"
        ,"product"."active"
    FROM "products" AS "product"
    ORDER BY "product"."id" DESC LIMIT 10
    ) AS "product"
LEFT JOIN (
    "term_relationships" AS "termTaxonomies.termRelationships" LEFT JOIN "term_taxonomies" AS "termTaxonomies" ON "termTaxonomies"."id" = "termTaxonomies.termRelationships"."term_taxonomy_id"
    ) ON "product"."id" = "termTaxonomies.termRelationships"."product_id"
    AND termRelationships.product_id IS NULL
LEFT JOIN "terms" AS "termTaxonomies.term" ON "termTaxonomies"."term_id" = "termTaxonomies.term"."id"
LEFT JOIN "taxonomies" AS "termTaxonomies.taxonomy" ON "termTaxonomies"."taxonomy_id" = "termTaxonomies.taxonomy"."id"
LEFT JOIN "images" AS "images" ON "product"."id" = "images"."deal_id"
LEFT JOIN "suppliers" AS "supplier" ON "product"."supplier_id" = "supplier"."id"
ORDER BY "product"."id" DESC;

检查第6行（ AND termRelationships.product_id IS NULL ） .

本案例的表格：

我正在尝试将所有产品与他们的供应商和产品一起提供，这些产品尚未归类（因此现在不在termTaxonomies内） .

使用sql查询很容易做到这一点，但现在我们使用的是ORM（Sequelize），我们很乐意完全使用它 . 谁可以帮助我们？

猜猜下面发布我的所有模型有点太多了所以我会尽量保持简短：

协会产品型号：

product.hasMany(_models.offer, {
    foreignKey: 'product_id'
});

                product.belongsToMany(_models.termTaxonomies, {
                    through: _models.termRelationships,
                    foreignKey: 'product_id'
                });

                product.hasMany(_models.image, {
                    foreignKey: 'deal_id'
                });

                product.belongsTo(_models.supplier, {
                    foreignKey: 'supplier_id'
                });

协会提供的模型：

offer.belongsTo(_models.product, {
                    foreignKey: 'product_id'
                });

                offer.hasMany(_models.sentDeals, {
                    foreignKey: 'offer_id'
                });

                offer.hasMany(_models.transaction, {
                  foreignKey: 'offer_id'
                });

协会供应商型号：

supplier.hasMany(_models.product, {
                    foreignKey: 'supplier_id'
                });
                supplier.hasMany(_models.scraperLog, {
                    foreignKey: 'scraper_id'
                });

协会termTaxonomies模型：

termTaxonomies.belongsToMany(_models.product, {
                    through: _models.termRelationships,
                    foreignKey: 'term_taxonomy_id',
                });

                termTaxonomies.belongsTo(_models.term, {
                    foreignKey: 'term_id',
                });

                termTaxonomies.belongsTo(_models.taxonomy, {
                    foreignKey: 'taxonomy_id',
                });