Comment by thom

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