Demonstrate problem with searching and relations

JOINing together all the relations excludes all records without children
from the search.
Outerjoin searches

Unless we do this, any record not being referenced by all child
relations will get excluded from the search.