gistfile1.js

'use strict';

var Sequelize = require('sequelize');
var sequelize = new Sequelize('mysql://[email protected]/test');
var Promise = require('bluebird');
var Person;
var PersonRole;
var Role;
var Product;
var Account;

init().then(function() {
    return Promise.all([
        Person.create({}),
        Role.create({}),
        Account.create({}),
        Product.create({ key: 'example' }),
        PersonRole.create({})
    ]).spread(function(person, role, account, product, personRole) {
        return [
            role.setAccount(account),
            role.setProduct(product),
            personRole.setRole(role),
            personRole.setPerson(person)
        ];
    }).spread(function() {
        return Person.find({
            include: {
                model: PersonRole,
                as: 'personRoles',
                include: {
                    model: Role,
                    include: [
                        {
                            model: Product,
                            where: { key: 'example' }   // Remove this and it works
                        }
                    ]
                }
            }
        });
    }).then(function(person) {
        console.log(JSON.stringify(person, null, 2));
    });
});



function init() {
    return Promise.resolve().then(function() {
        Person = sequelize.define('person', {});
        PersonRole = sequelize.define('person_role', {});
        Role = sequelize.define('role', {});
        Product = sequelize.define('product', {
            key: { type: Sequelize.STRING }
        });
        Account = sequelize.define('account', {});

        Account.belongsToMany(Product, { as: 'products', through: 'account_product' });
        Person.hasMany(PersonRole, { as: 'personRoles' });
        PersonRole.belongsTo(Person);
        PersonRole.belongsTo(Role);
        Role.belongsTo(Account);
        Role.belongsTo(Product);

        return sequelize.sync();
    });
}

gistfile2.js

'use strict';

var Sequelize = require('sequelize');
var sequelize = new Sequelize('mysql://[email protected]/test');
var Promise = require('bluebird');
var Person;
var PersonRole;
var Role;
var Product;
var Account;

init().then(function() {
    return Promise.all([
        Person.create({}),
        Role.create({}),
        Account.create({}),
        Product.create({ key: 'example' }),
        PersonRole.create({})
    ]).spread(function(person, role, account, product, personRole) {
        return [
            role.setAccount(account),
            role.setProduct(product),
            personRole.setRole(role),
            personRole.setPerson(person)
        ];
    }).spread(function() {
        return Person.find({
            include: {
                model: PersonRole,
                as: 'personRoles',
                include: {
                    model: Role,
                    where: { id: 1 }
                }
            }
        });
    }).then(function(person) {
        console.log(JSON.stringify(person, null, 2));
    });
});



function init() {
    return Promise.resolve().then(function() {
        Person = sequelize.define('person', {});
        PersonRole = sequelize.define('person_role', {});
        Role = sequelize.define('role', {});
        Product = sequelize.define('product', {
            key: { type: Sequelize.STRING }
        });
        Account = sequelize.define('account', {});

        Account.belongsToMany(Product, { as: 'products', through: 'account_product' });
        Person.hasMany(PersonRole, { as: 'personRoles' });
        PersonRole.belongsTo(Person);
        PersonRole.belongsTo(Role);
        Role.belongsTo(Account);
        Role.belongsTo(Product);

        return sequelize.sync();
    });
}