I also disagree with #17 Tables whose columns are not used in query should not be there in joins.

I have used columns in joins even if they aren't used else where in the query.  The JOIN may be the only place columns may be used in a query depending on the data and the tables.