fix only_full_group_by mysql default behaviour

1 files changed, 1 insertions, 1 deletions

diff --git a/includes/model/UserAngelTypes_model.php b/includes/model/UserAngelTypes_model.php
index 11366cdf..410a292f 100644
--- a/includes/model/UserAngelTypes_model.php
+++ b/includes/model/UserAngelTypes_model.php
@@ -59,7 +59,7 @@ function User_unconfirmed_AngelTypes($user) {
       AND `UserAngelTypes`.`supporter`=TRUE
       AND `AngelTypes`.`restricted`=TRUE
       AND `UnconfirmedMembers`.`confirm_user_id` IS NULL
-    GROUP BY `UserAngelTypes`.`angeltype_id`
+    GROUP BY `UserAngelTypes`.`angeltype_id`, `UserAngelTypes`.`id`
     ORDER BY `AngelTypes`.`name`");
   if ($result === false) {
     engelsystem_error("Unable to load user angeltypes.");