Yeah, it's almost always more intention-revealing to use CTEs and WHERE EXISTS.