Data.jsw functions working on preview mode but not on live mode. HELP

Thanks, tried that but no good. It all works properly using wixData… I am converting (well, trying to convert) wixData over to SQL. So the issue is with the SQL implementation.

Maybe it will be easier to learn how to do inner joins with WixData? Can’t say I really have a clue… SQL is easy and I have done it for years.