When having a query like the following, the sql is missing the join fragment for child join nodes of an entity join leading to an SQL error.