Working out some kinks along the subquery route.  May be subject to change to the multiple query process assuming this logic too complex.