Please ignore previous comment about join. The order actually depends on whether the  relation is the 1 or the n.

Implemented a lot of queries. Pretty much all Data should be displayed correctly.