How to get rid of error with sql_mode?

Question

MySQL

There is an error:

I solve it:

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

But it does not disappear forever, after some time it returns.
Is it possible to get rid of it forever?

Answer 1

rewrite the original request correctly