Computing metrics fail on VBO (hiearachy too deep)

[jonquet]

Describe the bug
The metrics can't be computed on VBO

To Reproduce
Check out logs of VBO metrics process
One query times out

Expected behavior
A better query that will not time out.

Additional context
We need to see if we can improve this query.