How to use chained JOIN in N1QL

Thank you very much for the answer. Looking forward to the new version.