jean3b@gmail.com wrote:
> I wanted to know if there's anyone that could help me with this
> problem. My query takes too much time to execute and I don't know how
> to make it better.
> All table have indexes and PK.

What indexes and what PKs?
You have shown us the query, but not any details of what you have already
done to optimise it?