problem with joins in `SearchCriteria`

[DaanHoogland]

I did a short investigation, and independent of the cause of the issue, I think I found a problem in the code: https://github.com/apache/cloudstack/blob/4.19.1.3/framework/db/src/main/java/com/cloud/utils/db/SearchCriteria.java#L103-L104 it seems line 103 is a problem (still in main as line 104 atm) Though I doubt this will be the root cause It needs addressing anyway.

Originally posted by @DaanHoogland in https://github.com/apache/cloudstack/discussions/10374#discussioncomment-13494493