edited to grab the whole thing in 1 sql query using a FULL JOIN