"JOIN"-ing information from multiple categories ???
From semantic-mediawiki.org
Fragment of a discussion from Help talk:Displaying information
Property chains with the syntax Has location.Has coordinates work in conditions, but unfortunately not in columns (and why?).
You can use template format instead, with a template containing a {{#show:}}
call. Yes, the performance will be terrible.