Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Find all users with specific show in their lists
- let ListIds = await ShowLists.findAll({
- attributes: ['list_id'],
- where: {show_id: showId}
- })
- ListIds = ListIds.map(result => result.list_id);
- let UserIds = await UsersLists.findAll({
- attributes: ['user_id'],
- where: {
- list_id: {
- [Op.in]: ListIds
- }
- }
- })
- UserIds = UserIds.map(result => result.user_id);
- let users = await Users.findAll({
- where: {
- id: {
- [Op.in]: UserIds
- }
- }
- })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement