SQL mode ONLY_FULL_GROUP_BY not supported

[dontub]

Currently there are queries that require the SQL mode ONLY_FULL_GROUP_BY. These queries should be changed so that this SQL mode can be used.

For production sites the CiviCRM documentation recommends to disable ONLY_FULL_GROUP_BY.