its weird how do i do sql_mode=only_full_group_by or is there a universal way to make the query work

This is not the problem / the way to solve it. Your SQL is wrong, in the way the error explains. Did you pay attn to it? What do you think it might mean? Serious questions. What is the error message telling you?