Hi, thanks for quick reply.
I found a solution : to solve the sql issue I tried to add an instruction inside mysql.conf file (/etc/mysql/mysql.conf.d/mysqld.cnf).
In the Basic Settings block, I added :
sql-mode=""
It seems when some queries contains group by we should only select columns from the table we are grouping by, but if not, we ought to use the any_value() function to call the columns from other table.
I mark this post as RESOLVED if it should serve anyone to solve this issue.
Thanks