"subResults is not defined" error when using Multi reference in joined table

W 4.9.1.
NodeJS
MySQL 8

I have tables “transactions”, “parts”, “tags” and “transaction_tags”.
Last one is multi reference table, of course.
Also, “transactions” has many “parts”.

When I make select for all transactions and choose “tag” multi reference, it works nice. I see all transactions and for each of it I see all tags.


Also, when I SELECT all “parts” and JOIN “transactions” to them, it all work fine too.

But when I try to combine these tasks, I got a 500 error “subResults is not defined”.

Also getting the same error.

In my case:

  1. Joining 3 tables
  2. I think the error comes from the multi-ref table ‘users.enrolled_courses’ (which btw is renamed to ‘users.users’ when saving the query - possibly related?
  3. This is the subquery inside (when double clicking the ‘users.users’