You can write selects with many joins, as long they are regular and either add a column or reduce the result set. You have to write the joins explicitly though. Just shoving all of the restrictions into the where clause will definitely confuse everybody.
They are really well designed too. They lock into place when flipped 180 degrees (drinking mode) and don’t interfere at all while drinking.