API page: https://api.drupal.org/api/drupal/includes!database!select.inc/function/...
I found that SelectQuery::join returns $alias so this makes it NOT Chainable also we don't really need a parameter string returned back.
I haven't checked why it works currently this way, what could it's benefit be also theoretically I think this function should return $this as other functions in this class do.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.