Just found a nasty bug, it seems QoQ in Lucee won’t do joins on queries with numeric datatypes
Just noticed that SQL Server resultsets (queries) with Numeric(18,0) ids won’t join in QoQ
https://luceeserver.atlassian.net/browse/LDEV-2470
there’s a dirty workaround in the second trycf example in the first comment