In our case it's a MySQL database.

How did you decide on 6 joins? And do the sizes of the to be joined tables matter?