Hi @Shua42 
I can confirm that the EXISTS/NOT EXISTS query is working as expected now in the 15.4 LTS . Thank you for fixing it so quickly!

But the subquery issue still NOT fixed. Before I was getting two rows (that is incorrect). Now I'm getting an error: