This ```group_by```, at this place, is very dangerous: it will merge two addons with the same name. If a "group by" must be done, it may perhaps be done at the ```JOIN``` level using something like:
```
JOIN (
    SELECT * from translations
    WHERE localized_string IS NOT NULL
    GROUP BY id
) T1
ON xxxx.name = T1.id
```