Query without joins runs fine (super slow tho, hundreds of queries run sequentially):

And with a join it simply ignores that find for some reason and ends up not returning data for that node:

Note that the first join at the category level is working as expected, a single query returns all the categories + products. I wan't the same for all the product options in a product but it just works by running 1:N queries. Any idea what I'm doing wrong?