SQL Error on product page

We are having a problem viewing the products page after adding many products with attachements.
It was working well to start with and then it broke, We cannot view any product page and the error seems to point to the SQL query, complaining about deeply nested query.

Hi Rafiq,

I have already replied to your email, please have a look!
There could be a problem with the query but we will have to investigate it.
I will keep this thread updated with whatever we find but we will have to communicate via email
because of website access credentials, etc.

Best Regards