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.
I walked out of American Pie, which I entered by mistake. Got it confused with American Beauty. Talk about culture shock.