I realize this isn't the most elegant sql. I modified this query where the original query only selected from a sing