I'm sure there is a better and more efficient way, but this is how I did it:
Very curious about performance impacts of this query now, would appreciate any insight.