Live cases of using DB queries with over 10 JOIN relations

Why would one use queries with 10 or more (maybe even 100+) JOIN relations?

What are some live cases of such queries used in real systems from different fields.