I see that since I don't know which version of MySQL the group by forces to enter all the fields of the select. (this is configurable, but I have no option to change it). I don't understand why you have to put all the fields of the select in the group by, if I only want to group by the user id for example.
If someone is kind enough to explain (for fools, with apples) the reason for this, I would be eternally grateful... I'm looking on the internet, and I don't understand the reasons they give. They say they are good practices, but until recently it could be done without problems and now... :(