Thanks for the advice. My query is a little more controlled than the cases exposed in the article.

I use an equal join and only >= inside the same ID, which reduces the product.

Besides, I rarely use subqueries in the SELECT clause, only the in the FROM clause. I know it doesn't make any difference but the former seems to be more keen to getting out of control than the latter. By using subqueries in the FROM clause you get more concious of the cardinalities involved in your joins.